Running total in Report Header not showing 2

[Jameson55]

I created a running total and a formula mutliplying that total by a set dollar amount. Both pieces of information display correctly if they are in the report footer. If I move them to the header, they won't display. I've tried using the different "evaluation times" but no dice. I've tried moving it into the page header, but then it shows the total for the previous page. I even tried setting it up as a NumberVar field, but no. Any suggestions. Jamie

 

[synapsevampire]

You used a Running Total which is based on a formula, or you added in something to the Evaluate->Use a formula, or?

Running Totals are performed at the whileprintingrecords level (read up on this) which means that they aren't available at the Report Header level as a grand total.

To do the equivalent, create a formula (Right click Formula Fields and select New) which does the math:

if not(isnull({table.numericfield})) then
{table.numericfield}* .85
else
0

Drop this field into the details section, right click it and select Insert->Summary (not a Running Total)->Sum

It will then be created at the report header.

Drag it to the Report Header.

You can now delete the formula in the details section.

-k

 

[Jameson55]

oh geez - how silly do I feel? I had already built the formula to calculate the hours, I simply needed to insert a grand total and then the formula to calculate the cost based on the grand total. Worked perfectly! It's amazing how much it helps to have someone else just open your eyes and remind you of something you already knew. I guess that's why this forum is such a great tool for those of us flying solo in the workplace. Thanks again Jamie