Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove Line If Blank
Message
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00510720
Message ID:
00511340
Views:
19
>>>Hi All!
>>>
>>>I have to put 5 fields in the summary band of a report but I also want, if possible that if those fields should be empty, the "line" would be removed. The report designer I think doesn't allow "remove line if blank" in summary bands..Is there a workaround for it? Thanks!
>>
>>A guy from Paranaque has this tip posted in the Foxpro Advisor Mag. I think this will solve your problem.
>>
>>1. Create a report variable: nKeyFieldCount
>>2. Calculate to COUNT
>>3. Reset at the key field in the group expression
>>
>>Set the Print When for every object in the Group Footer band as follows:
>>1. Check the "remove line if blank" option
>>2. Enter the expression nKeyFieldCount > 1 in the "print only when expression is true" box.
>
>Another simple approach which I got from UT (sorry, don't remember exactly from who) is to put the fields like:
>field1;field2;field3 etc. It will automatically remove fields if blank.
To clarify:
Create one expression and put there field1;field2;field3 with semicolon between fields. This should do it.

Before this tip I used UDF approach...
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform