Do the filters have an EXCLUDE/INCLUDE option? That is, if the records in dataset meet the filter criteria, then they are excluded? I have a set of filters arranged in priority sequence which is used to exclude records from the dataset. For example, filter #1: if company_code = 2 and employee_age < 30 (exclude) filter #2: if company_code = 3 and department_code = 4000 and employee_age < 50 (exclude) etc... I have about 50 of these filter conditions which when satisfied excludes the records in the dataset. Is there a way to do accomplish this? TIA. Jag Gutz

Hi Jag, Why don't you perform those excluded through you t-sql scripts instead of doing through SSRS report side. With this you will have good performance and also it is easily readable by some third person in near furture. Please let us know your feedback. Thanks KumarKG, MCTS

Hi Jag, Why don't you perform those excluded through you t-sql scripts instead of doing through SSRS report side. With this you will have good performance and also it is easily readable by some third person in near furture. Please let us know your feedback. Thanks KumarKG, MCTS

Hi Jag, Why don't you perform those excluded through you t-sql scripts instead of doing through SSRS report side. With this you will have good performance and also it is easily readable by some third person in near furture. Please let us know your feedback. Thanks KumarKG, MCTS

Thanks for the reply Kumar. The filters have a priority level sequence; i.e. filter #1, then filter #2...etc. Filter #5 may be true but filter number #2 may be false and would prevent filter #5 from being evaluated. I'm not really sure how you can structure the t-sql query to accomplish this. Besides, with over 50 filter conditions, the script would be too confusing to understand to be usable for maintenance. Whereas using the filtering function in SSRS it's straightforward. I just need an EXCLUDE/INCLUDE option in the filter. Jag Gutz

Thanks for the reply Kumar. The filters have a priority level sequence; i.e. filter #1, then filter #2...etc. Filter #5 may be true but filter number #2 may be false and would prevent filter #5 from being evaluated. I'm not really sure how you can structure the t-sql query to accomplish this. Besides, with over 50 filter conditions, the script would be too confusing to understand to be usable for maintenance. Whereas using the filtering function in SSRS it's straightforward. I just need an EXCLUDE/INCLUDE option in the filter. Jag Gutz

Hi Jag, Generally, if we add a filter to dataset, records meet the filter criteria can be retrieved. In other word, they are included. However, we can also exclude these records by modifying the filter settings. For example, we can change the filter settings of filter #1 to: Expression: =(Fields!company_code.Value = 2 AND Fields!employee_age.Value < 30) Type: Boolean Operator: = Value: =False After that, records meet the criteria of filter#1 will not be excluded. We can also modify the other filters in this way. Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Jag, Generally, if we add a filter to dataset, records meet the filter criteria can be retrieved. In other word, they are included. However, we can also exclude these records by modifying the filter settings. For example, we can change the filter settings of filter #1 to: Expression: =(Fields!company_code.Value = 2 AND Fields!employee_age.Value < 30) Type: Boolean Operator: = Value: =False After that, records meet the criteria of filter#1 will not be excluded. We can also modify the other filters in this way. Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.