颜色表达式的 iif 错误
我的 SSRS 报告中有这样的声明。
=iif(
((Fields!lngCount2.Value-Fields!lngCount.Value)/Fields!lngCount.Value) > 0
and Fields!strSegmentName.Value ="Struggler"
or Fields!strSegmentName = "Winback"
or Fields!strSegmentName.Value = "Former",
"Green" ,
iif(
((Fields!lngCount2.Value-Fields!lngCount.Value)/Fields!lngCount.Value) < 0
and Fields!strSegmentName.Value ="New"
or Fields!strSegmentName = "Riser"
or Fields!strSegmentName.Value = "High Value",
"Green",
"Red" )
)
我收到以下错误。
本地报告处理期间发生错误。的定义 报告“主报告”无效。的颜色表达式为 文本框“textbox8”包含错误:[BC30518] 重载分辨率 失败,因为无法使用这些参数调用可访问的“=”:
如何解决此错误?
I have this statement in my SSRS report.
=iif(
((Fields!lngCount2.Value-Fields!lngCount.Value)/Fields!lngCount.Value) > 0
and Fields!strSegmentName.Value ="Struggler"
or Fields!strSegmentName = "Winback"
or Fields!strSegmentName.Value = "Former",
"Green" ,
iif(
((Fields!lngCount2.Value-Fields!lngCount.Value)/Fields!lngCount.Value) < 0
and Fields!strSegmentName.Value ="New"
or Fields!strSegmentName = "Riser"
or Fields!strSegmentName.Value = "High Value",
"Green",
"Red" )
)
I'm getting the below error.
An error occurred during local report processing. The definition of
the report 'Main Report' is invalid. The Color expression for the
textbox ‘textbox8’ contains an error: [BC30518] Overload resolution
failed because no accessible '=' can be called with these arguments:
How can I resolve this error?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
认为您缺少
Fields!strSegmentName = "Riser"
和or Fields!strSegmentName = "Winback"
上的“.value”Think you're missing the '.value' on
Fields!strSegmentName = "Riser"
andor Fields!strSegmentName = "Winback"