具有“全部”的参数作为一种选择 [英] A parameter that has 'All" as an option
问题描述
我正在尝试为报告设置一个下拉参数。该参数允许用户选择如何过滤结果,即WHERE< field> = x,WHERE< field> = y等。一个选项应该是'全部'。选择'WHERE'不需要
。我尝试使用LIKE,其中'All'选项为'%',但似乎不起作用。如果我对此的思考过程已关闭并且有更好的方法请告诉我。但是,所需的项目是用户选择
选项和'All'作为选项之一的下拉菜单。
感谢您的帮助。
I am trying to have a drop-down parameter for a report. This parameter allows the user to chose how to filter the results, i.e. WHERE <field> = x, WHERE <field> = y, etc. One option should be an 'All" choice in which the 'WHERE' is not
needed. I have tried using a LIKE with an 'All' choice being a '%' but that does not seem to work. If my thought process on this is off and there is a better way please let me know. The items that are required though are the drop-down for the user to choose
an option and 'All' as one of the options to choose.
Thank you for any assistance.
推荐答案
您好RHPJasonM,
Hi RHPJasonM,
根据您的描述,有一些方法可以实现你的目标,例如设置过滤器到表而不是数据集,或者设置多个值的参数等。
According to your description, there exists some ways to achieve you goal such as set filter to table instead of dataset, or set multiple valued parameters etc.
我建议你按照下面的文章提示并使用它的"通配符"。方法,似乎很可能是你的初衷。请参阅 SQL
Server Reporting Services Multi -Value参数 - 通配符用法。
And I would suggest you to follow the tips this following article and use its "wildcard" method, it seems most likely your original intention. Please see SQL Server Reporting Services Multi-Value Parameter - Wildcard Usage.
最好的问候,
Lukas
这篇关于具有“全部”的参数作为一种选择的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!