Skip to main content

Keene Systems, Inc.

Web-Based Reporting and Custom Report Development

Reports assembled by hand, days late? Get live reports in a browser.

Web-based reporting puts your reports in a browser, reading directly from the database, so they are current the moment anyone opens them. Nobody exports, pastes or formats. A report becomes a live view that anyone with permission can open, filter and send to Excel or PDF, and power users can be given a report builder to answer their own questions.

Why reports end up being built by hand

Almost every business has a person whose month ends with exporting from two or three systems, pasting into a workbook, fixing the columns and emailing the result. By the time it is read, it is out of date. If two people do it, their totals do not match.

This happens for understandable reasons. The system that holds the data has only a few fixed reports. The data is spread across several systems. Or the question keeps changing, and a spreadsheet is the only tool that can keep up.

The cure is not a better spreadsheet. It is to get the data into one database and let the reports read it directly. See you cannot see what is happening in your own business.

Businessman reviewing a data dashboard on a laptop

Signs reporting has become a job in itself

  • Someone spends days each month exporting, pasting and formatting.
  • Reports are out of date by the time they are read.
  • Every new question means a request to IT or to “the spreadsheet person”.
  • Two reports on the same subject give different totals.
  • Your current system works well and simply does not have the reports you need.
  • Managers cannot get an answer without asking someone to build it.

Three levels of reporting

Standard reports. The ones you run every day, week and month: sales, open orders, aging, production, whatever the business steers by. They are built once, are always current and can arrive by email on a schedule.

Self-service reports. Staff choose the fields, filters and grouping they want and save the result for next time. The questions that used to wait for IT, or for “the spreadsheet person,” get answered in minutes by the person who asked.

Dashboards. The handful of numbers an owner or manager checks first, on one screen, with charts where they help and the detail a click away.

Most companies need all three. The skill is in deciding which questions deserve a fixed report, which belong on a dashboard and which should be left to the people who ask them.

Self-service reporting at Dartmouth-Hitchcock

We built this kind of flexible reporting for the Bariatric Surgery Program at Dartmouth-Hitchcock Medical Center. Staff could pick the fields and the patient filtering criteria themselves and create complex reports for the doctors, with no programmer involved.

Read the Dartmouth-Hitchcock case study.

The reporting tools we work with

We would sooner use a proven tool than build one from nothing. A buy-before-build approach gives clients more for their budget. The tools we use most are:

  • Microsoft Power BI. Interactive dashboards for exploring the numbers, and Power BI Report Builder for precisely formatted, page-by-page reports. One tool covers both the analysis and the printed report.
  • SQL Server Reporting Services (SSRS). Microsoft’s reporting platform, included with SQL Server. A practical choice for a company already on the Microsoft stack that needs formatted, printable and scheduled reports. See what SQL Server is.
  • Telerik Reporting. A reporting tool built for current .NET. Reports are embedded inside the ASP.NET application, so users never leave the system they work in.
  • Dashboards and charts built into the application itself, for the numbers people check every day.
  • Replacements for Crystal Reports. Many established systems still depend on it, and it cannot follow them onto current technology. We rebuild those reports in the tools above. See Crystal Reports replacement.

The tool matters less than the data underneath. A well-designed SQL Server database makes any of them fast, and a poorly designed one makes all of them slow.

Adding reports to a system you already have

You do not have to replace a system to get better reports from it. If we can reach its data, we can build reports and dashboards on top of it. This is common with packaged software that does its job well and reports badly.

When the data is spread across several systems, it is brought together first, either through application integration or in a reporting database that is refreshed automatically. Then every report draws from one source, and two reports on the same subject finally give the same total.

Reports respect permissions, too. A salesperson sees their own accounts, a manager sees the region, and the owner sees everything.

Two businessmen discussing charts at an office meeting

How Keene Systems builds reporting

  1. We start with the decisions. Which decisions do these reports support, and who makes them? That tells us what to build.
  2. We find the data. Where each number lives, whether it can be trusted, and what has to be brought together.
  3. We build the standard reports first. The ones in daily and monthly use, checked against the figures you already trust.
  4. We add self-service and dashboards. So new questions do not need a new project.
  5. We keep them accurate. When the business changes, the reports are updated to match.

The next step is a short, no-pressure conversation. Schedule a project exploration call or use the form on this page.

Frequently asked questions

What is web-based reporting?

Web-based reporting delivers reports in a browser, drawn directly from the database, so they are current whenever they are opened and available to authorized users from anywhere.

Can reports be added to a system we already have?

Often, yes. If the data can be reached, reports and dashboards can be built on top of an existing system without replacing it.

Can our staff create their own reports without a programmer?

Yes. A self-service report builder lets authorized users choose fields, filters and grouping themselves and save reports for reuse.

Can reports be exported to Excel or PDF?

Yes. Reports can be viewed on screen, exported to Excel or PDF, and scheduled to arrive by email.

Do you work with Power BI?

Yes. We build Power BI dashboards and paginated reports with Power BI Report Builder, and we also work with SQL Server Reporting Services and Telerik Reporting.

Can you replace our Crystal Reports?

Yes. We rebuild Crystal Reports as reports inside your application or in a current reporting tool, and check each one against the original before you switch.

Tell us about your reporting

Why Keene Systems

Keene Systems has built custom business software since 1987. We are veteran-owned, and our 50+ professionals have delivered systems for companies including Hormel, McCormick, IBM and Dartmouth-Hitchcock. See our client list.

Schedule a project exploration call.

Schedule a Project Exploration Call

This free session is your fastest path to improved business productivity.