Suppress Group info with a twist

[LcdCyn]

I am using three tables.

Table A is linked to Table B
Table A is also linked to Table C.

The query I must has an outer join of all. So the output may look like this:

Table A element Table B element Table C element
----------------------------------------------------
a1 B1_1 c1_1
a1 B1_2 c1_1
a1 B1_3 c1_1
a1 B1_1 c1_2
a1 B1_2 c1_2
a1 B1_3 c1_2
a2 B2_1 c2_1
a2 B2_1 c2_2


If I need to show the following format in my report based on the output above, what should I do in Crystal Reports to suppress duplicate records and fields:

a1
-B1_1
-B1_2
-B1_3

-C1_1
-C1_2
--
a2
-B2_1

-C2_1
-C2_2

Note that I will not be able to change the input query for the Crystal report. And I am using Crystal Reports 10 Professional Edition.

HELP!
:-(

 

[lbass]

Put Table C in a subreport that is placed in the group footer for {tableA.element}, and which is linked to the main table on that field. In the main report, use only the first two tables, with a left out to TableB.

-LB