Home Dashboard Directory Help
Search

Reporting Services Export Format - Percentages by John T. Williams


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


1
0
Sign in
to vote
Type: Bug
ID: 299995
Opened: 9/26/2007 3:49:58 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

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

Details
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.
Sign in to post a workaround.