开发者

Error on iif for color expression

开发者 https://www.devze.com 2023-01-05 18:30 出处:网络
I have this statement in my SSRS report. =iif( ((Fields!lngCount2.Value-Fields!lngCount.Value)/Fields!lngCount.Value) > 0

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

精彩评论

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