>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

Hi Jerry,

IMHO it would be hard to achieve in a report. I would probably add this info into the select statement instead. Or you can have details and summary tables and base your report on these two.