AND/OR filter groups, cascading dependent dropdowns, dynamic date ranges, and interactive controls that update the report in real time — no SQL, no code, no IT ticket. Your users explore their own data on their own terms.
Combine multiple conditions with AND or OR operators — and nest groups together for compound logic. Build rules like "(Department = Sales OR Department = Marketing) AND Status = Active" entirely through a visual interface. No SQL, no code changes, no help from IT.
When you enable report-level filtering, the "Choose Filters" panel appears directly in the report viewer. Users add conditions, pick values from dropdowns, set date ranges, and click Run — all without touching the designer. Filter selections can be saved to their profile for next time, eliminating the need for separate reports per user.
Choose a specific date from the calendar picker, or select a relative range that always resolves to the right period. "This Month" always means the current month. "Last 30 Days" always means the last 30 days from today. Reports stay current automatically without anyone updating them.
The date range comparison feature lets users add a second time period to the same filter — so they can see "This Month" vs "Last Month" or "This Year" vs "Last Year" side by side. No need for two separate reports or manual Excel wrangling.
For multi-tenant applications and role-based data access, forced filters are applied invisibly at query time. A user in Company A can never see Company B's data — the filter is injected by your backend and completely hidden from the report interface. Users don't even know it exists.
Cascading filters create parent-child relationships between dropdowns. Selecting a parent value automatically refreshes the child dropdown to show only valid options — preventing invalid selections and guiding users to meaningful data.
Free trial. Build a filtered report in minutes — no SQL needed.