Features | Dotnet Report

Report Designer

Two designer modes — step-by-step Standard and real-time Live Designer. No SQL required.

Full page

Standard & Live Modes

Standard mode walks step-by-step. Live Designer previews the report in real time as users pick fields, filters, and chart types.

Drag-and-Drop Fields

Pick tables, drag fields, set sort order, choose groupings, and apply aggregates — all without touching SQL or code.

Calculated Fields & Formulas

Dozens of built-in functions for math, string, date, and conditional logic. Running totals, percentage-of-total, custom expressions.

Pivot Tables & Cross-Tabs

Multi-dimensional analysis with row/column pivoting, grouping, subtotals, and expandable row groups for summary or detail views.

Report Folders & Management

Nested folders with cascading permissions. Search across all reports. Drag-and-drop to reorganize. Admin governance and audit mode.

AI Assistant

Ask a question in plain English and get an instant fully built report. The AI Assistant interprets intent into the visual designer fields and chart type.

Live Dashboards

Combine reports and KPI widgets into a single view. Drag-and-drop layout, real-time data, role-specific dashboards.

Full page

Drag-and-drop widget layout — Freely resize and reorder charts, tables, KPI cards, and text widgets on a responsive grid

Real-time data — Dashboards query your database live on every load, no caching lag or manual refresh buttons

12+ chart types — Bar, line, pie, donut, area, combo, heatmap, treemap, KPI gauge, pivot, geo map, and more

Interactive global filters — Date pickers, dropdowns, and multi-select that update every widget simultaneously

Audience-specific dashboards — Create different views for executives, operations, sales, and support with role-based access

Scheduled PDF snapshots — Auto-export and email any dashboard on daily, weekly, or monthly schedules

12+ Visualizations

Every chart type your users need, fully customizable — no extra configuration or external charting library required.

Table / List

Bar & Column

Pie & Donut

Line & Area

Combo Chart

KPI Gauge

Pivot Table

Heatmap

Treemap

Geo / Map

Summary

AI Assistant

Advanced Filtering

AND/OR filter groups, cascading dropdowns, dynamic date ranges, and drill-downs that don't require changing the report definition.

AND/OR filter groups — Build complex logic like "(Status = Active OR Pending) AND Region = West" without writing SQL

Dynamic date ranges — "Last 30 Days", "This Month", "YTD", "Last Quarter" — always resolve to the correct dates at runtime

Cascading dropdowns — Child filter options automatically update based on the parent selection (e.g., Country → State → City)

Multi-select picklists — Users select one or many values from a list; the query adjusts automatically

Drill-down navigation — Click a chart bar or table row to navigate to a filtered detail report

Forced filters (security) — Inject hidden filters based on the logged-in user that cannot be overridden by end users

Exports & Scheduling

One-click PDF, Excel, CSV, and Word exports plus automated scheduled delivery to any email address on any cron schedule.

PDF export — Print-ready layouts with headers, footers, page numbers, and high-resolution chart images

Excel (.xlsx) export — Full workbook with column widths, cell formatting, and chart images embedded

CSV & XML export — Clean data files for downstream pipelines, ETL tools, and integrations

Word (.docx) export — Formatted document for report workflows and document management systems

Scheduled email delivery — Daily, weekly, monthly, yearly, or custom cron. Multiple schedules per report, any format

Centralized schedule management — Pause, edit, or delete schedules in one place. Admin view for organization-wide oversight

Enterprise Security

Role-based access, row-level data filters, multi-tenancy, and a zero-data-exposure architecture. Your data never leaves your servers.

Zero data exposure — Dotnet Report cloud stores only report definitions. Your .NET code runs all SQL. Data never leaves your environment

Role-based access control — Restrict reports, dashboards, and folders by role. Admins see everything; viewers see only what they're authorized for

Row-level security — Forced filters automatically injected based on logged-in user's tenantId, department, or region. Users can't override them

Multi-tenant isolation — Each client gets a fully isolated workspace with its own database connection, schema, reports, and permissions

Field-level restrictions — Expose only the tables and columns you want. Hide sensitive fields from specific roles without any code changes

On-premises option — Need full air-gapped control? An on-prem deployment option is available for maximum data sovereignty

Embedding & Integration

NuGet package, open-source frontend, full white-label. Integrates with your auth system and works with any .NET or JavaScript frontend.

NuGet package — Single package install. Configure two API endpoints. Full reporting engine runs inside your application

Open-source frontend — The UI components are fully open-source. Customize appearance, behavior, and layout as needed

Full white-label — Your branding, your colors, your logo. Users never see "Dotnet Report" unless you want them to

Your auth system — Integrates with ASP.NET Identity, JWT, SSO, or any custom auth. Pass user roles via claims or API parameters

Any frontend — Works with .NET MVC, Blazor, Angular, React, Vue, or any framework that can embed HTML or call an API

Cloud or on-prem — Use the hosted cloud service to store report definitions, or deploy the storage layer on your own infrastructure

Everything you need to add reporting to your .NET app

Report Designer

Standard & Live Modes

Drag-and-Drop Fields

Calculated Fields & Formulas

Pivot Tables & Cross-Tabs

Report Folders & Management

AI Assistant

Live Dashboards

12+ Visualizations

Advanced Filtering

Exports & Scheduling

Enterprise Security

Embedding & Integration

Ready to add all of this to your app?