Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PaperStreet
Starting Member
4 Posts |
 Posted - 2005-05-03 : 15:37:06
|
| I have a report which is using a proc to get the data. The proc takes just over 2 minutes to run (a real smoker I know). I also have put together some code so that reports can be printed/exported from a gui app. The code is coming along except for a big problem. The report which takes over 2 minutes to run is timing out. Now, I have played with all the settings in Report Manager and set the timeout property in the dataset to 300000. It doesn't matter what I set these settings to, the report always times out around 1 min 45 seconds. However, when I run through Report Manager, all is fine. So, my question is, how do programatically set the timeout for this query? I have searched through the API and can't find anything. Suggestions? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-03 : 18:00:23
|
| So it works from Report Manager but not from your application that is calling the report? Are you using MS' Report Viewer? If so, then there is a timeout value to be set in that application as well. If it isn't Report Viewer, then it's in your application somewhere.Tara |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-05-04 : 09:00:46
|
This happened to me before, I ended up having to use a lot of strict WHERE conditions to pull of less data...it wasn't the best solution at the time but it was the only way to get some sort of report.You may want to post the procedure maybe we can trim it down?Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
PaperStreet
Starting Member
4 Posts |
Posted - 2005-05-04 : 13:12:01
|
| Tara - I'm not using MS' Report Viewer. I use the GUI to select which report to print (among other things) and call into the API to render for printing. Right now, I have reports going directly to the printer with no viewer piece in my GUI. I will try tossing a form together with the control you mentioned to see if I can pull it back that way. Jon - Yup, I'm on that path now. I started working on the proc this AM and got sidetracked. Let me see if I can get the runtime down with some tuning. If not, I'll post to get the forum's opinion. Thanks. |
|
|
|
|
|
|
|
|
Report time out when rendering