sql server reporting services: How to format cell according to different data type -- sql server reporting services

How to format cell according to different data type

ottawa111
4/3/2005 2:37:33 PM

sql server reporting services: Hi,
I have a table cell which could accomodate date,currency,numeric at run
time,how do I set up individual format for each type? I don't know vb
so I'd appreciated for any help.
Thanks

RE: How to format cell according to different data type

Mary Bray [SQL Server MVP]
4/3/2005 5:45:02 PM

Getting the difference between curency and numeric is a challenge, for the
rest you can do a nested iif expression for the format property eg:

=iif(isdate( Fields!Yourfield.Value),"dd MMM
yyyy",isnumeric(Fields!Yourfield.Value),"N","C")

[quoted text, click to view]

Re: How to format cell according to different data type

ottawa111
4/3/2005 8:01:06 PM

Thanks a lot

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.