首页 > 解决方案 > 如何消除 SSRS 表达式中的#error

问题描述

=CStr(First(Fields!AXPPaymentTerm.Value, "SalesInvoiceHeaderFooterDS")) & vbcrlf & 
iif(First(Fields!AXPSpotRateCurrency.Value, "SalesInvoiceHeaderFooterDS") = 1,"",
"Rate of exchange : " &
First(Fields!AXPSpotRateCurrency.Value, "SalesInvoiceHeaderFooterDS") & " " &
First(Fields!AXPSpotRate.Value, "SalesInvoiceHeaderFooterDS")
)

标签: reporting-services

解决方案


=CStr(First(Fields!AXPPaymentTerm.Value, "SalesInvoiceHeaderFooterDS")) & vbcrlf & iif(CStr(First(Fields!AXPSpotRate.Value, "SalesInvoiceHeaderFooterDS")) = "1","", "汇率:" & First(Fields!AXPSpotRateCurrency.Value, "SalesInvoiceHeaderFooterDS") & " " & First(Fields!AXPSpotRate.Value, "SalesInvoiceHeaderFooterDS") )


推荐阅读