Do not print field

[Imbriani]

I have Crystal Report XL running on Windows XP.

I have a field in a form that I want to not print if the field is empty. But, what I would really like is for the space it occupies not to be blank and there to be no gap between the line above this field and the line below. Is this possible??


Kathy

 

[lbass]

In the section expert check "suppress blank section" for the section containing this field.

-LB

 

[Imbriani]

Thanks, lbass, unfortunately, this field is part of the address to which the report is going to be sent. Could I use the "if isnull" function to do something with this?

kathy

 

[lbass]

I'm not following your response. Is the field embedded in a text box? Please explain what you mean by the "line above" and "line below". There are different methods for handling addresses. Please show some sample data and explain what we are seeing.

-LB

 

[Imbriani]

I have a report utilizing fields from a database to provide an address for mailing the report. The fields are arranged thus:

CompanyName
AttentionTo
Address

These fields are presently in the details a section and pull data straight from the database. Sometimes, there is no data in the AttentioTo field, so when the report prints, there is a blank space between CompanyName and Address. Using the section option you mentioned is not possible because there is data on the right hand side of the report, horizontally across from the address block, that would be eliminated. Can I use a formula to make the AttentionTo block "go away" or atleast move the Company Name field down?

Kathy

 

[lbass]

Well, we need to know what's on the right, and where probably, but I think you should place each element of the address in a separate detail section_a,_b,_c with each section formatted to "suppress blank section". The items to the right could be in detail_a only. Otherwise, you could place the items in a text box and format the text box to suppress embedded blank lines.

-LB

 

[Imbriani]

You're suggestion about the text box worked beautifully! Thanks so much.

Kathy