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
When working with Microsoft SQL Server Report Services (SSRS) you sometimes you get the question if you can format a field based on it’s value. Better known as conditional formatting.Continue 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
Sometimes I receive questions from readers that make it to a new posting. The other day I received a question about a modification to an earlier post about SSRS and running totals. This reader wanted a running total in the footer of the page AND a running total in theContinue Reading
Introduction Recently I ran into the ‘problem’ of SSRS not being able to easily show running totals in the footer AND header of a invoice. (carry forward amount). After some digging and experimenting, I created a solution that worked for me.Continue 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 separatorContinue Reading
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.Continue Reading
Problem I sometimes would like to pass a ‘IN’ clause using a parameter, mostly when I’m using a data driven subscription (SSRS) on a report that has a multi-value parameter and can also be run interactive (via Internet Explorer) I spend hours looking for a ‘simple’ solution, only to foundContinue Reading