Question

I m pulling from Table A which has 4 Transaction Statuses... 03 , 05 , 06 , & 07
I ve defined a dataset which pulls them...

SELECT  ALL  AS label, NULL AS value, 0 AS iordr
UNION ALL
SELECT  03  AS label,  03  AS value, 1 AS iordr
UNION ALL    
SELECT  05  AS label,  05  AS value, 2 AS iordr
UNION ALL
SELECT  06  AS label,  06  AS value, 3 AS iordr
UNION ALL
SELECT  07  AS label,  07  AS value, 4 AS iordr
ORDER BY iordr

But when I try to define the Parameter, when I select ALL from the drop down of the report, it doesn t pull 03 , 05 , 06 and 07 - in fact, it pulls NOTHING... how do I make it so that the ALL choice will pull ALL statuses in one report?
Report Parameter Properties:

General
Data Type: Text; Allow null Value
Select parameter visibility: Visible
Available Values:
Select from one of the following options:
Get values from a query
Dataset (the one defined above)
Value field: value
Label field: label
Default Values:
Select from one of the following options: No default value

Answer 1

从您的下级中挑选的价值将载于{NUL, 03 , 05 , 06 , 07 }。页: 1 WHERE 报告中的条款如下:

SELECT ...
FROM ...
WHERE SomeColumn = @UserSelectedValue
  OR @UserSelectedValue IS NULL
;

It won t work if your WHERE clause is just WHERE SomeColumn = @UserSelectedValue because = NULL is not valid (as ANSI-standard anyway), and it would only give you results for SomeColumn being NULL.

通过有效比较<代码>NULIS NUL,你重新设定了每个单行都具备的条件,从而给你/strong>数据。

Answer 2

在SSRS中,多价值参数被作为混合体分离。

使用SSRS多价值参数的最容易的方法是将全部电离层填入数据集,并使用<代码>。 WHERE myTable.Column IN (@MyPara amountName

Or you can move your filtering parameter into the dataset filter or maybe a filter on the tablix that you are using.

如果你真的需要将多价值参数输入一个储存的程序,那么,你将需要做一点细微的 par平,以将其分开。

友情链接