Reporting Services Export Format - Percentages - by John T. Williams

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 299995 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 9/26/2007 3:49:58 PM
Access Restriction Public

Description

A cell with the formatting code of "P1" in Reporting Services will export to Excel with a formatting code of "[$-1010409]#,##0.0#%". This code will cause values that with a non-zero second decimal point to show two decimals, instead of one decimal point. 

For example:
Actual Number - 100.55
Displayed in RS - 100.5
Displayed in Excel - 100.55

Sign in to post a comment.
Posted by starsky51 on 7/11/2012 at 7:33 AM
We're running SSRS 2008 SP1 and this is still an issue. Is it fixed in R2?
Posted by Microsoft on 11/12/2007 at 10:59 AM
This has been resolved in SQL Server 2008 Reporting Services. I would encourage you to download the upcoming CTP and make sure that you are seeing the behavior you expect.