Paginated Reports Parameter Display

[Anonymous]

I do not know if this is right place for this type of post.  In my pagniated reports I have it broken down parameters by fund, department, division.  In the report, I have whatever fund number is selected in parameter it will desplay name; ie fund 101 displays General.  How can I write the expression to where when I have multiple departments under Fund 101 slected in the parameters it will show the word "multiple" as opposed to the first one clicked

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

Any updates?

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Anonymous ,

Please kindly refer to this official tutorial:

To change a parameter from single to multivalued, you must change the query and all expressions that contain a reference to the parameter, including filters. A multivalued parameter is an array of values. In a dataset query, query syntax must test for inclusion of one value in a set of values. In a report expression, expression syntax must access an array of values instead of an individual value:

1. Switch to Design view.

2. In the Report Data pane, right-click @StoreID, and then click Parameter Properties.

3. Select Allow multiple values.

4. Click OK.

5. In the Report Data pane, expand the Datasets folder, right-click DataSet1, and then click Query.

6. Change the equals sign (=) to IN in the Transact-SQL WHERE clause in the last line in the query:

   Copy

   WHERE StoreID IN (@StoreID)  
   

   The IN operator tests a value for inclusion in a set of values.

7. Click OK.

8. Right-click a row or column header handle on the matrix, and then click Tablix Properties.

9. Click Filters.

10. In Operator, select In.

11. Click OK.

12. In the text box that displays the parameter in the page footer, delete all text.

13. Right-click the text box, and then click Expression. Type the following expression: =Join(Parameters!StoreID.Label, ", ")

    This expression concatenates all store names that the user selected, separated by a comma and a space.

14. Click OK.

15. Click in the text box in front of the expression that you just created, and then type the following:

    Parameter Values Selected:

16. Preview the report.

17. Click the drop-down list next to Store Name?

    Each valid value appears next to a check box.

18. Click Select All, and then click View Report.

    The report displays the quantity sold for all subcategories for all stores.

19. From the drop-down list, click Select All to clear the list, click "Contoso Catalog Store" and "Contoso Asia Online Store", and then click View Report.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.