Category Archives: SSRS

Searching RDLs

As the company is moving, we needed to search for hard coded address data in all the reports. This smart individual came up with an easy way to extract all the RDLs from the reportserver database. I was especially impressed … Continue reading

Posted in SQL, SSRS | Leave a comment

SSRS Subscription Owners

We have to be sure subscription owners are not going to leave and make the subscriptions they own fail. Here is a way to make this information visible easily. For the reporting group I made a stored procedure which takes … Continue reading

Posted in SQL, SSRS | 2 Comments

Concatenating rows

We decided to use the data driven subscriptions for SSRS. This means storing all kinds of info in a database and then having to present it to the report server as subscription parameters. Specifically we have to concatenate a bunch … Continue reading

Posted in SQL, SSRS | Tagged | Leave a comment