cancel
Showing results for 
Search instead for 
Did you mean: 

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

vicky_williams
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Vicky,

Would it be possible for you to create sections for these labels?

If yes, then you can suppress section when blank and it should work..

Thanks,

Joseph

vicky_williams
Participant
0 Kudos

Perfect Thanks

Answers (0)