Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove Line If Blank
Message
 
 
To
24/05/2001 17:07:51
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00510720
Message ID:
00511337
Views:
12
>>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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform