Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove Line If Blank
Message
From
24/05/2001 17:07:51
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00510720
Message ID:
00511212
Views:
15
>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.
ramil
~~ learning to stand still
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform