c# - Formatting a summed number within an iif in RDLC -
i cannot seem figure out how format number within textbox being summed within iif. here how code looks:
=iif( sum( iif(expression, number1+number2+number3, number4+number5+number6) ) )>=10000000,true, false)
in part says true format number being summed, being used in comparator well. assign sum variable , continue conditional check, not sure how proceed. there way assign variables within textbox expression, or coming @ wrong way?
try example, using textbox called yourtextbox:
//set value yourtextbox.value = sum(iif(expression, num1 + num2 + num3, num4 + num5 + num6)) //format value yourtextbox.format = iif(reportitems!yourtextbox.value >= 10000000, "c2", "f2") //format style yourtextbox.backgroundcolor = iif(reportitems!yourtextbox.value >= 10000000, "red", "lime")
Comments
Post a Comment