<div>
You probably want to start by checking your event viewer logs to see what exactly is causing the crash. Could be a million things without any further info.<br />
See if you can find the error message in the event log and go from there.
</div>


You probably want to start by checking your event viewer logs to see what exactly is causing the crash. Could be a million things without any further info.
See if you can find the error message in the event log and go from there.

<div>
How many records does the dataset of the crashing report return? &nbsp;Sometimes BIDS can't handle large amounts and crashes to desktop as you've experienced.<br />
<br />
When I'm in a situation like that I usually &quot;solve&quot; this by adding a TOP clause (SELECT TOP 1000 ...) during development. &nbsp;Don't forget to remove it once the report is ready for deployment!<br />
<br />
Also, check if you've got all latest service packs installed for both SQL Server and Visual Studio.
</div>


How many records does the dataset of the crashing report return?  Sometimes BIDS can't handle large amounts and crashes to desktop as you've experienced.

When I'm in a situation like that I usually "solve" this by adding a TOP clause (SELECT TOP 1000 ...) during development.  Don't forget to remove it once the report is ready for deployment!

Also, check if you've got all latest service packs installed for both SQL Server and Visual Studio.

<div>
After further research this is what I came up with I uninstall SQL prompt and it fixed the problem.
</div>


After further research this is what I came up with I uninstall SQL prompt and it fixed the problem.

<div>
<div class="content wysiwyg-content">
When working in SSRS in Visual Studio 2008 I have created a report when I preview the report it crash and drop me out of VS. If it is a small report I can preview it. These reports are on the server and other can bring up the same reports and have no problems. Is there a setting in VS that could be causing this problem?
</div>
</div>


When working in SSRS in Visual Studio 2008 I have created a report when I preview the report it crash and drop me out of VS. If it is a small report I can preview it. These reports are on the server and other can bring up the same reports and have no problems. Is there a setting in VS that could be causing this problem?

Visual Studio 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.