Surpressing Detail Section if no Records for a Specific Grouping

  • Thread starter Thread starter David Frick
  • Start date Start date
D

David Frick

I have a report that contains 3 sections: a Page Header, a Field Grouping
and a Detail section.

Sometimes there are no related records in the Detail section for a given
Field grouping. In this case, I want to surpress the Detail section and
only print the Field Grouping.

How can I do this?

For example, I want the report to look like this:

Field Grouping1
Detail record 1
Detail record 2

Field Grouping2

Field Grouping3
Detail record 1


I do not want it to look like this (i.e. with blank spaces)

Field Grouping1
Detail record 1
Detail record 2

Field Grouping2



Field Grouping3
Detail record 1


How do I surpress the blank spaces in Field Grouping 2 and 3
 
Set Can Shrink to Yes. If you have a label next to the
field that may or may not have data, put an If statement
within it to test if the other field is null, if so, then
make it "". When they are both null, the row will shrink.
 
Back
Top