Can subreports be loaded on-demand in sql server reports 2005?
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!
March 23rd, 2011 1:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics