Show only fields that are not null in a report

[DataBug]

Hi

I have a subreport fed by a query that has 18 fields. In my report, I only want to display those fields that are not null and I'd like to display them vertically rather than horizonally. which field are not null varies from record to record so the "list" would have to dynamically change from record to record. I've beat my head against the wall and can't figure out how to do this.

TIA for any help you can offer.

 

[DataBug]

Just to clarify a little more. What I want to do is not show a field or it's label if it is null. I don't want a space for said field either. I want said field to be totally gone, not just invisible.


and, of course, if said field does contain a value, I want to display it.

and also, I am referring to fields and not records.

Hope this helps.