Solved

Visual Studio 2008

Posted on 2014-01-23
5
437 Views
Last Modified: 2014-01-28
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?
0
Comment
Question by:WDJ98338
  • 2
  • 2
5 Comments
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 39805588
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.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39805700
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.
0
 

Accepted Solution

by:
WDJ98338 earned 0 total points
ID: 39805776
SQL prompt by Redgate was causing the problem.

http://www.red-gate.com/messageboard/viewtopic.php?t=12431
0
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 39805781
How did you find out?
0
 

Author Closing Comment

by:WDJ98338
ID: 39814581
After further research this is what I came up with I uninstall SQL prompt and it fixed the problem.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server/SSRS 2008 r2 - Percentage Expression 6 71
SSRS Matrix Grand Total 2 47
Pivot not using aggregate yield error 3 54
Report Builder 3.0 3 37
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question