Sunday, February 26, 2012

Export to Excel Problem

Hi,
i am facing a problem to export data to MS Excel.
In the financial report, I have month and date from 9/1/1998 to present
(hardcode all the column).
Users would like to export those data into an Excel spreadsheet.
However, if users choose the date from 1/1/2003 to 1/1/2004 then all the
date before 1/1/2003 will become one big blank/empty column since the width
of the report doesn't change. when all data are exported to the Excel
spreadsheet, that big blank/empty column generates an error and it said
"Excel Rendering Extension : Width of excel cell in the excel sheet exceeded
the maximum limit of 1726.5 Points."
Does anyone see this kind of error before or any suggestion/idea about how
to fix this problem.
Many thanks
EdPlease check this thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=8541dc14-86f5-4ea5-a764-802433a51e2b&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:B1E76E31-D461-4D21-96BB-A6B8297044E5@.microsoft.com...
> Hi,
> i am facing a problem to export data to MS Excel.
> In the financial report, I have month and date from 9/1/1998 to present
> (hardcode all the column).
> Users would like to export those data into an Excel spreadsheet.
> However, if users choose the date from 1/1/2003 to 1/1/2004 then all the
> date before 1/1/2003 will become one big blank/empty column since the
width
> of the report doesn't change. when all data are exported to the Excel
> spreadsheet, that big blank/empty column generates an error and it said
> "Excel Rendering Extension : Width of excel cell in the excel sheet
exceeded
> the maximum limit of 1726.5 Points."
> Does anyone see this kind of error before or any suggestion/idea about how
> to fix this problem.
> Many thanks
> Ed
>

No comments:

Post a Comment