Introduction
Dotnet Report provides powerful filtering options for precise, user-friendly reporting. Filters allow you to narrow down data according to specific conditions, helping you focus on relevant insights.
By the end of this guide, you’ll be able to:
- Add and configure filters for a report
- Combine filters using AND or OR logic
Prerequisites
- You have access to Dotnet Report
- Your database is connected and data fields are available
- You have selected data fields in the “Selected data for Report” section
Step-by-Step: Creating Filters
Step 1: Select Data for the Report
Make sure your desired fields are listed in the “Selected data for Report” section. These fields will be used for filtering.
Step 2: Add a Filter
- Click on “Add Filters” in the Filters section.
- Select the field to filter:
- Numeric fields: Amount, Quantity
- Alphanumeric fields: Name, Status
- Date fields: Order Date, Created On
- Choose an appropriate operator:
- Numeric: Equal, Not Equal, Greater, Smaller, etc.
- Alphanumeric: Is Equal, Not Equal, Like, Not Like, etc.
- Date: Equal, In Between, Range, etc.
2. Enter or select the filter value.
(Optional) Check “Allow setting up and saving filters on Report” to make it reusable.
Step 3: Combine Multiple Filters
- Click “Add Another Filter” to add more conditions.
- Choose between AND or OR logic:
- AND: All conditions must be met.
- OR: At least one condition must be met.
Next Steps
Save and preview your report to ensure correct data is shown. Share the report if needed.