1. Home
  2. Docs
  3. Designing and Running Rep...
  4. Configuring and Using Fil...
  5. Creating Simple Filters

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.

    How can we help?