Dynamically generate the SSRS parameters on ASP.NET page using C#

Question

4.00/5 (1 vote)

See more:

Hi
I need help to generate the parameter(asp.net controls) as per the ssrs report selection.
There are 40 deployed SSRS reports and every individual report have different set of parameters.
I have to do this on one page where in when user clicks on the report link he is directed to the other page in which 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 asp.net controls for 1 individual report.
I want them to be dynamically populate on the page as per the report and we can also use them to generate report.

Posted 10-May-16 0:16am

Member 12514148

Updated 16-May-16 7:15am

v4

Add a Solution

Comments

ZurdoDev 10-May-16 7:26am

Putting 40 reports on a single page is going to destroy your page performance. It will likely be unusable.

Member 12514148 10-May-16 7:47am

i meant that only 1 report and its parameter would be shown to user at a time.
The user will be redirected to this page when he will select 1 of the report from the list.I have corrected the question now.Sorry for misunderstanding

ZurdoDev 10-May-16 7:52am

Then what exactly is your question?

Member 12514148 10-May-16 8:01am

i want to know how to generate the parameters(asp.net controls) dynamically for each ssrs report when selected and fetch the related deployed ssrs report in the report viewer.To clarify i am using asp.net controls as filters and report viewer to call ssrs report.

ZurdoDev 10-May-16 8:08am

I have actually done this and it is not easy at all. But the basic steps are to call the WebService to get a list of the parameters for the report. Loop through them. I look at the prompt on the report parameter and depending on what it is I may add a textbox or a dropdown list or a checkbox, etc.

Member 12514148 10-May-16 11:39am

can i use a sql table to store the parameters and the values and then fetch through them,will it be feasible.As you have done so can you suggest if it would be a good approach.

ZurdoDev 10-May-16 11:40am

You can but you'll still have to query them through the report services webservice in case any have changed in the rdl.

Member 12514148 10-May-16 11:45am

Thanks a lot for your help. :)

ZurdoDev 10-May-16 11:46am

Sure.

Richard Deeming 10-May-16 13:13pm

That sounds like an answer, and an article. :)

ZurdoDev 10-May-16 13:13pm

Good point. Maybe I'll have time for an article some day.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2016-05-10T07:14:00

Solution 2

As mentioned in comments, the basic steps are to call the WebService to get a list of the parameters for the report. Loop through them. I look at the prompt on the report parameter and depending on what it is I may add a textbox or a dropdown list or a checkbox, etc. It is a very manual process but can certainly be done.

Posted 10-May-16 7:14am

ZurdoDev

Comments

Member 12514148 16-May-16 13:21pm

I have updated the question,please help me in this as its getting tougher.
If you can provide a sample would be great.

ZurdoDev 16-May-16 13:30pm

I don't see any update nor any question.

Member 12514148 16-May-16 13:33pm

it was the minor change,so still the question is same

Member 12514148 17-May-16 1:48am

Hi Can you please send me a sample of the solution you gave.

ZurdoDev 17-May-16 7:05am

No. Sorry. Just go through the process I laid out and you'll get it.