how to eliminate #Error in ssrs report

  • i have an ssrs report

    where i have to get only current month amount

    so previous months should be zero and forward months should be zero

    iam getting previous months zer values but iam uanble to get forward months values as zeros

    i wrote below expression

    =iif(Fields!Finance_Indicator.Value="Forecast",IIF(CDate(Fields!Month_Name.Value + " 01, "+Fields!Financial_Year.Value) > Now(),

    SUM(Fields!Performance_Amount_Usd.Value),0),SUM(Fields!Performance_Amount_Usd.Value))

    can any one please help me...how to get this....

  • This part looks iffy:

    CDate(Fields!Month_Name.Value + " 01, "+Fields!Financial_Year.Value)

    Why not use DateSerial(Year,Month,Day)?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply