Count of values if the Condition is true -In ssrs Report-

• jprabha.d

  Ten Centuries

  Points: 1086

  More actions

  June 23, 2010 at 5:42 am

  #236814

  Hi ,

  I have to create a Report in SSRS , I have Column say "A" which as a values Like

  9

  -8

  0

  7

  0

  -1

  7

  7

  I Need to write a Expression If the Value =0 then Get the count of the values .

  For example in the Above Column -"A" If Value =0 then the Count =2 ,it should display me the total specifc value count occuring in the "A".

  Please let me know ..How to write the Expression for this .

  Thanks In Advance..

• veeren4urs

  SSCrazy

  Points: 2763

  More actions

  June 23, 2010 at 8:59 am

  #1184008

  Hi,

  I will prefer to do this in the my query level not in the report.If you want to do this write custom code for the good performance.

  Thanks

  Veeren

  Thanks & Regards,
  Veeren.
  Ignore this if you feel i am Wrong. 😉