Set default view of pass-through query

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
 
D

Dale Fye

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.
 
R

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.
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...
 
Top