Okay I haven’t done this in ages. And it seems different in CR XI R2, but then maybe I am crazy!
I need to take a display a running total in a report header. I used to be able to fake this out with another formula that referenced the running total. But the running total is in the RT Wizard not a manual.
can someone assist?
Thanks!
muffntuf 
(BOB member since 2006-01-04)
The calculation of a Running Total field is determined by the settings selected in the Running Total Expert. However, where you place the running total affects the value that appears on the report. For example, if a Running Total field that evaluates every record and never resets (a grand total) in the Report Header, only the value of the first record will appear. Placing the same Running Total field in the Report Footer returns the desired value. The Running Total field is properly calculated in both cases, but it is displayed too soon in the first case.
The following list summarizes the records that are included in the calculation when a running total is placed in various report sections. This list assumes the running total is not reset.
Report Header
The first record in the report
Page Header
All records up to and including the first record on the current page
Group Header
All records up to and including the first record in the current group
Details
All records up to and including the current record
Group Footer
All records up to and including the last record in the current group
Page Footer
All records up to and including the last record on the current page
Report Footer
All records in the report
blair 
(BOB member since 2006-11-17)
Thank you I understand the reporting passes and where stuff occurs. The heart of the issue is faking out the report footer display by displaying it in the report header. We used to be able to do this in previous versions with another formula that referenced the report footer formula. That is what I am after.
muffntuf (BOB member since 2006-01-04)
I don’t remember doing this in an earlier version and I go back to v4 of Crystal.
The older running totals get reset to 0 in hte report header so it is not possible to display the end result in the same section.
A subreport (placed in tjhe report Header) showing only the running total value in the footer section would work if the read of the database doesn’t take too long.
blair (BOB member since 2006-11-17)
I got back to WinSQL (WinCrystal) LOL! I remember doing this, but without the aid of a subreport. I just have to play somemore than.
Thanks!
muffntuf (BOB member since 2006-01-04)
Did you ever figure this out? I know that I had done it also a long while ago, but can’t remember how and need to do it.
Thanks for any help you can give.
dmnorman (BOB member since 2005-03-03)