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

sql server reporting services

group:

Question about the display format



Question about the display format Tony
6/18/2006 7:43:01 PM
sql server reporting services: Hi,

I want to display the value (for example: 23.5). So I use the following
function:

=Format( Fields!DiscountPercentage.Value, "##.##") & "% Discount:"

It shows => 25.5%

It looks ok but when the value is (0.01), it shows
It shows => .01%

How to change the display to
0.01%

Thank You!
Tony




Re: Question about the display format Raghu
6/19/2006 1:11:56 AM
Use this expression instead,

=Format( Fields!DiscountPercentage.Value, "#0.##") & "% Discount:"


[quoted text, click to view]
Re: Question about the display format Tony
6/19/2006 7:34:01 AM
Yes ! Thank you Raghu!

[quoted text, click to view]
AddThis Social Bookmark Button