Export to Excel Problem..! URGENT

Hi All,
I'm facing one problem when I'm exporting my report to excel. I have a
report with 200 pages and 120 columns. When I'm exporting that report, After
waiting for some time (I think its around 3 min) its asking windows challenge
box for my user credentials, even after giving the correct credentials also
its saying that "You are not authorized to view this page". Some times its
giving a different error like "ASP.Net" yellow page error. But for the small
reports its working fine.
Can any one help me out on this issue. Early replies will highly appreciated.
Thanks,
VeereshMy guess it that your timing out, there are several spots that timeouts can
be set, manually time how long it takes to get the log on prompt. Find this
number in the settings, then raise it. IIS timeout, web.config?,
machine.config? , report server setting, sql timeout, web service timeout, on
so on......
Good luck.
"Veeresh" wrote:
> Hi All,
> I'm facing one problem when I'm exporting my report to excel. I have a
> report with 200 pages and 120 columns. When I'm exporting that report, After
> waiting for some time (I think its around 3 min) its asking windows challenge
> box for my user credentials, even after giving the correct credentials also
> its saying that "You are not authorized to view this page". Some times its
> giving a different error like "ASP.Net" yellow page error. But for the small
> reports its working fine.
> Can any one help me out on this issue. Early replies will highly appreciated.
> Thanks,
> Veeresh
>|||KENWOOD is dead on with his suggestion. Had the same thing happen. IIS is
set to timeout at 120 seconds or something, and so these requests run too
long, and it craps out. Up your IIS timeout and you are good to go.
"KENWOOD" wrote:
> My guess it that your timing out, there are several spots that timeouts can
> be set, manually time how long it takes to get the log on prompt. Find this
> number in the settings, then raise it. IIS timeout, web.config?,
> machine.config? , report server setting, sql timeout, web service timeout, on
> so on......
> Good luck.
> "Veeresh" wrote:
> > Hi All,
> > I'm facing one problem when I'm exporting my report to excel. I have a
> > report with 200 pages and 120 columns. When I'm exporting that report, After
> > waiting for some time (I think its around 3 min) its asking windows challenge
> > box for my user credentials, even after giving the correct credentials also
> > its saying that "You are not authorized to view this page". Some times its
> > giving a different error like "ASP.Net" yellow page error. But for the small
> > reports its working fine.
> >
> > Can any one help me out on this issue. Early replies will highly appreciated.
> >
> > Thanks,
> > Veeresh
> >

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
>