Post reply

problem in building the expression... plz help!

  • March 17, 2010 at 11:29 pm

    #218017

    hey guys i am very new to SSRS 2008,

    I have to design one expresion for one text box which will give count of some fields.

    ex. want to count total number tickets with status P or T or C for yesterday.

    As we cant use where clause while writting expession here , i nt been able to write the expression

    want working expression for following condition

    count(fields!tickets.value = "P" or "C") where ticket_date <>today()

    it should give the count of tickets for the date not equal to today

    Your timely help will be appreciated

    Regards,

    Shekhar

  • March 18, 2010 at 1:50 pm

    #1136276

    What about:

    =IIF(fields!ticket_date.value <> today(), count(fields!tickets.value = "P" or "C"),0)

  • March 19, 2010 at 1:53 am

    #1136507

    Hi,

    u need to use individual or condition to work this....

    count(fields!tickets.value = "P") or count(fields!tickets.value = "C") ...

    Thanks

    Veeren:)

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

  • March 20, 2010 at 3:06 am

    #1137157

    Thanks guys it worked for me..

    Regards,

    shekhar

  • March 22, 2010 at 12:12 am

    #1137416

    Cheers please let us know if u have any questions..

    Thanks

    Veeren.

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

Viewing 5 posts - 1 through 4 (of 4 total)

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