Sum Totals in Report Header

[former_member1101825]

Team:

I currently have a Formula (A-Green) in the Report Header and it displays just like the one in Report Footer (A-Red). I have another Formula (B-Green) that will not display correct sum amount. The formula (B-Red) in the footer does display and is using this formula:

(Sum of @Amount Requested from State) with the following condition for (B) - Trim({table.field}) ="Grand Jury"

I'm missing the correct Crystal Syntax for (B). I have included screen shot to show visuals of design view and Preview:

[Former Member · Accepted solution]

You can not use Running Totals in Report or Group headers as they are print time totals, that is report must run through data and build running total.

Create new formula

@GrandJury

If Trim({DALLAS_REIMBURSEMENT_REQUEST_VIEW.Pool_Type = "Grand Jury" then @{Amount Requested from State} else 0

You can then add normal Sum summary which can be used in either header or footer. Repeat for Petit Jury.

Ian