Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can't place a sum field in the page header

Status
Not open for further replies.

darahw

Technical User
Feb 27, 2003
74
US
I have a sum field ({invoice.grand_total_client}+ {invoice.intrest}) that I would like to be in my page header in addition to the bottom of my report.

Can someone tell me how to get the sum field in the page header of my report?

Thanks,

Dara
 
You can't, though you may cheat it by creating an all encompassing group based on a formula, and setting the repeat group header for all pages on for this group and using it in lieu of the page header.

The all encompassing group formula would have something like:

If {table.textfield} = "~~ZZ~~QZ~" then
"Won't happen"
Else
"All encompassing"

This would be the outer group, allowing you to move your subtotals created, or to create subtotals based on an inner grouping into it.

Tested on ver 8.5

-k
 
Thank you VERY much!

What if I was doing a statement and needed the value to reset at the end of the particular client?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top