Skip to Content
0
Apr 17, 2013 at 07:57 AM

Suppress line of information and move up other lines on crystal report if field is blank

485 Views

Hi Experts

I have a crystal report with several lines of data as below:

Label A - Data A

Label B - Data B

Label C - Data C

Label D - Data D

Label E - Data E

If there is no data in "Data B" then I want to suppress "Label B" and "Data B"

I can do this using the formula option on suppress field with ISNULL ({Data B}) on both fields and I get result below:

Label A - Data A

Label C - Data C

Label D - Data D

Label E - Data E

However I would prefer not to have the blank space and so would like the other data to move up to fill the space where suppressed data would be (as below)

Label A - Data A

Label C - Data C

Label D - Data D

Label E - Data E

Please can you let me know if this is possible, and how to do it?

Thanks
Vicky