Recently I ran into a problem for a website that I develop that connects to MSSQL and retrieves (lots) of data and got somewhat slow on loading. I wanted to give the user a ‘wait for loading’ message while the data was retrieved.
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