Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Other Field Breakdowns in Data Grouping
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01451020
Message ID:
01451029
Vues:
44
>I have a report with fields F1-F4 in the Detail section. The Data Grouping is on F4. How can I show breakdown for the unique the values in F1 in the Data Grouping?
>For example:
>F1 F2 F3 F4
>A 5 3 Y
>G 7 2 Y
>G 4 3 Y
>R 0 1 Y
>Q 9 6 Y
>R 2 4 Y
>---------------------------------(Data Grouping when F4 changes)
>Totals:
>F1 F2 F3 #
>A 5 3 1 record
>G 11 5 2 records
>Q 9 6 1 record
>R 2 5 2 records
>
>
>F1 is dynamic; so, I don't know what values will appear.
>
>Jerry

Easy :-)
Add Two groups:
First based on F4
Second Based on F1
Detail band is EMPTY
Add variable to sum other fields and reset based on F1 field.
Then print all in F1 GROUP footer.
(I hope your Table/Cursor has the right order)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform