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.

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


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 Chris [MSFT] on 12/4/2009 at 3:13 PM

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

Best regards,
Chris B.