I am using Visual Studio 2010 Professional. I need to add a parameter to a local report. All the information I have found says to use the Report Parameters Dialog Box. Great!! It seems like I should select the rdlc file then the Report Menu option is displayed and I select the Dialog Box from the menu. But it is not there. Where is it? I have a code from a Microsoft example and can edit the XML if I need to but it looks like I should not need to. Help!!
There are two types of report parameters: A runtime parameter provides a value to be used in a query condition. There is a default set of runtime parameters for all queries, and any number of runtime parameters can be defined in the query that is used by the report.
With the query open in Design view, on the Design tab, in the Show/Hide group, click Parameters. In the Query Parameters dialog box, in the Parameter column, type the prompt for each parameter for which you want to specify the data type.
The SSRS Report Parameters allows the users to enter a specific value in the textBox and then, it will filter the Report data using the user-specified value. OR Report Parameters enables the users to Filter the SSRS Reports Dynamically.
I found it!!!!
You must have the rdlc open.
Press Ctrl+Atl+D to open the Report Data window (or select it from the view menu).
The parameters option is in the selection list.
Right-click it to add a new parameter. Fill in the fields and select your options.
Ta-Da
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With