Reputation: 49
I have a report with multiple groups. sometimes in some groups all field's value will be null. in that situation, I wanna this group's height become less to fit. What can I do?
Upvotes: 0
Views: 1484
Reputation: 10025
You've got a few options.. but it maybe just be simpler to remove the null records from the dataset using the 'selection expert' or amending your data source/command, SQL?
Alternatively you can look at the 'Format Editor' using formulas to 'Suppress' individual fields and in the 'Section Expert' tick 'Suppress blank sections' for the details, headers and footers.
Would that solve your problem?
Upvotes: 2