Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to suppress a line in the header area

Status
Not open for further replies.

ron9999

Programmer
Feb 14, 2003
89
AT
Hi All,
in the header area I print the address of a client like:

titel
name1
name2
zip country

if name2 is empty I like to suppress this line is that possible?
tia
Ronald
 
In Crystal 8.5, you could put name2 & zip country into a formula field:
if not isnull(name2) and name2 <> &quot; &quot;
then name2 & CHR(13) & zip country
else zip country

The CHR(13)forces a new line, or two lines for a formula field on the report. Make the field two lines thick, or else use the [Can Grow} option.

Madawc Williams
East Anglia, Great Britain
 
In these cases, I create 3 header sections, and put name 2 in the middle header section. Then I format that section to &quot;supress blank section&quot;.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
 
thank you All for your advice
now I have a problem to choose the right
I expected only 1 solution :)
the real address looks like

?panrede
?ptitel
?pname1
?pname2
?pname3
?pstrasse
?pplz ?port

so I have 7 lines, 3 of them have to be fill out

?pnameX
?pstrasse
?pplz ?port

now in this case I guess the best is to use the hint of Madawc in conuction with a
do case
end case
if possible
well I will check it out
thanks
Ronald


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top