In my current position, I work with a new client almost every week. This exposure has shown me a couple of things about how clients are using reports. Generally speaking, they fall into one of two categories.
- They use the native reporting options from SolarWinds and have me make them less than 5 custom SQL reports.
- They want a ton of custom SQL reports (no complaints here, I love those gigs!) and lament some of the limitations on the current reporting options.
For the latter, it seems intuitive that they leverage SSRS since it's a free product for licensed SQL environments and it has an almost unlimited potential. However, the skills to configure and maintain SSRS are not always readily available.
For the uninitiated: SSRS
That being said, I wonder if my experiences are biased as those shops that have successful SSRS installations may not be the typical clients that I work with. How do you approach reporting in your company?