Create short lists using the LookupSet function

Sometimes you have a short list of values that you really don’t want to show on individual rows; you’d rather just concatenate them into a list, separated by commas, and put them all in a single row. For example, suppose instead of listing the states in each U.S. Census region each on their own row,…

3

I want to reference a parameter (twice!) in a formula filter condition

In this release of Report Builder there is no direct support for referencing parameters in the Formula dialog. They will show up if you edit a prompted filter condition as a formula, but there is no way to directly insert a parameter reference.   However, with a little trickery and relying on some behavior that is…

4