Pages

Men

rh

4/22/2012

How many types of parameters that SSRS support

SSRS Supports two types of Parameters. Those are  
  • Query Parameter 
  • Report Parameter.

Query Parameter: 
Query Parameter  also called as Dataset Parameter. It is a variable defined at a dataset level that effects the way SSRS queries the data source.Query Parameters are frequently used to filter the data through WHERE Condition in the SELECT query. For example if you want to filter the information by day and you are using a SQL Server client, you could add the following condition to your query.WHERE Orderdate = @Today .This  condition causes the query to retrieve only rows that have a day equal to the @Today parameter.

Report Parameter: 
Report Parameter is a variable defined at the report level that allows to personalization of a report at run time. Report parameter are ofter mapped to Query parameter. For example user can select a Department and use the report parameter to assign the Query Parameter value and filter the expenses by Department wise.

No comments :

Post a Comment