Hi All, I have the requirement in which i need to use 5reports(each consisting of approx 10 charts and 10tables) in a Single RDL as subreports. But when i run the consolidated report, it takes too long to run the report and at the end i get the error that Object has been disconnected or does not exist at the server. However when i run them individually all reports are running fine. Is there any way to optimize the consolidated RDL so that the report doesn't get timed out??

Hi There It is very rare. Do you really need the have sub reports ? Would that requirement not be accomplished by using groups etc. Please try to increase the timeout of your data Source by going to data Source properties and advance and see if it helps If you have any questions please let me know Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi Mayank.Jain, When we run the main report, each subreport instance is a separate query execution and a separate report processing task. Hence, performance can be impacted. In general, we can avoid subreport by using nesting data regions or rewriting the query to modify the main report structure. In this issue, taking your special subreport structures into account, the two approaches may be inapplicable. Thus, I suggest that you use the drillthrough report instead. We usually create a drillthrough report when want a user to open the report by clicking a link within the original report. Drillthrough reports commonly contain details about an item that is contained in the original summary report. For more information, please see: Drillthrough, Drilldown, Subreports, and Nested Data RegionsHow to: Add a Drillthrough Report Link If you have any questions, please feel free to let me know. Regards, Mike Yin

How can it be accomplished using Groups? Can you please explain a bit?