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
>

Report Loading Error

I have developed a report and deployed it successfully. After I input all the parameters, the report cannot be displayed and shows the error as follows:

???? (rsProcessingAborted) ??
??? 'tempDB' ?? (rsErrorOpeningConnection) ??
Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection.

The report can be loaded a few times before and cannot be loaded now.

I have checked that the DB security setting of authentication is set to "SQL Server and Windows" already.

Any idea to solve this problem?

msfriend wrote:

I have developed a report and deployed it successfully. After I input all the parameters, the report cannot be displayed and shows the error as follows: ???? (rsProcessingAborted) ?? ??? 'tempDB' ?? (rsErrorOpeningConnection) ?? Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection. The report can be loaded a few times before and cannot be loaded now. I have checked that the DB security setting of authentication is set to "SQL Server and Windows" already. Any idea to solve this problem?

Should be authentication problem. Did you find any solution?