Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove Line If Blank
Message
From
24/05/2001 05:42:09
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00510720
Message ID:
00510755
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!




I also want it but disallowed.


A FOOL way to do which I suppose work:

MOVE ALL field into detail brand, add print condition as below:
Print when RECNO() = RECCOUNT()
[remove line if blank],

So, in general case, Although put in detail brand, but all lines will be deleted as NOT printed!
but the last record will print the summary as you want.

Condition: Use Local/remote view to print with setting correct SET DELETE.
This is ensure the last record will be True on expression: RECNO()=RECCOUNT()


Well, I haven't test it but you may try it as learn.
but need to check the Sum up value correct or not!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Previous
Reply
Map
View

Click here to load this message in the networking platform