Report page hanging in browser

Hi all,
using SQL2000 sp4
How can I see why a report is not loading in browser.
Just hangs with hour glass. not even the paremeter input fields are loading?
I haven't even clicked view report?
other reports are fine.
thanks,
gvOn Apr 26, 1:37 pm, "gv" <viator.ge...@.gmail.com> wrote:
> Hi all,
> using SQL2000 sp4
> How can I see why a report is not loading in browser.
> Just hangs with hour glass. not even the paremeter input fields are loading?
> I haven't even clicked view report?
> other reports are fine.
> thanks,
> gv
Do you have default(s) on your report parameter(s) set to query? It
sounds like the report parameter'(s) dataset/query is hanging. How
complex is the query for the report parameters? Also, make sure that
you do not have Auto-refresh set on the report (via Layout tab ->
Report drop-down -> Report Properties... -> General tab) or set too
frequently. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks! I will look at what you suggested.
gv
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1177639744.633440.121190@.n35g2000prd.googlegroups.com...
> On Apr 26, 1:37 pm, "gv" <viator.ge...@.gmail.com> wrote:
>> Hi all,
>> using SQL2000 sp4
>> How can I see why a report is not loading in browser.
>> Just hangs with hour glass. not even the paremeter input fields are
>> loading?
>> I haven't even clicked view report?
>> other reports are fine.
>> thanks,
>> gv
>
> Do you have default(s) on your report parameter(s) set to query? It
> sounds like the report parameter'(s) dataset/query is hanging. How
> complex is the query for the report parameters? Also, make sure that
> you do not have Auto-refresh set on the report (via Layout tab ->
> Report drop-down -> Report Properties... -> General tab) or set too
> frequently. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>