SQL Reporting Services – markwheeler.com

BMC Remedy Assigned Group Incident Transfer(s) Query

January 22, 2015 mmwheeler

Had a request from a customer for a report showing the number of Remedy incidents transferred from his managed group to other groups during a given date range. I figured out a pseudo lead/lag query for SQL Server 2008. This creates an output that aligns the current row with the […]

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 […]

SQL queries for Sharepoint 2010 Site and User Permissions

November 14, 2013 mmwheeler

In some cases you may want to audit who has what permissions to various parts of your SharePoint site or farm. This query will give you a list of all of your groups, the roles / permissions of the groups, the users in those groups, and what they have permissions […]

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 […]

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 […]

Dynamically Resize Sharepoint 2010 Report Viewer Web Part

April 26, 2012 mmwheeler

Came across this blog which shows how to dynamically resize a Reporting Services Viewer Web Part to fit the height of the content/report using JQuery. Here’s the code for completeness. For my execution, I placed this on an HTML page and call it through a Content Editor Web Part. <script […]

SSRS Sharepoint Integrated Mode Missing Subscribe Button

October 5, 2011 mmwheeler

Ran into an issue when running SQL 2008 R2 Reporting Services in Sharepoint 2010 Integrated Mode. Only those with Full Control permissions could see the Subscribe option in the Actions Menu. However, users could Manage Subscriptions from the Item drop-down menu in the Report library. By default, the OOB Permissions […]