in pie chart i've to show number of open QNs 1. if DaysOpen <= 30 then color of pie shud be Green 2. if DaysOpen > 30 and DaysOpen <= 90 then color of pie shud be Yellow 3. if DaysOpen > 90 then color of pie shud be Red. for example pie chart should look like 40 Green 30 Yellow 30 Red. and 3 legends in the bottom 1. Green Open 30 days or less 2. Yellow Open 31 to 89 days 3. Red Open 90 days or more I'm trying this expression but does not work. =iif((Fields!qn_status.Value, "SProc")= "Open", count(Fields!qn_number.Value, "SProc"),"0.00") Thanks.

I'm trying this expression but does not work. Can you provide details? Thanks.Kalman Toth, Business Intelligence Developer; SQL 2008 GRAND SLAM

Argument not specified for parameter 'FalsePart' of Public Function IIf(Exprssion As Boolean, TruePart As Object, FalsePart As Object) As Object

Hi SSRSRpt, Try to modify your expression to this: =iif((Fields!qn_status.Value, "SProc")= "Open", CStr(count(Fields!qn_number.Value, "SProc")),"0.00") If you still have any issue, please give detail information(relevant to this expression). Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi SSRSRpt, Try to modify your expression to this: =iif((Fields!qn_status.Value, "SProc")= "Open", CStr(count(Fields!qn_number.Value, "SProc")),"0.00") If you still have any issue, please give detail information(relevant to this expression). Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.