Suppress blank line
Say you have, in a column in the Details Band, 4 fields such as
Name
Address1
Address2
City, State Zip
Sometimes there will be an Address2, sometimes there will not.
So, when the underlying table has null or empty string for the Address2
field,
How do I work it in ReportBuilder so that there is not an ugly gap in the
report column for these address elements?
What I am doing now, is putting the City, State Zip info into the Address2
spot when Address2 is blank, then making the
spot for City, State Zip be blank. All this does is move the ugly blank to
the bottom of the row, so it is not quite so
ugly, but still not acceptible.
Is there a way to do this in ReportBuilder?
Thanks,
Jon
Name
Address1
Address2
City, State Zip
Sometimes there will be an Address2, sometimes there will not.
So, when the underlying table has null or empty string for the Address2
field,
How do I work it in ReportBuilder so that there is not an ugly gap in the
report column for these address elements?
What I am doing now, is putting the City, State Zip info into the Address2
spot when Address2 is blank, then making the
spot for City, State Zip be blank. All this does is move the ugly blank to
the bottom of the row, so it is not quite so
ugly, but still not acceptible.
Is there a way to do this in ReportBuilder?
Thanks,
Jon
This discussion has been closed.
Comments
Check out the demo 33 located in the \RBuilder\Demos\1. Reports\...
directory (dm0033.pas). This example shows exactly how to accomplish what
you want.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Jon