SQL Server Reporting Services
SSRS: Could not load type ‘Microsoft.ReportingServices.UI.GlobalApp’
I suspect some MS patch caused this as no one has touched this server in months yet today, we got the following: Server Error in ‘/Reports’ Application. Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify [...]
Service Unavailable on SQL Services Reporting Services after Microsoft Patch
Last night, my SSRS server failed on the first access attempt after Multiple Windows patches were installed by WSUS overnight (SQL Server 2005 EE, Windows 2003 SP2). This is not a critical server for me so it doesn't get tested before patches are applied. As such, it gets all patches immediately without testing and, in fact, is [...]
SSRS Formatting subtotals in a matrix
If you need to make your subtotals look different than your data, it's not very apparent how to do so. I've found 2 ways. You can conditional format the data cell and the results will affect the subtotals. The trick is to use INSCOPE. What you are going to do is check and see if [...]
Custom colors (or defined colors) in charts in SSRS
I needed specific colors for specific values on a pie chart in SSRS. We were charting work requests in a month. Each job had one of four states: completed, missed, pending and due today. I wanted to color code those values to dark green, red, lime and orange respectivly. The existing color palette (and options) was [...]