开发者

Error on iif for color expression

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 beca开发者_Python百科use no accessible '=' can be called with these arguments:

How can I resolve this error?


Think you're missing the '.value' on Fields!strSegmentName = "Riser" and or Fields!strSegmentName = "Winback"

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜