>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.