SSRS – markwheeler.com

Adding StripLines with Report Builder

February 6, 2014 mmwheeler

I have a Forecast/Trending Chart that has past and future dates. I needed to denote Today with a vertical StripLine on the chart. (Click on images for larger version.) You can add a Marker with an expression easily. In your series properties; create an expression for your Marker. In my […]

Manage all SSRS Subscriptions in Sharepoint

October 4, 2013 mmwheeler

I needed a way for me and my teammates to see and edit all report subscriptions across a Sharepoint site with SQL Reporting Services in Integrated mode. There are two parts here; the first is a function that returns text between delimiters. This is important to get the site and […]

Bulk update of shared datasource for SSRS reports

April 24, 2013 mmwheeler

Accidently killed a shared datasource for 1000 reports. Found a handy query to update all those reports with a re-created datasource. Updated a couple of reports manually in Sharepoint. Ran the following against the ReportServer database. select c.Name as reportname, d.link, d.Name as datasource, d.dsid, d.itemid from Catalog c inner […]

SSRS – Query for NULLs and Order by NULLs last

April 2, 2013 mmwheeler

Had a request to create a report for Project Server milestones. There was a custom enterprise column added for tasks which contained a location code. My report had to return all values including where location was NULL. The first step was to get a valid NULL parameter in my Site […]

Rename SQL Server 2008 R2 Reporting Server Databases

June 13, 2012 mmwheeler

Had a task to move the default SQL Reporting Services ReportServer and ReportServerTempDB databases to a new SQL cluster which required a rename to avoid any potential conflicts. These instance of the databases are being used in Sharepoint-Integrated Mode. You could do Step 7 below before you do Steps 4 […]