Grouping by a formula - Display Header when no info

[BreffniK]

Hello and thanks for taking the time to read my inquiry.

I have written a report that groups records according to a formula.

The formula puts each record into a status bucket. "Opened" or "Closed", for example.

If no records qualify for any one of these buckets, the Group Header (which displays the bucket name, "Opened"), does not display.

Is there any way to get this Header to display even though there are no records?

Thanks in advance for any advice!

 

[lbass]

If there are records that are null, then try something like the following for your group field:

if isnull({table.groupfield}) or
trim({table.groupfield} = "" then
"No Status" else
if {table.groupfield} = <your value> then
"Closed" else
"Opened"

-LB

 

[BreffniK]

It's not that the record is null, it's that no records meet the formula's criteria to be placed into the "Opened" bucket. I still want to display the Group Header ("Opened")even though there are no currently records in that Group.

 

[lbass]

I suppose you might insert an additional group header section "a" that displays the text "Opened" that is conditionally suppressed whenever there are records that meet the Opened criteria, but this would assume that there was at least one record in another group instance, e.g., "closed".

The more reliable method would be to create the summaries in the report footer, using text and either conditional formulas that could provide results of 0 or conditional running totals.

-LB