Report design - how to get sums in Header instead of footer
Sometimes it's necessary to put sums in header instead of more natural place, footer.
If you don't have grouping, it should look like this:
1) create formula field that you will put in report header
2) Important: put WhilePrintingRecords on the top of the formula
3) put formula in Report Header
If you do have groups, you should add group field {field2} into the sum:
If you don't have grouping, it should look like this:
1) create formula field that you will put in report header
2) Important: put WhilePrintingRecords on the top of the formula
WhilePrintingRecords
Dim total As Number
total = sum({field1})
formula = total
3) put formula in Report Header
If you do have groups, you should add group field {field2} into the sum:
WhilePrintingRecords
Dim total As Number
total = sum({field1}, {field2})
formula = total