Parameter in the report is the value which filter the data in query from which we are fetching results.
For example while writing query or procedure we use variables in where clause which filters data and for which value can be changed whenever required. In SSRS these variable becomes parameter and filter data in Report.
lets say business user want to create a report where employee list should be based on designation. For this you will write a query and provide filter of designation in where clause and value of that designation will be available in report as a parameter for selecting designation.
For Report parameter the input could be a new data-set or same data-set which will have distinct values for designation.
Parameter can be passed to drill down reports and chart reports
KeyWord: SSRS Interview Questions,Parameterized Reports,SQL Server Interview Question, SSRS Interview Questions and Answers.
For example while writing query or procedure we use variables in where clause which filters data and for which value can be changed whenever required. In SSRS these variable becomes parameter and filter data in Report.
lets say business user want to create a report where employee list should be based on designation. For this you will write a query and provide filter of designation in where clause and value of that designation will be available in report as a parameter for selecting designation.
For Report parameter the input could be a new data-set or same data-set which will have distinct values for designation.
Parameter can be passed to drill down reports and chart reports
KeyWord: SSRS Interview Questions,Parameterized Reports,SQL Server Interview Question, SSRS Interview Questions and Answers.
No comments:
Post a Comment