Printing Total on last page

[titans4771]

How can I get my total to only print on the last page of the report. I went into Section Expert, Suppress but not sure how to tell it to print on last page.

Thanks,

 

[lbass]

In design view, drag the inserted summary or formula into the report footer.

-LB

 

[titans4771]

It is an invoice that I have created and I only want the total to display in the page footer, not the report footer; is there a way to accomplish this?

 

[lbass]

Can you explain why you want it in the page footer versus the report footer? Are there multiple invoices in the report? If so, create a formula like this, assuming a group on invoice:

sum({table.invoice},{table.group})

Place this in the page footer and then right click on it->format field->suppress->x+2 and enter:

{table.invoice} = next({table.invoice})

-LB

 

[titans4771]

Yes there are multiple grouping on invoices based on the store no. associated with the invoice. If I put it in the report footer it will display the overall total after each store grouping which will be misleading.

 

[lbass]

I meant for the formula to be:

sum({table.invoiceamount},{table.invoicegroup})

Create this in the field explorer->formula->new and drag it into the page footer and then format it as noted earlier.

-LB