>Crystal reads from a foxpro table created by vfp5.0. The table has the following layout:
>
>Field1:----------Field2:----------Field3:
>A----------------1----------------3
>A----------------1----------------4
>A----------------1----------------5
>A----------------2----------------3
>A----------------2----------------4
>A----------------2----------------5
>
>I would like the report to have the following format:
>
>Field1 (grouping)
>----->Field2 (list of distinct values)
>----->Field3 (list of distinct values)
>
>I have attempted grouping by Field1 and then by field2, but the entire list of field3 is repeated for each field2 group.
>
>Is there a way to solve this problem?
Can you show what you're getting, and what you want to get, for the data you supplied above? If you can add some more test data, that would also be helpful....