Join: “Returns a string created by joining a number of substrings contained in an array.”
Have had a few regular requests when writing reports in BIDs where users want everything they have picked in a pick list to be displayed at the top of the report. Common request, yet many people do not know how to get around it.
Assuming you have already created a secondary dataset for a parameter; here is all you need to: Select ‘Allow Multiple Values’ on the parameter you have created (For the pick list) and press ‘OK’
On the design-pane create a new text box, right click and press expression and paste the following (Changing ParameterName to your parameter name.)
Once this has been done, apply the change and preview the report. Select multiple items in the pick list and they will appear.
A common occurrence is to apply this to a parameter where only ONE option will be used (Drop down menu, not pick list) which will throw a ‘#error’ when previewing/using the report.