如何使通配符在 SQL Server 报告服务中的类似运算符中工作? [英] How do I make wildcards work in a like operator in SQL Server reporting services?

问题描述

我使用 like 运算符添加了过滤器表达式.我在值字段中输入什么?我的参数名为@test，我希望过滤器的功能类似于 SQL 中的 %@test%.我希望它表现得像 %@test% 这样我就可以通过 '' 来获取查询的所有值.

I have added a filter expression using the like operator. What do I put in the value field? my parameter is named @test and I'd like the filter to function as a like %@test% would in SQL. I want it to act like %@test% so I can pass '' to get all values for the query.

推荐答案

我通过添加带有 like 运算符的过滤器表达式并将值设置为:

I got this to work by adding a filter expression with a like operator and setting the value to this:

="*" + Parameters!Roles.Value + "*"

要获取我传递的所有值 ''.

To get all values I pass ''.

这篇关于如何使通配符在 SQL Server 报告服务中的类似运算符中工作?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！