I have been struggling to compare column values in a SSRS matrix (pivot table), but finally found a way around it. My solution is rather simple, but it works. Here is a simple example of the Matrix: Example M1 M2 M3 Cust 1 10 15 10 Cust 2 13 12Continue Reading

After updating our ssrs 2012 environment to visual studio 2015 I sometimes get an error when deploying a report. Error rsProcessingError : The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version ofContinue Reading

For a new project I needed to use a csv rendered SSRS report, but the default settings were not sufficient (comma delimited). I had to do some research, but managed to get what I want: Export without headers Semicolon as field delimiter Dot as decimal separator

Introduction I needed to create a SSRS report that only showed group headers (or footers) and still have alternate colors (every other row has another background color). Problem Normally I would use an expression like “= iif(RowNumber(Nothing) Mod 2 = 0, “Silver”, “White”)” for the ‘backgroundcolor’ property.