reporting-services - SSRS 的月份大于数字

Question

我有以下代码失败

=IIF(Parameters!yearFormat.Value="fiscalYear", 
"FISCAL YEAR: " & IIF(Month(NOW()) > 6, Year(NOW())+1, Year(NOW())), 
"NATURAL YEAR: " & Year(NOW()))

我得到的错误是#error，我也得到这个警告：

[rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox23.Paragraphs[0].TextRuns[0]’ contains an error: Input string was not in a correct format.

我在这里做错了什么？

标签： reporting-services

Answer 1

您正在将字符串与整数混合而没有强制转换。

尝试使用CStr()将整数转换为字符串：

=IIF(Parameters!yearFormat.Value="fiscalYear", 
"FISCAL YEAR: " & IIF(Month(NOW()) > 6, CStr(Year(NOW())+1), CStr(Year(NOW()))), 
"NATURAL YEAR: " & CStr(Year(NOW())))