Hi all

I’m losing my mind trying to solve this crystal reports.net with vb2008 problem, and wondered if you can help – your book doesn’t seem to cover this.

I have 4 tables

Lots, materials, pack rules, and QC history. The lot has 1 material code and many lot details. The lot also has 0 or multiple pack rules, and 0 or multiple QC history entries.

I am trying to lay out the form so that each lot only appears once and shows the pack rules(all for the lot) and QC history(all for the lot), as below:

Lot Code              Material Code      Status                Initial Quantity                 Quantity Remaining         

Pack Rule ID       Pack Size

1                        15

2                        25

3                        20

QC Amendment Date                    Amended By

20/10/2009                                         John L                  

21/10/2009                                         John L

25/10/2009                                         John L

I can’t use an SQL command because I need to loop through all the header fields and sub report header fields and change them to the required language (French, Spanish, Italian, German)

I can produce the required result only if I display the lot details with either the pack rules or QC history, and then add a sub report for the missing data, but I want all the details together on the report.

Please help me!!