Hello,
I’m trying to convert a stat report from Crystal to SSRS. In crystal I use a formula to do the calculations.
This is the crystal expression.
if {TRAFFIC_DATE_SUMMARY.TYPE} in (["Sober Designated Drivers Contacted", "Total DRE Evaluations"]) then '*'
else if Sum ({TRAFFIC_DATE_SUMMARY.KOUNT}, {TRAFFIC_DATE_SUMMARY.TYPE}) = 0 then '*'
else totext(Sum({TRAFFIC_DATE_SUMMARY.KOUNT}, {TRAFFIC_DATE_SUMMARY.TYPE}),0,"")
This was my attempt in SSRS
=iif(Fields!Type.Value) in (["Sober Designated Drivers Contacted", "Total DRE Evaluations"]) then "*"
else iif Sum(Fields!Kount.Value), (Fields!Type.Value)) = 0 then "*"
else totext(Sum((Fields!Kount.Value), (Fields!Type.Value)),0,"")
I get the following error when running in SSRS. The value expression for the textrun "Kount.Paragraphs[0].TextRuns[0]' contains an error: [BC30516] Overload resolution failed because no accessible 'IIF' accepts this number of arguments.
Any help appreciated. I'm sorta new to SSRS and still learning my way.
I’m trying to convert a stat report from Crystal to SSRS. In crystal I use a formula to do the calculations.
This is the crystal expression.
if {TRAFFIC_DATE_SUMMARY.TYPE} in (["Sober Designated Drivers Contacted", "Total DRE Evaluations"]) then '*'
else if Sum ({TRAFFIC_DATE_SUMMARY.KOUNT}, {TRAFFIC_DATE_SUMMARY.TYPE}) = 0 then '*'
else totext(Sum({TRAFFIC_DATE_SUMMARY.KOUNT}, {TRAFFIC_DATE_SUMMARY.TYPE}),0,"")
This was my attempt in SSRS
=iif(Fields!Type.Value) in (["Sober Designated Drivers Contacted", "Total DRE Evaluations"]) then "*"
else iif Sum(Fields!Kount.Value), (Fields!Type.Value)) = 0 then "*"
else totext(Sum((Fields!Kount.Value), (Fields!Type.Value)),0,"")
I get the following error when running in SSRS. The value expression for the textrun "Kount.Paragraphs[0].TextRuns[0]' contains an error: [BC30516] Overload resolution failed because no accessible 'IIF' accepts this number of arguments.
Any help appreciated. I'm sorta new to SSRS and still learning my way.