I have a report based on employee details. The source is a table I have built specifically for this report - tblEmpCharges. The user can specify whether or not to 'show details' for each employee.
The main report is grouped by employee ID, and I show summary info at the employee header level. I want the report detail to have a subreport which shows the employee details. If the user specifies don't show details' I intend to set the source of the subreport control to nothing., so only employee summary line will show.
The subreport has exactly the same source as the main report, and I want to set up the parent/child to be EmployeeID. However, every time I try to insert the subreport into the main report (detail section) Access crashes completely.
I have checked the subreport by viewing it independantly - all good. Also, main report is fine if there is nop subreport.
So, my questions are:
Can you have a subreport with same source as parent report in the report detail section?
Is there a better way to show or not show employee detail depending on user request?