Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do you keep several sub totals in the Report Designe
Message
De
24/05/1998 20:03:20
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00101455
Message ID:
00101559
Vues:
17
>You drop the same field being listed in the report column in the group footer. In the properties of the field dropped in the group footer, you tell it to calculate the sum of that field. You also set the total to reset (to zero) when whatever field changes (probably the customer number, for example). You have have multiple groups on the report, you just drop whatever field you want to total or sub-total in the appropriate group foot, even the report footer or summary band for grand totals.
>
>On the number of invlices, you would select the count option. As for how many over 30 days, etc., I would create report variables that provides a sum. The initial value would be zero and the value would be
> nCurInvoiceCount = iif(between(invoicedate, date()-30, date(), 1, 0))
> n30DayInvcCount = iif(invoicedate > date()-30, 1, 0)

Mark, Thanks for the detailed reply. That should work great, I appreciate the input.

Regards, Peter
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform