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
> >