Useful tools for monitoring & managing ssrs

Reading this forum article on SSC led me to some interesting tools. Firstly this pack of SSRS reports that monitor the server and statistics is extremely useful and I will add it to the toolbelt. http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69257/   The other is a great little app to download/deploy reports on mass. Many a…

Multivalue parameters in SSRS

Normally when connecting to a SQL Server datasource you can create a paramter and allow multiple values and then use it in a query in this sort of construct: Select column from table where column in (@parameter) This works well and the parameter is passed from SSRS to the SQL Server…

SSRS dynamic hyperlink

Sometimes it's quite useful to use a hyperlink in a report to drill through or drill across to more detail or to a related report. I've also found it useful to dynamically generate links to various websites where the URI is predictable. Amazon.com uses a fairly predictable set of URLs…