In Crystal Reports, can you group by two tables that are many-to-one with the top group?

Question

I am working on Crystal Report, which first breaks the data by receipt ID, and then I need two groups under the Receipt ID, but they are not related to each other.

So, instead of three levels of grouping, I need to somehow have only two levels, for example:

Group: Receipt_ID Group: Receipt_Detail.Line_Number Group: Receipt_Deduction.Description 

Here is an example of how it should look:

 Receipt ID Line Number Weight Dollar Amount 091911001 1 17,640 $2116.80 2 16,860 $1180.20 3 17,200 $1204.00 MAC Peeler Rate 17,640 0.0027 MAC Juicer Rate 34,060 0.0011 091911007 1 40,000 $10050.00 2 13,500 $2600.00 MACMA Rate 53,500 0.0350 And so on. 

Is there a way to do such things in Crystal Reports 10?

Answer 1

Subfield! That would be the cleanest way.

• In the footer of the receive ID, insert a subreport.
• In the subtitle, use the Receipt_Deduction table.
• In Subreport Links, select entries in the subheading based on Receipt_ID = Receipt_Deduction.Receipt_ID
• Move the contents of your deductions to the subrating details section.
• In the parent report, delete the Receipt_Deduction group and possibly the details table.
• If you want, you can even move your detailed content to the Details section to remove the Receipt_Detail group.