Hi,
could You tell me how can I achive this:
1. I need to have 2 report pages:
- first page with data
- second page with data agregation
I would like to have only one query - actuall when I'm making summary on agregation page, my query is duplicated.
Thanks in advance!
How are you adding the aggregations to the second page? Using a new list/crosstab/chart etc?
If so, you can select the relevant list/crosstab/chart and change the Query property to point to the query you are using to drive the content on page one.
Just one question, though - why is having two queries in your report bad? Even if you point all your data containers (list/crosstab etc) to the same report query, under the covers a separate database query will be fired off for each. This is by design.
MF.