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

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<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 478382 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/29/2009 5:23:20 PM
Access Restriction Public

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.
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