Supressing blank fields

rbuser

Hi,

I am designing a report but would like to "compact" information upwards if
there is no data, so i have a report with 2 DBTexts linking to 1 field name
and depending on what the value is of another field I either display the one
or I display the other, so it ends up looking like this

Column1 Column2
Risk 1
Risk 2
Risk 3
Risk 4

Is is possible to suppress the blank lines and show it like this?

Column1 Column2
Risk 1 Risk 3
Risk 2 Risk 4

I tried using a memo in the summary band and building the text up in that
but the thing is I have a shape sitting behind the respective DBTexts which
need to change colour according to the data values in these fields, so i
need to use the detail band.

Any thoughts?

Anton Bosch

nicocizik

Hi Anton,

The easiest way to do this would be to separate Column1 and Column2
information into to separate datasets. Then you could have two supbreports
side-by-side that display each column of data.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks Nico