SQL Server Home
Reporting Services number format conflicts between exporting to Excel and rendering in browser
7/29/2009 5:23:20 PM
User(s) can reproduce this bug
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!”
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.
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.
SQL Server 2008 - Enterprise Edition
Win2003 Datacenter (RTM)
Operating System Language
Steps to Reproduce
create a simple .rdl file with sql SQL below to generate sample data. Then apply various format codes, deploy to a server, view in browser, then export to excel.
declare @t table (a int identity(-5,1), b int, c float )
declare @i int
set @i = 0
while @i < 20
insert @t (b) values (@i)
set @i = @i + 1
update @t set c = Case a when 2 then 2.0 else a *0.132 end
select * from @t
differing output between excel export and web rendering. The most concerning is the #VALUE! error shown by excel.
same -- or at least similar values.
to post a comment.
Please enter a comment.
on 12/4/2009 at 3:13 PM
This bug was fixed in the SQL Server 2008 R2 release.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft