March 15, 2010 at 11:37 pm
Hi all
I've just encountered a funny issue with the SQL SSRS 2008 Excel format. I've built a small report that has a matrix control with a single column group, and two data fields. I've deployed it to our production server which is a 2008 std server. When I view the report in IE, its rendered perfectly. However when I export it to XLS, all values are #VALUE! in each cell that contained a value.
Things I've checked:
The report renders perfectly to Excel in BIDS 2005 (not using 2008 to design reports).
The report renders correctly in other formats eg. PDF and Word on 2008
The report renders correctly in Excel on my Dev server (SQL 2005 Ent)
The stored proc that produces the data, has its values converted to Int's (just in case there was a formatting issue from float to int in SSRS).
Column widths are more than wide enough
Any clues?
March 16, 2010 at 5:28 am
try formatting your value fields in the report before exporting. Use something like "0" or "0.00" in the format field and see if that works
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
March 16, 2010 at 5:35 am
Hi
Thanks, I had done that previously, originally used "#0", then later changed to plain "0". Didn't make a difference though.
March 16, 2010 at 6:06 am
I've pulled the Solution into BIDS 2008, and deleted and recreated the matrix. Excel rendering is now correct on the same server. Not the ideal solution but, worked around.
March 16, 2010 at 12:05 pm
Thanks for the work around. Must be some kind of MS bug.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply