Hi Tom,
Just a follow up on this issue.
I have resolved it but not as I expected.
Just to explain what I was doing.....
I have 3 BOs...
- Entity
- RegularUser
- LeaveAssignment
RegularUsers belong to an Entity
LeaveAssignments are owned by RegularUsers
I wanted a report that, for each Entity selected produce a report showing each RegularUser who belonged to that Entity and all of the LeaveAssignments for each RegularUser.
My original design and thinking was that I needed a Master Report for the Entity and then a SubReport for the RegularUsers and then inside that SubReport, another SubReport for that RegularUsers LeaveAssignments.
I guess therein lied the problem. Seems you cannot have a SubReport inside a SubReport.
I change the design to simply be a single Master Report with the Query finding all the LeaveAssignments, Grouped by the LeaveAssignment Owner and only LeaveAssignment Owners who belong to that Entity.
As is often the case, the problem is trying to make things to complicated.
Simple is best.
I would however be interested if you or someone else can confirm or otherwise if it is possible to have nested SubReports?