how to get the hiding columns which have no amounts in ssrs and place zeros in those amounts....

• Mkrish

  Ten Centuries

  Points: 1256

  More actions

  September 22, 2014 at 1:25 am

  #290938

  I have an ssrs report.......where i don't have amounts for some months for some financial years....

  for the months that contain no amounts are hiding...

  but i have to get all months

  i have tried the below expression but iam not getting the months that contains no amounts and i want to place 0 in place of amounts for the months that contains no amounts.....

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

  and i also tried

  =iif(IsNothing(SUM(Fields!Performance_Amount_Usd.Value)),0,SUM(Fields!Performance_Amount_Usd.Value))

  but iam unable to get those months that contains no amounts....

  is there any other way how to get all the months and how to place zero for the months that contains no amount.........

  please help me...