all groups > sql server reporting services > may 2006 >
You're in the

sql server reporting services

group:

Display .356 as a percentage



Display .356 as a percentage Mark
5/24/2006 9:50:17 AM
sql server reporting services: I have several columns of data in a report that have values like .743 or
..253, and I'd like them to display as 74.3% and 25.3%.

I'm a reporting services newbie - I didn't see a format option in the
properties of a textbox. Suggestions?

Thanks in advance.

Mark

Re: Display .356 as a percentage Mark
5/24/2006 9:58:09 AM
Sorry - just found it.

Properties of Textbox- Format - enter "P2"

Mark

[quoted text, click to view]

Re: Display .356 as a percentage rmullen
5/24/2006 10:21:24 AM
that works or you can set the value of the text box to
=Format(Fields!FieldName.value, "p")
AddThis Social Bookmark Button