时间戳

首页 > 解决方案 > 在 iif 子句条件中连接多个字段时，在 SSRS 报告生成器 2016 中显示错误

ssrs-2016 - 在 iif 子句条件中连接多个字段时，在 SSRS 报告生成器 2016 中显示错误

问题描述

当我在 if true 线索中连接多个字段时，它显示错误。我的表达式代码如下：

=IIf(Fields!testnm.Value="High Temperature Test","Temperature Tolerance :"&Fields!val1.Value&" "&"Duration :"&Fields!val2.Value&" "&"Remarks :"&Fields!val3.Value,
IIf(Fields!testnm.Value="Burn In Test","Temperature Tolerance :"&Fields!val1.Value&" "&"Duration :"&Fields!val2.Value&" "&"Remarks :"&Fields!val3.Value,
IIf(Fields!testnm.Value="Low Temperature Test","Temperature Tolerance :"&Fields!val1.Value&" "&"Duration :"&Fields!val2.Value&" "&"Remarks :"&Fields!val3.Value,
IIf(Fields!testnm.Value="Dump Heat Test","Temperature Tolerance :"&Fields!val1.Value&" "&"RH Tolerance ""&Fields!val2.Value&" "&"Duration :"&Fields!val3.Value&" "&"Remarks :"&Fields!val4.Value,
IIf(Fields!testnm.Value="Rendom Vibration Test","Frequency Range :"&Fields!val1.Value&" "&"BreakUp  Details :"&Fields!val2.Value&" "&"duration :"&Fields!val3.Value&" "&"Vibration Axis :"&Fields!val4.Value&" "&"Remarks :"&Fields!val5.Value&,
IIf(Fields!testnm.Value="Shock Test","Amplitude :"&Fields!val1.Value&" "&"Pulse Duration :"&Fields!val2.Value&" "&"Shocks :"&Fields!val3.Value&" "&"Wave :"&Fields!val4.Value&" "&"Shock Axis :"&Fields!val5.Value&" "&"Remarks :"&Fields!val6.Value,
IIf(Fields!testnm.Value="Sine Vibration Test","Frequency Range :"&Fields!val1.Value&" "&"BreakUp Details :"&Fields!val2.Value&" "&"Duration :"&Fields!val3.Value&" "&"Endurance :"&Fields!val4.Value&" "&"Sweeps :"&Fields!val5.Value&" "&"Endurance Duration :"&Fields!val6.Value&" "&"Vibration Axis :"&Fields!val7.Value&" "&"Remarks :"&Fields!val8.Value,
IIf(Fields!testnm.Value="Thermal Cycling Test","Temperature Tolerance To :"&Fields!val1.Value&" "&"From :"&Fields!val2.Value&" "&"Soak for PTemp :"&Fields!val3.Value&" "&"Soak for NTemp :"&Fields!val4.Value&" "&"Cooling Rate :"&Fields!val5.Value&" "&"Cycles :"&Fields!val6.Value&" "&"Remarks :"&Fields!val7.Value,
IIf(Fields!testnm.Value="Thermal Shock Test","Temperature Tolerance To :"&Fields!val1.Value&" "&"From :"&Fields!val2.Value&" "&"Changeover Time :"&Fields!val3.Value&" "&"Soak Duration :"&Fields!val4.Value&" "&"Cycles :"&Fields!val5.Value&" "&"Remarks :"&Fields!val6.Value,"BreakUp Details :"&Fields!val1.Value&" "&"RH Tolerance :"&Fields!val2.Value&" "&"Cycles :"&Fields!val3.Value&" "&"Remarks :"&Fields!val4.Value)))))))))

任何人都可以指导..感谢您的指导

标签： ssrs-2016

解决方案

在第 5 行的末尾你有一个额外的 & 或者我错过了它为什么在那里？

推荐阅读