Creating Simple Filters

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

1. Click on “Add Filters” in the Filters section.
2. Select the field to filter:
   • Numeric fields: Amount, Quantity
   • Alphanumeric fields: Name, Status
   • Date fields: Order Date, Created On

1. 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.