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
Our community of experts have been thoroughly vetted for their expertise and industry experience.