显示多值参数

2021-09-10 00:00:00 tsql sql-server ssrs-2008

我有一个多值参数，其中包含大约 25 个元素.如果用户选择全选"并且我使用标准(至少据我所知)在报告顶部显示参数的方法:

I have a multi-valued parameter which has about 25 elements in it. If the user selects "Select All" and I use the standard (at least as far as I know) method of displaying the parameter at the top of the report:

=join(Parameters!ProductClass.Value, ",")

而不是全部"这个词或我得到的东西:

Rather than the the word "All" or something I get:

01,02,03,04,05,06,07,08,09,10,11,12,14,15,16,17,18,19,20,21,22,25,30,31,98,99

没有更好的方法来处理这个问题吗?

There isn't a better way to handle this?

推荐答案

计算所选值的数量，并将其与填充参数的数据集中的记录总数进行比较.

Count the number of values selected and compare it to the total number of records in the data set that populates the parameter.

=IIF(Parameters!ProductClass.Count = Count(Fields!CaseSensitiveFieldName.Value, "CaseSensitiveDataSetName"), "All", Join(Parameters!ProductClass.Value, ","))

相关文章