asked on
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?
Thank you.
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?
Thank you.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.