March 30, 2012 at 1:57 pm
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
March 30, 2012 at 2:02 pm
hbtkp (3/30/2012)
hiwhats 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 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]
March 30, 2012 at 2:04 pm
its expression in text box of ssrs
March 30, 2012 at 2:34 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply