agregation on new report page - without query dupicate

[lonas]

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!

[MFGF]

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.