Percent format question -- sql server reporting services

sql server reporting services : Percent format question

bmurtha
8/9/2004 3:32:52 PM

When I format my table cell as p0 my data looks like this:
3 (Hutchison Telecoms 3G) 634 22 347 %
Orange Australia (Hutchison Telecomms) 253 47 1,858 %
Telstra MobileNet 4502 1998 4,438 %
Virgin Mobile Australia 523 249 4,761 %
Vodafone Australia 2157 937 4,344 %
yes optus 6357 2876 4,524 %

When I format the my table cell as n0 my data looks like
this:
3 (Hutchison Telecoms 3G) 634 22 3
Orange Australia (Hutchison Telecomms) 253 47 19
Telstra MobileNet 4502 1998 44
Virgin Mobile Australia 523 249 48
Vodafone Australia 2157 937 43
yes optus 6357 2876 45

what do I have to do to get this to work????

Thanks,
Bryan

Ravi Mumulla (Microsoft)
8/9/2004 4:45:42 PM

Try =(Fields!Item.Value/100.0) with format code = p0.

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]

Robert Bruckner [MSFT]
8/9/2004 5:40:43 PM

FYI: .NET formatcodes for percentage (P, P0, etc.) and also Excel consider a
value of 1 as 100%. If you have percentage values stored as already
calculated values in the database, you will need to divide as shown in
Ravi's posting.

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

[quoted text, click to view]

Lance
8/10/2004 9:48:01 AM

I would just use the P format and leave out the zero. Or you can just make
the query format the number as a percent and just skip the RS formatting.

[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 about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn