Press "Enter" to skip to content

Creating a Generic SSRS Report

Tim Mitchell breaks out the black print on white cardboard:

When a simple presentation of data is needed, SQL Server Reporting Services (SSRS) is a common tool of choice. Creating simple tabular, row-and-column type reports can be done relatively quickly and easily in SSRS. But what happens if you need a lot of these reports? If you need to present dozens or even hundreds of reports to end users, building even a simple report for each one can take time. Unfortunately there’s no Biml-like automation tool for SSRS, so this work must typically be done by hand.

However, it is possible to create a generic report in SSRS that can dynamically present information from tables or views. In this post, I’ll share my implementation of this.

Looking at Tim’s solution, I’d be a bit concerned about longer-term maintenance. In particular, my worry would be that what you gain in ease of development, you give away in making troubleshooting and report maintenance harder.