Session 8: Creating an SSRS Parameterized Report AnandFriday, December 19, 2014 0 comments

                                   Session 8: Creating an SSRS Parameterized Report

Lets proceed towards making a simple SSRS report with parameters.
This lesson, should give you an idea, as to how to control the data in the reports using parameters.
Lets consider the same report, that we made in Lesson 6.

We are going to expose the postal code as a parameter. This means, we will see the address of only the entered postal code.

 Step 1: Modify the query in the dataset, to make PostalCode as a parameter 

Step 2: Once you click OK, go to the parameters folder in  "Report Data" - you will find that @postalcode automatically appears in the "Parameters" Fields.

Step 3: Lets explore more about the parameter. Double click on @postalcode.

This is place, where you configure, how your parameter should behave - should it allow blank values or null values etc.

You can configure the visibility, data-types, default values etc.

Lets leave it as it is for now.

Step 4: Click preview, and enter in a postal code (91370 for example)

Note: Observe that the parameter appears as a text box here.

If you want pre-configured values (in a dropdown), double click on the parameter in "ReportData" --> Parameters (here, @postalcode) and click "Available Values"/"Default value" and click "Get values from a query". You can choose your dataset and corresponding column. Create multiple datasets to suffice your parameter value requirements.