If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum of every page in a report
I have a multi page report which includes a field to calculate the
[Qty]*[Rate]. I would like to have a sum shown at the bottom of each page and a grand total at the end of the report. Can anyone suggest how to sum the [ExtendedCost] at the end of each page? |
#2
|
|||
|
|||
Sum of every page in a report
Reva
depending on grouping and report setup and im sure lots of other stuff Try a control on your reports page footer for =sum([name of your details control with qty*Rate]) and same thing in the reports footer. but i am not exactly sure about your page breaks ext.. or create a new report with the report wizard and check out the "Summary Options" button when it asks you about sorting and see how the wizard does it "Reva" wrote: I have a multi page report which includes a field to calculate the [Qty]*[Rate]. I would like to have a sum shown at the bottom of each page and a grand total at the end of the report. Can anyone suggest how to sum the [ExtendedCost] at the end of each page? |
Thread Tools | |
Display Modes | |
|
|