Last post Jan 19, 2018 12:06 PM by LLBSPX
Mar 25, 2014 12:12 PM|thanjaipvr|LINK
In an ERP Web Application, One form which would shows all the SSRS Report of the ERP Application. on User selection, I need to capture required input / Parameter of the selected report.
Generally we create one web form for each SSRS report and capture the input on that form. This is static because everything is done before running the application.
We also implmented another way to overcome this instead of capturing input at the webform, capture the same in the SSRS report. but user need to wait till report is getting generated. we don't want this approach. so we capture the same in the form and call
ssrs with parameter but for each report we need to design seperate web form to capture the input since each report require different input.
To generate the report I am using "ReportExecutionService" class.
Kindly suggest how to read the parameter details ( Name, Type, etc) required for that report and dynamically capture the input based on this on a single form.
With Warm Regards
Mar 26, 2014 02:39 AM|Michelle Ge - MSFT|LINK
According to your description, there are some parameters for the report, and those parameters are not all selected in the same time. As a user selected some parameters, we will get the report data with these parameters. According to your saying, you will
display those selected parameters in the report.
If my understanding is correct, I think you do not need to generate many web form. I think you can create one web form, in this web form it will contain all the parameters. But we can hide some parameters, you can select some parameters to show in the web
form. As you submit the request, we can go to check which parameters are selected, then we will get the report data with those selected parameters. If you must display those parameters in the report header, I think we should dynamically to add the parameters
to the report header. So the report will be dynamically generated.
If you want to read the parameter's details, I think the simple function is to create some hidden fields to store those informaiton.
Hope it's useful for you.
Mar 30, 2014 03:28 AM|thanjaipvr|LINK
Dear Michelle Ge,
Please understand my requirement as given below.
There are 100 rdl report and deployed in ssrs server which need to be used by the web application. In my web applcation I don't want to write 100 Aspx instead I want to have one form which shows list report stored in the SSRS. on selection of particular
report the same form need to capture required input for that report and report would be generated in the background thread.
Generating report in background thread is not an issue.
How do I dynamicall find the input parameter (filter riteria) required for a report from c# coding?
Thanks and Regards
Jan 19, 2018 12:06 PM|LLBSPX|LINK
did you ever find a generic solution for this problem. I was looking for the same information but haven't found anything