I have a report with a subreport, but the results are not what I was wanting/expecting.
One record from the detail section is output, followed by a record from the subreport. Then another record from the detail section, followed by the same record from the subreport.
When it has done this for each record with the same group id, it goes on to the next group and does the same.
What I want is: in the detail section, list all records with the same group id, then all linked records in the subreport, then go to the next group id and repeat.
How it is
A(1) (detail)
1 (subform)
A(2) (detail)
2 (subform)
A(3) (detail)
3 (subform)
B(1) detail
1 subform
B (2) detail
2 subform etc
What I want is
A(1) detail
A (2) detail
A (3) detail
1 subform
2 subform
3 subform
B(1) detail
B (2) detail
B (3) detail
1 subform
2 subform
3 subform
Maybe I need 2 detail sections. If so, how do I create a 2nd detail section?