Data

SSRS Consulting

SQL Server Reporting Services still prints the invoices, the packs and the operational lists. Those reports do not all need to become dashboards.

Repair, keep, or move

Some SSRS reports are slow because the query is wrong. Some are duplicates. Some are paginated documents the business must keep. We separate those before recommending a move to Power BI paginated reports or Power BI Report Server. A report that is a formatted extract should stay a paginated report.

The reporting practice, including Power BI, is on Power BI and reporting solutions.

A useful SSRS review

  • Which reports are still run
  • Subscriptions and the data source they use
  • Queries that time out or lock the database
  • Duplicates that can be retired
  • Which reports, if any, should leave SSRS

Need help with reporting?

Tell us what SSRS still has to produce

Report server version, SQL Server version, and whether you want the reports fixed in place or considered for Power BI.