Gordon Hughes
asked on
Removing data lines
I have a crystal report
With some fields that do not contain data
I would like to suppress these and move other data up in it's place
Ie
Address 1
Address 2
Town
so I may not have any data for address2 so rather than a gap, can I then see, with no gap
Address1
Town
Gordon
With some fields that do not contain data
I would like to suppress these and move other data up in it's place
Ie
Address 1
Address 2
Town
so I may not have any data for address2 so rather than a gap, can I then see, with no gap
Address1
Town
Gordon
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
yes you need to create a new formula. check https://kb.blackbaud.com/articles/Article/41726
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All
Thanks for your support
Gordon
Thanks for your support
Gordon
FWIW, if you put the fields in separate sections (with nothing else in the section), then you should be able to just use the "Suppress blank section" option in the Section Expert to suppress those sections, rather than creating a suppression formula. Either one works. "Suppress blank section" is just a bit easier.
James
James
ASKER
Hi James
That is what I am doing
Thanks
Gordon
That is what I am doing
Thanks
Gordon
Well, if there is nothing else in that section, then what James suggested would definitely work.
But, in case, you want to display a label for each of those fields, then the section won't be blank.
That's why I suggested to use section expert level suppression.
But, in case, you want to display a label for each of those fields, then the section won't be blank.
That's why I suggested to use section expert level suppression.
ASKER
Do I create a new formula for this and if so where do I put it?
Gordon