EasyQuery ยท scenario

AD-HOC REPORTING

Let your users build their own reports inside your .NET app.

Ad-hoc reporting with EasyQuery

THE PROBLEM

"We need to change 3 reports and create 5 new."

Have you heard that from your customer? Then you know where the time goes: every new report is a ticket, a query, a page, a release โ€” and next month, another round of changes.

With EasyQuery, your users build, change and save the reports themselves: they pick the columns, add the conditions, group and total the data, see it as a table or a chart, and export it. You build the reporting module once.

The ad-hoc reporting demo

WHAT YOUR USERS GET

  • A list of saved reports, their own and shared ones
  • A visual editor for columns, conditions, sorting and grouping, in plain language
  • Totals, charts and export to Excel, PDF or CSV
  • Only the data you let them see

The demo asks you to sign in with a demo account; the sign-in page shows it.

HOW IT FITS YOUR STACK

EasyQuery builds the data model from your Entity Framework DbContext, keeps the reports in a store you choose (your own database table in the sample), and checks every action with your ASP.NET Core authentication: who may create, change or delete a report is up to you.

The UI is EasyQuery.JS in your Razor pages, MVC views, or a React, Angular, Vue or Blazor frontend.

builder.Services.AddEasyQuery()
    .UseSqlManager()
    .AddDefaultExporters();
...
app.MapEasyQuery(options => {
    options.Endpoint = "/api/adhoc-reporting";
    options.SaveNewQuery = true;
    options.UseDbContextWithoutIdentity<AppDbContext>();
    options.UseQueryStore(manager => new ReportStore(manager.Services));
    options.UseDefaultAuthProvider();
});

RUN THE SAMPLE

The same scenario as a project you can open in Visual Studio and run on your machine:

Step by step: ad-hoc reporting in your web app.

OR START FROM A READY APPLICATION

Don't want to build the reporting module at all? The EasyReport Starter Kit (ERSK) is a complete ASP.NET Core reporting application built on EasyQuery, in source code: report management, users and roles, guest access, data export, scheduled reports, multi-tenancy. Take the code, put your branding on it, connect your database and deploy.

EasyReport Starter Kit

TRY IT ON YOUR OWN DATA

Get the sample for your platform, connect it to your database, and see your own tables in the report builder.

HAVE MORE QUESTIONS?

Don't hesitate to contact us; we are eager to assist with any inquiries.