Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Print When Remove line if blank
Message
 
 
To
06/10/2016 18:48:36
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01641711
Message ID:
01641720
Views:
34
>>Hi,
>>
>>I have a Field in the report and the property Print When - Remove Line if Blank is checked. So that if the value of the variable in this field is empty, the field is not printed at all. But sometimes I want the field NOT to be Removed and yet nothing to be printed; that is a blank line to be printed. What kind of value can I set in this field so that Remove Line if Blank would not see it as blank but nothing would be printed? I am thinking of some CHR() value but can't come up with one that would work.
>>
>>TIA
>
>Have you tried simply clearing the "remove line if blank" checkmark? When checked you're specifying that vertical space occupied by field should be removed when it is blank. With the checkmark cleared the vertical space is retained.
>For character field then you generally won't have to do much -- if it's empty, then blank space is displayed.
>For numeric types you can select "blank if zero" in the format to not print the zero.
>For other types (e.g. date) then you can fill in the "Print only when expression is true" with something like "NOT EMPTY(expression)"

In my case the variable assigned to this field is character. I don't want to clear the 'remove line if blank' because then if the value in the variable is empty string, an empty line will be printed. But I do want the empty line to be removed completely; in most of the cases. But in some cases I want the blank line to be printed. What Antonia suggested, setting the value to char(160) works perfectly.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform