Problem grouping in report

[Guest]

Basically I have 3 groupings
ex:
Group 1 field
Group 2 Field
Group 3 Field

Group 1 and Group 3 have null values in the entire columns of result set
being used to generate the report. This is causing the report to show no
records/data in the detail section of the report and the word 'Error" in all
grouping headers.

Is there any programmatic way to fix this or by changing the report specs
without fixing the data so these two columns are populated?

Thanks.

PS Any prompt answer will be deeply appreciated.

 

[Guest]

Use an IIF statement like this --
IIF([YourField] Is Null, "", [YourField])

Using two double quotes gives it a zero lenght entry instead of a null.