I have created a crosstab report, but I wanted to filter the records (rows) I see. Nothing in my arsenal seems to work, except querying the table ahead of time and deleting records that do not match my specifications. Is there any sort of limiting action that can be performed on a crosstab?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
crosstab reports and limiting views
- Thread starter JBirdieH
- Start date
JBirdieH,
Not without saving the crosstab table first. Crosstabs are in-memory tables until they're actualy saved. You need indexes to setRanges and it's not trivial to create indexes on in-memory tables.
Since crosstabs are basically queries, I would probably to the selection/filtering before the crosstab and then crosstab the results on that. Should improve performance, depending on how you do it.
Hope this helps...
-- Lance
Not without saving the crosstab table first. Crosstabs are in-memory tables until they're actualy saved. You need indexes to setRanges and it's not trivial to create indexes on in-memory tables.
Since crosstabs are basically queries, I would probably to the selection/filtering before the crosstab and then crosstab the results on that. Should improve performance, depending on how you do it.
Hope this helps...
-- Lance
- Status
Similar threads
- Locked
- Question