We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
4 days, 21 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Added Subreport to detail section but report is too slow
Posted on 2011-09-07
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
7 Comments
The performance degradation is down to using the subreport in the deetails section of the main report, it's not clear how you are using the data from the sub, but try creating a group on Invoice ID and move teh subreport to the group header. If this doesn't suit your situation then it may be better to revert back to linking the tables and handling the record duplication with running totals.
HTH
HTH
Active today
Or if you need it after the main details put the subreport in the group footer.
When you put a subreport in the detail section it runs for every record in the report.
What are the tables and how did you join them?
mlmcc
When you put a subreport in the detail section it runs for every record in the report.
What are the tables and how did you join them?
mlmcc
The report is organized in 4 group levels. Is ther any way to suppress the detal level if G4 count > 1 then show it in the last record of G4?
I tried moving the sub report to the GF but it's still slow. I'm trying to get rid of the sub-report and use only Groups- joins. That's why i'm asking if there's any way to suppress the detal level if G4 count > 1 then show it in the last record of G4?
Active today
Yes.
Try using
Count({SomeField},{G4Group
SomeField is a field that will have values if there are records like the primary key
G4GroupField - The field G4 uses for grouping
mlmcc
Try using
Count({SomeField},{G4Group
SomeField is a field that will have values if there are records like the primary key
G4GroupField - The field G4 uses for grouping
mlmcc
No matter where I placed the sub report, the performance was affected so couldnlt use the sub report option. I added more table links to the same table (service) with alias to be able to show ll the results linked to line 1, line 2, line 3,... then created a formula to concatenate the results and show it.
Featured Post
June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Hi,
In my previous Article (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR).
Now it's tim…
Hello,
In my precious Article (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special.
It's completely agentless, but does let you create an agent, if you desire.
It offers powerful scalability …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Course of the Month4 days, 21 hours left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.