Hi,
I'm having some problems getting the desired result from a report that I've designed using Crystal Reports v5.0. Here's the scenario:
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?

Thanks in advance.