我有parameter@Coverage
和parameter @CoverageLosses
。他们不是父母和孩子。我想要@CoverageLosses
基于的值填充默认值@Coverage
。所以我的主要数据集@Coverage
看起来像这样:
SELECT DISTINCT Coverage
FROM PlazaInsuranceWPDataSet
ORDER BY Coverage
我的辅助数据集@CoverageLosses
如下所示:
SELECT DISTINCT Coverage AS CoverageLosses
FROM tblLossesPlazaCommercialAuto
WHERE Coverage IN (@Coverage)
ORDER BY CoverageLosses
在报告参数中,@CoverageLosses
我检查了,Allow Multiple values
然后在默认情况下->Specify values
我正在编写此表达式:
=IIF(Parameters!Coverage.Value="Liability","AutoLiabilityCLS" ,nothing)
对于单个值,它可以正常工作。但我想查看多个值,@CoverageLosses
如果我选择@Coverage = Liability
我如何为此写表达式?像这样的东西:
=IIF(Parameters!Coverage.Value="Liability","AutoLiabilityCLS" & "AutoLiabilityCLS" & "AutoBodilyInjuryLiability" ,nothing)
@CoverageLosses用于我的报告中的另一个表。它将被隐藏。但是@Coverage中的值将被映射为@CoverageLosses值。因此,当用户选择时,假设@Coverage中的value1,则@CoverageLosses中的默认值应为value1,value2,value3等。
您可以创建其他数据集并将其用作参数的来源:
select CoverageLosses from (
select 'Liability' Coverage ,'AutoLiabilityCLS' CoverageLosses union
select 'Liability' Coverage ,'AutoLiabilityCLS' CoverageLosses union
select 'Liability' Coverage ,'AutoBodilyInjuryLiability' CoverageLosses union
select null Coverage ,null CoverageLosses ) x
where Coverage = @Coverage
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句