blocks|key|201130|text|我对这个也遇到了一些麻烦。微软的own+documentation声明，在值框中应该可以使用简单的逗号分隔的值列表。这是令人困惑的，因为它没有。至少对我来说没有，我正在使用SSRS+2012和Visual+Studio+2010。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|201131|事实证明，当您使用IN运算符时，SSRS需要一个值数组。有许多方法可以使此功能适用于过滤器。以下示例将在表达式编辑器中键入。|201132|第一种方法(也是下面链接的博客中解释的方法)是简单地在字符串值中键入逗号分隔列表，然后对其使用拆分函数。|201133|=split("2B,2C",",")|code-block|syntax|javascript|201134|或者，您可以从多值参数派生列表。多值参数已经是一个数组，所以您所要做的就是通过参数表达式引用它，如下所示。|201135|=Parameters!MultiValueParam.Value|201136|我是通过下面的博客了解到这个信息的。http://sqlblogcasts.com/blogs/simons/archive/2007/11/20/RS-Howto--Use-the-IN-operator-in-a-filter-expression.aspx|201137|entityMap|0|LINK|mutability|MUTABLE|url|http://technet.microsoft.com/en-us/library/cc627464.aspx|1|http://sqlblogcasts.com/blogs/simons/archive/2007/11/20/RS-Howto--Use-the-IN-operator-in-a-filter-expression.aspx^0|G|H|0|0|0|0|0|0|0|I|35|1|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|D|3|E|5|6|7|16|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|17|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|18|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|19|8|@]|9|@]|C|$]]|$1|O|3|P|5|J|7|1A|8|@]|9|@]|C|$K|L]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@$A|1C|B|1D|1|1E]]|C|$]]|$1|S|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]|10|$5|V|W|X|C|$Y|11]]]]

I had some troubles with this one as well. Microsofts <a href="http://technet.microsoft.com/en-us/library/cc627464.aspx">own documentation</a> states a simple comma delimited list of values in the Value box should work. This is confusing because IT DOESN'T. At least it didn't for me and I am using SSRS 2012 with Visual Studio 2010.

It turns out that when you are using the IN operator, SSRS is expecting an array of values. There are a number of ways you can make this work for the filter. The following examples are meant to be typed out in the expression editor.

The first way (also the way explained in the blog linked below) is to simply type your comma delimited list in a string value and then use the split function on it.

<pre><code>=split("2B,2C",",")
</code></pre>

Or you can derive your list from a multi-value parameter. The multi-value parameter is already an array so all you have to do is reference it via the parameter expression as seen below.

<pre><code>=Parameters!MultiValueParam.Value
</code></pre>

I found out this information via the following blog. <a href="http://sqlblogcasts.com/blogs/simons/archive/2007/11/20/RS-Howto--Use-the-IN-operator-in-a-filter-expression.aspx">http://sqlblogcasts.com/blogs/simons/archive/2007/11/20/RS-Howto--Use-the-IN-operator-in-a-filter-expression.aspx</a>

blocks|key|4706905|text|这实际上是有效的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4706906|=CStr("Value1,Value2,Value3,Value4,etc").Split(",")|code-block|syntax|javascript|4706907|这在SSRS+2012中进行了测试。|4706908|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This actually works:

<pre><code>=CStr("Value1,Value2,Value3,Value4,etc").Split(",")
</code></pre>

This is tested in SSRS 2012.

blocks|key|201363|text|"value1"+"value2"|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|201364|只有一个空格，没有逗号，对我很有效。有趣的是，回过头来看测试之后，它看起来像|unstyled|201365|value1,+value2|201366|带逗号，不带引号。如果我剪切它，然后将它直接粘贴回相同的字段，它不起作用。这是一些错误的s**t。|201367|基础数据类型为nvarchar(10)，不为空|201368|使用VS+2017和SSRS+2016进行了测试|201369|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|F|7|W|8|@]|9|@]|A|$]]]|P|$]]

<pre><code>"value1" "value2"
</code></pre>

with one space and no comma worked for me. The funny thing is, when going back to look after testing, it appears as

<pre><code>value1, value2
</code></pre>

with a comma and no quotes. If I cut that, then paste it directly back to the same field, it doesn't work. This is some buggy s**t right here.

Underlying datatype is nvarchar(10), not null

Tested with VS 2017 and SSRS 2016

blocks|key|4706889|text|从表达式中删除前导=，即|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4706890|"criteria+one"+,+"criteria+two"|code-block|syntax|javascript|4706891|entityMap^0|9|1|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Remove the leading <code>=</code> from the expression, i.e.

<pre><code>"criteria one" , "criteria two"
</code></pre>

blocks|key|201240|text|如果推荐的解决方案对您无效，请尝试使用分隔符作为分隔符。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|201241|示例:条件一；条件二|201242|这对我很管用。|201243|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

If the recommended solution somehow doesn't work for you, try using a semicon as a seperator.

Example: criteria one; criteria two

It worked for me.

blocks|key|4706869|text|在SSRS+2012中，这对我很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4706870|“标准一”，“标准二”|4706871|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This worked for me in SSRS 2012.

"criteria one", "criteria two"

blocks|key|201300|text|对于整数值，您可以使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|201301|类型:文本|201302|运算符:+In|201303|Value：=New+Integer()+{8800,8820}|201304|应在2008+R2和更新版本上运行|201305|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

For integer values you can use:

Type: Text

Operator: In

Value: =New Integer() {8800,8820}

Should work on 2008 R2 and newer versions

blocks|key|4707163|text|天哪，这么多答案……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4707164|我知道这是可行的：|4707165|1)+MY+SP+returns+VARCHAR(n)+for+the+field+I+will+filter+in+the+tablix.+Returning+INT+DOES+NOT+WORK+in+my+solution.+I+don't+know+why+(yet).+++++++
2)+report.param.allow+multiple+values+=+true++
3)+tablix.filter.expression.datatype+=+text++
4)+tablix.filter.operator+=+IN++
5)+tablix.filter.value+=+=SPLIT(JOIN(Parameters!id.Value,","),",")+|code-block|syntax|javascript|4707166|使用这种方法，我可以调用SP一次，在参数中使用它来获取可用值，运行报告，tablix表读取上面步骤#5中选择的数据，并显示正确的行数。|4707167|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

OMG so many answers... 
I know this works: 

<pre><code>1) MY SP returns VARCHAR(n) for the field I will filter in the tablix. Returning INT DOES NOT WORK in my solution. I don't know why (yet). 
2) report.param.allow multiple values = true 
3) tablix.filter.expression.datatype = text 
4) tablix.filter.operator = IN 
5) tablix.filter.value = =SPLIT(JOIN(Parameters!id.Value,","),",") 
</code></pre>

Using this method, I was able to call the SP once, use it in a param to get available values, run the report, and the tablix table read the selected data from step #5 above and displayed the correct number of rows.

blocks|key|201261|text|将此查询输入到表达式中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|201262|=Join(Parameters!MultiValueParam.Value)|code-block|syntax|javascript|201263|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Enter this query into expression:

<pre><code>=Join(Parameters!MultiValueParam.Value)
</code></pre>

blocks|key|4707205|text|在Visual+Studio+2013+Premium中，In运算符使用多值参数工作得很好：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4707206|=Parameters!MultiValueParam.Value|code-block|syntax|javascript|4707207|但是，当我想在我的集合中使用常量值时，我无法让in操作符通过UI输入文本或表达式。|4707208|最终使用一组常量值的是进入Code视图并手动编辑我的筛选器。一组常量字符串"E“、"G”和"H“所需的XML如下：|4707209|<Filters>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++<Filter>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++<FilterExpression>=Fields!det.Value</FilterExpression>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++<Operator>In</Operator>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++<FilterValues>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++<FilterValue>E</FilterValue>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++++<FilterValue>G</FilterValue>
++++++<FilterValue>H</FilterValue>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++</FilterValues>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++</Filter>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
</Filters>|4707210|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

In Visual Studio 2013 Premium, the IN operator worked fine with a multivalued parameter:
<pre><code>=Parameters!MultiValueParam.Value
</code></pre>
However, when I wanted to use constant values in my set, I could not get the IN operator to work entering text or an expression via the UI.
What finally worked with a set of constant values was entering the Code view and editing my Filter manually. The XML needed for a set of constant strings &quot;E&quot;, &quot;G&quot;, and &quot;H&quot; is this:
<pre><code>&lt;Filters&gt; 
 &lt;Filter&gt; 
 &lt;FilterExpression&gt;=Fields!det.Value&lt;/FilterExpression&gt; 
 &lt;Operator&gt;In&lt;/Operator&gt; 
 &lt;FilterValues&gt; 
 &lt;FilterValue&gt;E&lt;/FilterValue&gt; 
 &lt;FilterValue&gt;G&lt;/FilterValue&gt;
 &lt;FilterValue&gt;H&lt;/FilterValue&gt; 
 &lt;/FilterValues&gt; 
 &lt;/Filter&gt; 
&lt;/Filters&gt;
</code></pre>

blocks|key|201332|text|enter+image+description+here|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|201333|每个数字之间的每个值都需要一个空格。它工作正常|201334|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/Rn5Uu.jpg^0|0|S|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

<a href="https://i.stack.imgur.com/Rn5Uu.jpg" rel="nofollow noreferrer">enter image description here</a>

Each every between numeric value need one space. its working fine

Can anyone advise what the syntax should be when using the IN operator within a table filter.
I have tried the below but the snytax is wrong:

<img src="https://i.stack.imgur.com/F26Dd.png" alt="enter image description here">

Using the IN operator to filter in reporting services

Visual Studio

有人能建议在表过滤器中使用IN运算符时应该使用什么语法吗？我试过下面的方法，但是snytax是错误的：​​

问使用IN运算符在reporting services中进行筛选
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用IN运算符在reporting services中进行筛选EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用IN运算符在reporting services中进行筛选
EN