Forcing Groups Headers to appear when there is no data in them

[Former Member]

I have a grouping (Revenue Code) that in various reports will only have data for 3 of the 6 values but I still need the Group Header to appear. I thought that manually putting them in a specific order would work, but it doesn't. Any ideas?

- Paul

[Former Member · Accepted solution]

I have a couple of ideas, neither of them are really ideal solutions, and they're just 'off the top of my head' ideas, as I'm actually looking for the answer to this question myself.

The way I see it, there are a couple of options.

1) If you are using a stored procedure to pull records you can 'dummy' in a record with a value that satisfies the grouping conditions, and supress the dummy record in your report. (uuuugly)

2) modify your select expert/table joins to allow in at least one record that satisfies each of the report header conditions, and supress the records in the report. also ugly...

I don't like either of those solutions.

If I come up with something else, i'll be sure to post it.

[Former Member]

You are going to have to have a row for the group entry even if there is no detail data for that entry. You may need to mess around with the join (left outer) so that the data query returns all six group rows.

Fuskie

Who has often found it difficult to get Crystal to report on what's not there...

[Former Member]

You mean like if there is no data for Revenue Code then create a formula

and place it in the group header (...or group on it)

@GHeader

If IsNull(Rev_Cde) or Rev_Cde = "" Then

"" //you can put spaces or "No Header" or ?? here

Else

Rev_Cde

Is that what you mean ?

The Panda