sql server reporting services: Splitting a database field -- sql server reporting services

Splitting a database field

Jill
10/13/2004 12:07:07 PM

sql server reporting services:

Hi,
I have a field in my database that is height. It is laid out like 510 (5
feet, 10 inches)
I would like to split this up in my report so that I can use something like
this in a text box -
=Fields!htft.Value + "'" + Fields!htin.Value + """ to get the result to be
5'10" instead of it showing 510. Does anyone have any idea how to do this?

Thanks
Jill

RE: Splitting a database field

Jill
10/13/2004 12:53:03 PM

Nevermind. I found the answer -
=Format(Convert.ToDouble ( Fields!Ht.Value), "#ft ##in")

Thanks
Jill

[quoted text, click to view]

Re: Splitting a database field

jerrynixon NO[at]SPAM gmail.com
10/14/2004 11:16:41 AM

You had a typo.

Your original:

=Fields!htft.Value + "'" + Fields!htin.Value + """

The corrected:

=Fields!htft.Value + "'" + Fields!htin.Value + """"

or here's another output for you to try:

=Fields!htft.Value + "'" + Fields!htin.Value + "''"

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.