Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

CR2011 - Can we place a Running Total Field in a Header i/o Footer?

Hi everybody

I am working on a Crystal Report (vers. 2011)

It has: GH3

           Details

            GF3

I have 1 column called "Qty"

In GF3, I have a Running Total Field called X, which is reset at each change of group.

X gives the correct total so long as I place it in the footer.

If I move X from GF3 to GH3, it no longer gives the correct total.

I want X to be placed in the header GH3 instead of in GF3, as I need it for formatting purposes.

How can this be done?

Thanks a lot

Leon Lai

Tags:
replied

Hi Leon,

You don't need a Running Total to be able to do this.

Move the BELL to the GH3 and change the color formula to:

IF Sum({Qty_on_hand}, {Group_3_field}) = 0 THEN Color (255,204,204)  // very pale red

ELSE IF Sum({Qty_on_hand}, {Group_3_field}) <> 0 THEN crRed

-Abhilash

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question