On Jun 21, 5:11 pm, phanigk <phan...@hotmail.com> wrote:
> Hi,
>
> I am creating a simple report which will execute a stored procedure and will
> display the result.
>
> If I run the SP from query analyzer it runs simply fine. When I run the
> report, the report is getting hung and when I check the SPIDs in the DB, its
> showing as suspended in status. My entire BI studio is getting hung and I had
> to close it not sure why
> ( all are 2005 services).
>
> Any fast responces are help greatly appreciated.
>
> Thanks,
> Phani

"EMartinez" <emartinez.pr1@gmail.com> wrote in message
news:1182475754.993149.267650@d30g2000prg.googlegroups.com...
> On Jun 21, 5:11 pm, phanigk <phan...@hotmail.com> wrote:
>> Hi,
>>
>> I am creating a simple report which will execute a stored procedure and
>> will
>> display the result.
>>
>> If I run the SP from query analyzer it runs simply fine. When I run the
>> report, the report is getting hung and when I check the SPIDs in the DB,
>> its
>> showing as suspended in status. My entire BI studio is getting hung and I
>> had
>> to close it not sure why
>> ( all are 2005 services).
>>
>> Any fast responces are help greatly appreciated.
>>
>> Thanks,
>> Phani
>
>
> Here are a few things to check:
> - If you are accessing a SQL Server 2000 database from SSRS 2005, it
> will most likely not work very well, if at all.
> - Make sure that you're report project Datasource is setup correctly
> (i.e., has the correct connection string, etc).
> - Make sure that if you are passing parameters to your stored
> procedure/query, that you tie them correctly in the dataset (via the
> Data tab -> Edit Dataset button [...] -> Parameters tab).
> - If you are using report parameters, make sure that your datasets are
> not erroring out for those parameters.
> - Lastly, make sure that you have the latest service pack for SQL
> Server.
> Hope this helps.
>
> Regards,
>
> Enrique Martinez
> Sr. Software Consultant
>