Display As Pivot Table with Pass Through Query

[Datech]

When you want to display the results of a query in pivot table mode in a form, you set the Default View or the query to Pivot Table and then put a subform in your form to display it. When I try to do that with a passthrough query, that setting is no where to be found.



I know very little about MSSQL Server, so should I be configuring the pivot table server side and displaying it another way in Access, or am I missing a setting on this query?

[TheShabz]

save the passthrough query, then have another regular select query that's basically a SELECT * FROM the passthrough query. save that in pivot table view and you should be good to go.

[Datech]

save the passthrough query, then have another regular select query that's basically a SELECT * FROM the passthrough query. save that in pivot table view and you should be good to go.

Thanks! There should not be too many performance issues with this correct? The passthrough query will be the same for almost everyone, and the local processing to pull it to the new query shouldn't be too different between clients, right?

[TheShabz]

you'd only have issues with a slow network and huge datasets. otherwise, you're fine.