17 September 2014

SSRS: Creating Parameter for Filtering

Using report that we've made here, now lets create parameters for filtering City (Kota) and Year (Tahun).
Variable with prefix @ will be recognized as parameter. Modify dataset query as image below:

When clicking Run button, parameter will be automatically detected.

For more detail setting of parameter goto menu Report -> Report Parameters...

Report Parameter dialog form will be displayed. There are 2 parameter detected automatically added, Year and City.

Prompt is a label that will be display as user interface, we'll set it to "Tahun". Default value set to be year of today by type function =Year(Today) as image below.

City parameter will be prompted as "Kota". On Available values will input a list of city manually by typing list on Non-queried option as image below.Lastly click OK button.

Click Previewtab to see the result.

For checking use some combination of parameters then click View Report button.

Click here if you like this article.

Related Article:
  1. Installing Business Intelligence SQL Server 2005
  2. Creating Report with SQL Server Reporting (Wizard)
  3. Creating Report with SQL Server Reporting (without wizard) | Part 1
  4. Creating Report with SQL Server Reporting (without wizard) | Part 2
  5. Design Layout Report
  6. Creating Parameter for Filtering
  7. Stored Procedure as Report Data Source
  8. Parameter Data List from Database Query
  9. Creating Report Group
  10. Create Sequence Number Using RowNumber Function
  11. Uploading Report FIle (.rdl) to Report Server
  12. Remove Report Page Break/Page Break 
  13. Query to Generate Subscription List 
  14. Direct Printing to Printer