Dotnet Report builder has an easy to use interface to create complicated filter groups that is simple for end users. Users can create multiple nested groups in filters. Then apply them each using AND or OR condition.
Users can add filter by clicking on “Add Filter” Button:
To add another set of conditions to be evaluated together, you can click on “Add Group”:
As expected, in the above example, the filter applied would be Ipoh Coffee this month or Chai last month.
A group of filter conditions can be nested within another group, so this is an advanced feature that can handle many complex scenarios.
how to separate report filters by database
Probably by creating a view, our support will reach out for more details. Thanks.