Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remove Line If Blank
Message
De
24/05/2001 05:42:09
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00510720
Message ID:
00510755
Vues:
16
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform