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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Headers/Design 4
"Continued" in Header and Repeat Footers 1
Running Sum 13
Sum For Each Director 3
page header on second page of invoice. 3
Prevent skip to new page after last page prints 3
Parameter Report with a Chart in the footer 1
Calculating two values that are in different records 5

Back
Top