Visual Studio Crashing on One Report when Previewing
I've got a report I'm trying to work with and every time I try to preview it Visual Studio crashes. I created the SQL in Management Studio - it's nothing complicated, it doesn't have any parameters or anything. It takes 9 seconds to run. My colleague has a theory that it's my PC because it's a bit old 4GB RAM, AMD Athlon 64 x2 Dual Core 4200 2.2GHz but I'm not convinced. Sure it sometimes churns away on a long countif but it does do the job (eventually!). I looked at task manager when running the report, the memory seems to be at around 2.2-2.5 and the CPU gets up to high 80s but only for a brief spike, most of the time its between 40-60% This is the error I receive: Problem signature: Problem Event Name: CLR20r3 Problem Signature 01: devenv.exe Problem Signature 02: 9.0.30729.1 Problem Signature 03: 488f2b50 Problem Signature 04: System.Drawing Problem Signature 05: 2.0.0.0 Problem Signature 06: 49cc5f38 Problem Signature 07: 24b Problem Signature 08: 121 Problem Signature 09: System.ComponentModel.Win32 OS Version: 6.0.6002.2.2.0.256.6 Locale ID: 2057 Additional information about the problem: LCID: 1033 Read our privacy statement: http://go.microsoft.com/fwlink/?linkid=50163&clcid=0x0409 I've tried the same report in a different project, and in a new project. I've also tried deleting the .suo file in the project directory. All to no avail. Yeah, I have tired a reboot too! The report does work fine on my colleagues PC, which incidentally is a newer PC with Win7, i5 processor and 4GB RAM. Any ideas people? Thanks in advance :)
January 31st, 2011 6:31am

Happening on another report now. The same error as above, the report has quite a few columns so I guess is fairly hefty from a data perspective - 49 columns, 8,000 rows, 11 seconds to run...
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 7:34am

Hi Rob, Due to hardware resource limitation, at report design time, you can use small data for test in the BIDS. To do it, add TOP N, for example, TOP 20, sql command in the select clause. You can remove the command if the report is ready to be deployed to report server. thanks, Jerry
February 3rd, 2011 4:21am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics