Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Can subreports be loaded on-demand?

Author  Topic  DeeptiK Starting Member 1 Post Posted - 2011-03-29 : 02:17:16 Hi I am designing a small report which has a subreport contained within. I observed that using report services in SQL Server 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! Thanks, Deepti