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:
- Installing Business Intelligence SQL Server 2005
- Creating Report with SQL Server Reporting (Wizard)
- Creating Report with SQL Server Reporting (without wizard) | Part 1
- Creating Report with SQL Server Reporting (without wizard) | Part 2
- Design Layout Report
- Creating Parameter for Filtering
- Stored Procedure as Report Data Source
- Parameter Data List from Database Query
- Creating Report Group
- Create Sequence Number Using RowNumber Function
- Uploading Report FIle (.rdl) to Report Server
- Remove Report Page Break/Page Break
- Query to Generate Subscription List
- Direct Printing to Printer
0 Comments