troubleshooting Question
Added Subreport to detail section but report is too slow
I have a report that shows a master record and need to show several line details form 2 different tables. If I use joins and groups then the data repeats. I added a subreport to show the details from table 2 while table one is the detail of master (group table) . Report takes long time to populate the subreport linked with invoice id (Subreport is a SQL command) What can I do to make it faster?
sample
Master table invoce
Invoice 10001
details 1
details 2
details 3
details 4
Subreport Invoice 10001
service 1
service 2
service 3
sample
Master table invoce
Invoice 10001
details 1
details 2
details 3
details 4
Subreport Invoice 10001
service 1
service 2
service 3
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.