Filters In SSRS

SSRS

 Filters In SSRS : 

Generally, Filters is used to filter the data over the data set or report

In SSRS there are 2 types of filters. They are : 

1. Data Set Filter

2. Report Filter

Data set Filter: Filters the data within the data. So, send a smaller amount of data over the network between the database server and the report server. It is the best approach performance-wise to reduce the dataset as much as possible.

Report Filter: It filters data once the dataset is loaded using a query. The report server uses cached data for the filtering at intail level it took data from the database server and then filters within the report and it is not a good approach when data volume is high