1. Background
The purpose of this article is to describe a way of
filtering report data at tablix level. We are going to use Tablix’s filter
property to add multiple filters to limit the report’s data.
Note- It is recommanded that filter at database level will give good performance as compare to filters at SSRS level.
filtering report data at tablix level. We are going to use Tablix’s filter
property to add multiple filters to limit the report’s data.
Note- It is recommanded that filter at database level will give good performance as compare to filters at SSRS level.
2. Step by Step procedure to filter the data using tablix property:
·
Below is the sample report
in which we will add filters to limit the data:
Below is the sample report
in which we will add filters to limit the data:
·
To add the filter at tablix
level, right click on the tablix and go to properties:
To add the filter at tablix
level, right click on the tablix and go to properties:
·
Go to filters and click on “Add” to add the filter. Here we are
going to add filter for FiscalYear as 2010.
Go to filters and click on “Add” to add the filter. Here we are
going to add filter for FiscalYear as 2010.
·
Now run the report
Now run the report
Here we can see that report is showing data only for fiscal
year2010.
year2010.
·
We can add multiple filters also. Now going
to add one more filter for Sales Region:
We can add multiple filters also. Now going
to add one more filter for Sales Region:
·
Now we can see the filter report for
FiscalYear – 2010 and Sales Region- India, USA, UK
Now we can see the filter report for
FiscalYear – 2010 and Sales Region- India, USA, UK
3.
Conclusion
By using the above steps, we can filter the report data at tablix level
or report level
—————————————————-End
of Article—————————————————
of Article—————————————————