Single Valued Parameters

1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16

     In this example, i am going to explain how to create a filter in the SSRS report. This filter accepts only one value.

Example:

• Create New report with the name "ParameterizedReport".
• Create "Data Source" and "Dataset".
• In Design window insert a table and add required columns.

 

•  In "Report Data" section right click on "Parameters" and select "Add Parameter..."

• "Report Parameter Properties" window will open.

• Name: Give the required name for the parameter.
  Prompt: Give the required parameter name to display.
  Data type: Select the required data type.
  If you want to pass multiple values then select the "Allow multiple values" check box.
• Click on "OK" button.
• Right click on "Dataset" and select "Dataset Properties".

• "Dataset Properties" window will open.

• Add a where condition (Highlighted in the above screenshot)
• Go to Parameters section and select the required parameter.

• Click on "OK" button

• Click on "Preview", then it will prompt the parameter. Give the parameter value (10) and then click on "View Report" button then report will generate.