how to eliminate #Error in ssrs report

• Mkrish

  Ten Centuries

  Points: 1256

  More actions

  September 23, 2014 at 12:56 am

  #290218

  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....

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  September 23, 2014 at 11:30 am

  #1747595

  This part looks iffy:

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

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