Hi All,
This question pertains to sql server reporting services 2005.
I have a report in which i am using a stored procedure to populate the dataset. However if i run that report in the IDE or the browser it takes forever to run and nothing happens even after 30 min.
I thought something was wrong with the stored procedure so i ran it separately in the SQL server management and it runs in about 25 secs.
I am clueless why it is behaving like this.
Any suggestion will be appreciated.
HI,abhi81 :
Here are a few things to check:
- 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.
And you can try to use a simply store procedure and make sure it is not the problem related to your comlicated one.
Hope this helps.
