I am trying to group data using two sub reports. The query of the main report is event driven. For example, I want first to group by letters and, in that set, further group by numbers so as to have a report that looks like that:
a
1
1
2
b
1
2
2
I am using the designer.
When I set the query of the first sub report to group by letters and the query of the second sub report to group by numbers, it does not generate what I want. Could you help?