Set default view of pass-through query

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I've seen in other posts that in order to have a query open in Pivot
Table view by default you can set the default view property in the
query properties. Does anybody know a way to do this with a pass-
through query as there is no default view property listed in the query
properties.

Thanks
Rob
 
Rob,

To get the effect you want, I think you are going to have to use the
pass-thru query as the data source for another query. Then set the default
view property of your second query the way you want it.
 
Rob,

To get the effect you want, I think you are going to have to use the
pass-thru query as the data source for another query. Then set the default
view property of your second query the way you want it.
Click to expand...

yeh - that's what I thought. I was looking for a way to do it all in
one query to keep the database tidier. It seems a bit of a waste
having to have a query as a 'viewer' wrapper. If there is a way round
it, it's a really nice way of getting crosstab-esque functionality
onto a SQL Server pass-through query all in one query.

we can only dream...
 
Back
Top