December 5, 2005 at 4:47 pm
Hi,
Hopefully someone with a bit of experience with Visual Studio 2005 and RS can offer some advice.
I am using VS2005, sourcing a SQL2K database, and am simply trying to do a select of about 800 records from one table (ie no joins).
The report has only one grouping field - and in essence is overly simplistic just to try and understand where my issue is.
When trying to preview the report, it seems to take for ever - the hard disk starts flogging away, and processor usage increases - to the point where i eventually stop the rendering of the report (have waited in excess of 15 minutes!!!).
I have managed to get results back if I restrict the results of the query to one line - or even to 200 lines (however this takes about 5min).
Each time the hard disk goes nuts and processor usage increases.
Any ideas what is happening here? Is it a configuration setting that I am overlooking, or something more sinister?
Thanks in advance for any assistance on this.
Troy
December 6, 2005 at 12:47 pm
just a quick update on this - in case it provokes any thoughts by anyone about the possible cause of this - after deploying the report to the RS the report works fine (through the RS)...
So this works, but sadly developing and then testing the resulting output by deploying each time to the RS isn't exactly the most economical way of writing these things.
Any ideas?
Anyone?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply