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.
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.
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 found