There are a few ways to filter a dataset used in an SSRS report using a multi-value parameter. One approach is to pass the parameter value to the query used in the dataset to filter the dataset. This approach is explained in another post. If the SSRS dataset is not based upon a query, but […]

Why should you use the new CONCAT() function?   2 good reasons: When using the CONCAT() function, non string datatype arguments can be included and are implicitly converted to a string datatype.   Using the traditional “+” to concatenate fields, all of the fields concatenated needed to be of the same data type.   Using […]

When using SQL authentication in a PowerPivot connection, I repeatedly found the password was not saved even though I had removed the check mark from “Blank password” box and the “Allow saving password” box was checked. I tried manipulating the advanced properties setting the persist security to “True”.   All to no avail… the password […]