Remove From My Forums

Multiple SSRS reports on single webpage with dynamic controls

Question
0

Sign in to vote

User1165384973 posted

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.

Wednesday, May 11, 2016 5:24 AM

Answers

0

Sign in to vote
User-219423983 posted

Hi tech_ssrs,<o:p></o:p>

I have found the following thread that may be posted on other forums by you and it has got an answer.<o:p></o:p>

http://www.codeproject.com/Questions/1099089/Multiple-SSRS-reports-on-single-webpage-with-dynam<o:p></o:p>

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.<o:p></o:p>

http://stackoverflow.com/questions/3296682/how-do-i-get-a-list-of-the-reports-available-on-a-reporting-services-instance<o:p></o:p>

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.<o:p></o:p>

https://msdn.microsoft.com/en-us/library/kyt0fzt1.aspx<o:p></o:p>

Best Regards, <o:p></o:p>

Weibo Zhang<o:p></o:p>
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Wednesday, May 11, 2016 8:05 AM