Eliminating Blank Rows from Detail Section

[mwake]

I'm using CR2008 and an Oracle db is my data source. I am creating a registration detail report by drug product, which looks like this:

Drug Product: Aspirin 10mg
Indication: Used for fever and headaches
Package: Blister 50
Shelf Life: 6 months
Storage Condition: Keep in cool dry area
Primary Mfg: Smith Mfg

However, if a field is null, I get this:

Drug Product: Aspirin 25mg
Indication: Used for fever and headache
Package: Blister 50
Shelf Life: 6 months

Primary Mfg: Smith Mfg

How do I eliminate the blank row(s) if the one or more of the fields is null?? I only want to return rows that actually have data...

 

[IanWaterman]

In section expert check suppress blank section.

Ian