Hi I am designing a small report which has a subreport contained within. I observed that using report services in 2005 version, subreport related data is loaded when the main report loads. The problem in my case is, this is a huge hit to the main report's performance. I am looking for an approach where I can have subreports loaded on demand. Right now I have the visibility of subreport controlled by toggling of one of the cells in main report. Main report also sends in some parameters which are used in subreport query. Hiding the subreport is just not enough. I do not want its data to load at the time of loading main report. I am using Visual Studio 2005 --> Business Intelligence Projects --> Report Server project for my reports which I assume doesn't have any C# code behind to manipulate. It stores report design(of the rdl file) in xml format. Kindly help!

Hi Deepti K, On-Demand Report Processing is supported in Reporting services 2008 or later version, to the scenario of yours, you could utilize cache process mechanism, with this mechanism, the Report Server can cache the intermediate format of the report, to shorten the time required to retrieve a report. This accelerated retrieval can mean an improved user experience, particularly in cases where the report is large or accessed frequently. Caching is a performance-enhancement technique that is effective in many cases. Besides cache process mechanism, you could also use snapshot or subscription, both of these methods are performance-enhancement techniques. For more information about Caching SSRS Reports for Performance, please see http://blogs.technet.com/b/rob/archive/2010/02/11/caching-ssrs-reports-for-performance.aspx Reporting Services Performance Optimizations http://sqlcat.com/technicalnotes/archive/2009/01/14/reporting-services-performance-optimizations.aspx Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Challen Fu Thank you very much for the suggestions. Deepti