Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Other Field Breakdowns in Data Grouping
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01451020
Message ID:
01451029
Views:
43
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform