Home Dashboard Directory Help
Search

Reporting Services number format conflicts between exporting to Excel and rendering in browser by GregsListAcct


Status: 

Closed
 as Fixed Help for as Fixed


1
0
Sign in
to vote
Type: Bug
ID: 478382
Opened: 7/29/2009 5:23:20 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

I've discovered at least 3 discrepancies between the way reporting services renders a formatted number in a web browser and the way it appears in an export to Excel.

Format code: #
Web browser: renders non-zero numbers. Zero is blank.
Export to Excel: values show up as “#VALUE!”

Format code:#.#
Web browser: renders non-zero numbers in decimal format if the number as a decimal. If an integer, the “.” is not present
Export to Excel: renders the “.” always. In the case of zero, just “.” shows up. Ironically, this does not error which I would expect based on the previous example.

Format code:#.#%;;#
Web browser: renders positive and negative numbers as percentages, zero values as nothing.
Export to Excel: renders only positive numbers as percentage. Negative and zero values as nothing.
Details
Sign in to post a comment.
Posted by Microsoft on 12/4/2009 at 3:13 PM
Hello,

This bug was fixed in the SQL Server 2008 R2 release.

Best regards,
Chris B.
SSRS Team
Sign in to post a workaround.