syntax error

  • hi

    whats wrong with this exp

    =iif(trim(cstr(Fields!Total.Value ="")),"?",iif(trim(cstr(isnothing(Fields!Total.Value))),"?",Fields!Total.Value))

    plz help

    this is int field

  • hbtkp (3/30/2012)


    hi

    whats wrong with this exp

    =iif(trim(cstr(Fields!Total.Value ="")),"?",iif(trim(cstr(isnothing(Fields!Total.Value))),"?",Fields!Total.Value))

    plz help

    this is int field

    thats not sql? what program are you using for this. its probably a syntax error as you suggest but hard to figure out when the program is unknown.


    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • its expression in text box of ssrs

  • Please don't cross post. It just wastes peoples time and fragments replies.

    No further replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1276016-1633-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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