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

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

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

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

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