I have one master report which shows more than 20 Subreports. I am dynamically hiding subreport based on selection of parameters. Now what I wnat to do is dynamically change the subreport.Basically I want to reorder subreport based on parameter. I don't see anything in SSRS which allow me to use dynamic subreport.

No. The subreport name cannot be based on an expression. Th eonly other option is to programmatically modify the subreport name in the deployed master report. This is more difficult to implement and to support. The technique you are using it probably the best approach.Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com

I reckon it's not possible in reporting services. In addition , it's more complicate to do in that way. I run into the same issue and when it comes to maintaince issue it is really hard to do.Dasari

Hi, You cannot use subreport in expressions, but there is a work around... Steps : 1) Place all your subreports under another in your main Report. 2) Use Document map, Give appropriate names for sub reports for displaying in document map as a link... give page breaks for all subreport. 3)These Document map links to your subreports which is in different pages. your output ll be like this. Document Map ReportsReport 1 Home report Subreport1 Subreport 2--> Subreport2 Details Subreport 3Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

My application is in Silverlight and the report generation page is .aspx where i have the report viewer which is set to .RDLC in my web application. I have 15 subreports and we show/hide based on parameter but everytime datasources are getting loaded for all the sub reports and causing my report processing to take more time. If have one subreport it takes 6 seconds, for 2 sub reports - 8 secs, 4-9 sec and 16 subreports take 16 seconds which is a very big performance issue. So what is the best way to tackle this issue. should we go for dynamically modifiying the master rdlc file holding all the sub reports or is there any way we can remove them from the subrepor in the page initialization so that only selected sub reports are processed. Any inputs on this are greatly appreciated. Thanks