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 |
|
cardgunner
326 Posts |
 Posted - 2008-12-17 : 15:58:38
|
| After I installed SP1 for SQL 2000 Reporting Services I had trouble running a few of my reports. If I previewed the report without any changes to the data section(tab) it ran fine. Once I made a change to the data section and tried to go to preview or layout the report would "think" for an hour. While it was thinking it would take up most of my CPU rendering anything else I was doing slow.I uninstalled it and the report ran fine. I installed SP1 and SP2 it would hang up. It onlys happens to about 6 reports. I could not find one thing that these reports had in common other then they all had complicated SQL statements. Mind you these statements run fine when SP1 is not installed. By complicated I mean these reports have, temp tables with unions , or some with no temp tables but unions, or some with no unions but temp tables, or some with no temp tables and no unions but alot of tables.I have tried to simplify the SQL but in doing so I loose some the abilty at times to layout the report in a certain way. I would have to sacrifice the way the report reads to my audience. Mind you the SQL runs fine in my SQL Analyzer, less then a minute (most less then 30 seconds), and it runs fine in Reporting Services without SP1 installed. This has been a problem that I have spent days to weeks trying to diagnose.Can anyone shed some light on a fix for this?CardGunner |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cardgunner
326 Posts |
Posted - 2008-12-17 : 16:31:17
|
| When I run this report from the server it deploys fine.It is only when I make a change in the SQL of the data set.This change can be as simple as adding a -- in a new line.The change does nothing to the SQL however when I then go to layout tab or preview tab it sits there and thinks for about an hour. While it thinks it uses up all my CPU which renders anything else I'm doing useless till I either X out of it or it stops running.CardGunner |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Problems with SQL 2000 Reporting Services SP1