Want Sum to appear in Page Header

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I have a page header section and want the sum of sales
that currently appears in my Sales footer to also appear
in my page header. Is there a way to make this happen?

Thanks,

Chuck
 
Hi Chuck.
The only way to do so is by creating a summing query and include this in the
source data for your report.
If the data in your sales footer is grouped by sales person, that you would
create a summing query grouped by sales person, you would than include the
summing query in your report data source linked to the other data source by
the sales persons ID.
Now every record in your source data will include a SomOfSales field which
you can now palce in your page header.
Hope this helps.
Fons
 
Back
Top