Friday, July 14, 2023

SSRS - How to use filter in Report Dataset

We can use the filter by using the filter property of the dataset. This is very useful when we need to pull data from Non relational data sources where we can not put filter while pulling the data for the report. We can filter the dataset by providing static value or we can use parameter. Below is the sample example where we are filtering data with parameter:

1) SQL dataset without any filter condition:
     


2) Report without filter:
     



3) Dataset with Parameter:
     



4) Report with filtered data:
     



No comments:

Post a Comment