I require help where in i want to generate the parameter(asp.net controls) as per the ssrs report selection. There are 40 deployed SSRS reports and have different parameter for every individual report. I have to do this on only one page where in first half contains the Parameters of the report in form of asp.net controls and the second half page contains the SSRS report viewer.
What I have tried:
I have tried to call a single deployed ssrs report on asp.net webpage. The parameters are hard coded as design controls for the individual report. I want them to be dynamically called as per the called report.
The method is good for you and you’d better have a look. The key point of your needs is how to get the parameters based on a report server. For this, you could have
a look at below thread which shows a demo for achieve this goal by using
Report Service SOAP API.
Then, you could use a dropdownlist to show all of the Report URL. When you change the DropDownList, you could dynamically load the related parameters to the first half
page with dynamical controls. Here, about dynamically creating server control to web page, you could refer to below article.
None
0 Points
1 Post
Multiple SSRS reports on single webpage with dynamic controls
May 11, 2016 05:24 AM|tech_ssrs|LINK
I require help where in i want to generate the parameter(asp.net controls) as per the ssrs report selection.
There are 40 deployed SSRS reports and have different parameter for every individual report.
I have to do this on only one page where in first half contains the Parameters of the report in form of asp.net controls and the second half page contains the SSRS report viewer.
What I have tried:
I have tried to call a single deployed ssrs report on asp.net webpage.
The parameters are hard coded as design controls for the individual report.
I want them to be dynamically called as per the called report.
Star
7980 Points
1586 Posts
Re: Multiple SSRS reports on single webpage with dynamic controls
May 11, 2016 08:05 AM|Weibo Zhang|LINK
Hi tech_ssrs,
I have found the following thread that may be posted on other forums by you and it has got an answer.
http://www.codeproject.com/Questions/1099089/Multiple-SSRS-reports-on-single-webpage-with-dynam
The method is good for you and you’d better have a look. The key point of your needs is how to get the parameters based on a report server. For this, you could have a look at below thread which shows a demo for achieve this goal by using Report Service SOAP API.
http://stackoverflow.com/questions/3296682/how-do-i-get-a-list-of-the-reports-available-on-a-reporting-services-instance
Then, you could use a dropdownlist to show all of the Report URL. When you change the DropDownList, you could dynamically load the related parameters to the first half page with dynamical controls. Here, about dynamically creating server control to web page, you could refer to below article.
https://msdn.microsoft.com/en-us/library/kyt0fzt1.aspx
Best Regards,
Weibo Zhang