Running Totals Question

[Besoup]

hey,
I got some running totals fields that I am trying to display in my group headers. Unfortunately the calculations are off when they are placed there. When I put them in the group footer they work fine. Is there a way I can get them to work in the header?

[wes4dbt]

What type of report designer?
What programming language?
What is the reports data source?

[Besoup]

lol sorry CRXI.

[brucevde]

Running Totals are calculated on a per record basis. At the Group Header only the group's first detail record would be included in the running total.

What exactly are you trying to achieve? If you want to print the sum of all detail records in the Group Header use a Summary formula.

[Besoup]

I am just trying to replicate a report that was generated off of an old mainframe system. I am guessing that it did all the calculations then stored them somewhere before producing the report. It is an accounts receivable ageing report. I can just add them to the footer, was just trying not to confuse the end user.

[brucevde]

Well it certainly seems that a Summary formula would work. Create a formula similar to the following and place it in the group header.

Sum ({Field name to Sum},{Same field name as Group} )

[techgnome]

But, until the member records of that group are rendered for the report, the sum in the header will be 0 (or at best the first record). That's one of the problems I have with crystal, it tries to do everything in a top-down, one pass method. It takes some creativity to get things to show up out of order.

=tg

[Besoup]

But, until the member records of that group are rendered for the report, the sum in the header will be 0 (or at best the first record). That's one of the problems I have with crystal, it tries to do everything in a top-down, one pass method. It takes some creativity to get things to show up out of order.

=tg

yeah that's what I figured... was just checking to see if anyone had a shot in the dark for me.

[techgnome]

here's you shot - global variables... peppered througth the report, add to them, delay the printing until AfterRecordsRead .... we've had to do it in CR7/8.5... it's a mess... don't know if it's still an option in XI though. If it were me, I'd try to talk the users out of having it in the header.

-tg

[brucevde]

But, until the member records of that group are rendered for the report, the sum in the header will be 0 (or at best the first record). That's one of the problems I have with crystal, it tries to do everything in a top-down, one pass method. It takes some creativity to get things to show up out of order.

Crystal passess through the data multiple times. Summary operations will print correctly in the Group Header. I do it all the time...

[Besoup]

Crystal passess through the data multiple times. Summary operations will print correctly in the Group Header. I do it all the time...

Yes summaries do... the problem is I am using conditioned running totals.

[brucevde]

So, use a Summary on a formula. Summaries are just Running Totals that are calculated at an earlier phase/pass through the data.