sql server reporting services: Number formatting has me stumped -- sql server reporting services

You're in the

sql server reporting services

group:

Number formatting has me stumped

PaulQld
9/25/2005 11:01:03 PM

sql server reporting services:

Hi, I dont seem to be able to output a number that has 3 decimal places.

The data source returns eg. 12.564 % and the output format on the report
is ##.###.

The output value though shows 12.56%, I want to show the figure above.

What am I missing or doing wrong? Is there a rounding switch or option I am
missing ?

Re: Number formatting has me stumped

Robert Bruckner [MSFT]
9/26/2005 10:15:49 AM

BTW, more information on number format strings can be found on MSDN:
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandardnumericformatstrings.asp

*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

RE: Number formatting has me stumped

alison
9/26/2005 11:43:03 AM

In the Textbox Properties under Format, select Custom.
Use "N3" for numbers, or "P3" for percentages. You will see the example
change to the format you are trying to get.

[quoted text, click to view]

Re: Number formatting has me stumped

Jens Konerow
9/26/2005 4:24:34 PM

Try this:
#,##0.000

returns:
50.123
0.000
15,050.123
15.050,123 (for example in german systems)

"PaulQld" <PaulQld@discussions.microsoft.com> schrieb im Newsbeitrag
news:7C955125-6CD3-49DF-9028-D0AD04D2457E@microsoft.com...
[quoted text, click to view]

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.

home · blog · groups

Questions? Comments? Contact the dn