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.