Eric M Russell wrote:

Maybe SSRS would be a better choice, but that would require an enterprise license and training ...

We use SSRS a great deal. I was under the impression it's 'free' - i.e., bundled with SQL Server. Even SQL Server Express comes with SSRS, if I'm not mistaken.

(But not 100% sure. I'm not on the licencing/bean counting end of things here. I'm just the application development manager.)