在参数属性的 Available Values 屏幕上您将看到 Value Label

在测试参数的数据集中,添加一列来保存 标签 要传递给查询的值的。这个可以和你的一样 价值 如果你愿意的话,但是给了你所需要的灵活性 Null 条目:

SELECT DISTINCT Corp_Test as Value
               ,Corp_Test as Label
  FROM [Tfs_Warehouse].[dbo].[CurrentWorkItemView]
 WHERE ProjectNodeGUID = @ProjectGuid
   AND System_WorkItemType = 'Marketing Feature'
UNION ALL           -- As you have DISTINCT above, UNION ALL will work faster and give the same results as UNION (which removes duplicates)
SELECT 'Null' as Value
      ,'No PSI' as Label
ORDER BY Corp_Test

完成此操作后,请更改参数以使用 价值 字段作为参数值和 标签

SELECT
ISNULL(Corp_Test,'No PSI') AS Corp_Test
FROM 
(SELECT DISTINCT Corp_Test
  FROM [Tfs_Warehouse].[dbo].[CurrentWorkItemView]
 WHERE ProjectNodeGUID = @ProjectGuid
   AND System_WorkItemType = 'Marketing Feature'
UNION
SELECT 'Null'
) AS Corp
ORDER BY ISNULL(Corp_Test,'No PSI') 

记住在where子句主查询中实现更改。我所说的主查询是指为您的报表提供信息的查询

where COALESCE(Corp_Test, 'Null') IN (@TestParam) 具有 where COALESCE(Corp_Test, 'No PSI') IN (@TestParam) ,并在数据集中替换 SELECT 'Null' 具有 SELECT 'No PSI' .