SSRS pass multi-valued parameter problems

SSRS report parameters are either single-valued or multi-valued. Before a small partner asked me, if you want to pass multi-value how to pass. And then I tried. Between the various parameters, put a line descriptors comma semicolon, etc. did not solve the problem, and finally want to understand that this parameter should be non-character type, very large may be an array, and then I tried to split the string by splitting the group, decisive success.

Here also has the situation of the pit father, cannot direct the array to come over the report, so can only report inside to handle, how to do, then I thought a method is internal parameter P1. Set an external parameter P2 receive a comma-delimited string, and then set an internal parameter to receive the split-processed array.

In addition, at this time, the user sees the P2, receives the string, does not pull down the filter item to compare unfriendly. If the non-. NET custom development, that can add a parameter to make judgments and for users to filter, specifically not detailed.

SSRS pass multi-valued parameter problems