Skip to Content

Need Running Total In Group Header

I have a report where I need to perform a distinct count of records with a specified status level for multiple group levels. I am using a Running Total to perform a conditional count. The problem is that in order to display the multiple group levels in the proper order, I have to post the values in the group headers, where the running total hasn't yet calculated any value.

I tried creating a formula for the detail record that applies the condition, and then performing a distinct count on that formula, but it is counting 0 (if the condition fails) as a value, giving me a count 1 too big. I would just subtract 1 from the distinct count, but I can't count on there not actually being a valid zero value.

Fuskie

Who wonders if he is overthinking this...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 07, 2008 at 03:35 PM

    Fuskie,

    Can you create a formula in the details section that outputs 0 or 1 depending on the condition and then use a summary on that formula?

    Otherwise to display a Running Total in the Group Header you would have to insert a GH section above the existing and put a subreport in there that does the calculation and pass the value back via shared variable.

    Add comment
    10|10000 characters needed characters exceeded

    • I do not know how many elements there might be in the array. There could be any number of values for groups 1 through 4.

      Fuskie

      Who has also looked at conditional summary totals but they are only valid for dates, time and boolean...