Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove line if blank in Page Header
Message
From
16/04/2007 10:43:52
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01216167
Message ID:
01216220
Views:
22
Cathy,

Thanks, this worked perfectly.

FYI. I do have an image taking up the entire report page. I set the image to the top left corner of the page header and then set it's height and width properties to make it cover the entire report. Perhaps that made the Page Header believe the addr2 line was not completely blank?

Although my detail band does remove blank lines of data even though the image is taking up the entire background.

Thanks,

Jerry



>The problem you may be running into is that the entire line must be blank before it gets removed and other objects get moved up. So if you have other objects to the right or left, they could be preventing the line from removing.
>
>But don't fret .. there is an easy solution to your problem. Instead of creating 4 objects on the report and trying to use Print When and Remove When Blank, create one object and stretch it to be 4 lines tall. For the expression, enter this:
>
>
>CompName;Addr1;Addr2;City,State,Zip
>
>
>The ";" and the "," are special characters in the report writer. The ";" tells the report writer to combine the stuff before and after the ";" using a CRLF .. however .. if the second part is blank it doesn't bother adding the CRLF. The "," tells the report writer to trim the items before and after and then combine them with a space in between .. but it doesn't bother to add the space if the second part is blank.
Previous
Reply
Map
View

Click here to load this message in the networking platform