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