SSRS 2008 Crash

Question

SSRS 2008 Crash

mirravi

Mr or Mrs. 500

Points: 530
More actions
December 13, 2010 at 7:54 am

#232454

Hi,
When i try to preview a report (SSRS 2008) , after few seconds , pops up an error message MS visual studio has encountered a problem and needs to close.
Iam using ssrs 2008 Ent. edition SP1.
The query fetch more than 300000 records.
It works fine when it fetches 16000 records for other reports.
Could any one help me in sorting out this problem.
Thanks in advance
Ravi

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

there are a number of threads here on SSC on this basic issue; it has to do with running out of memory;

there's not a lot you can do other than select fewer records; a beefier developers machine might be able to select more records, but eventually every machine hits that tipping point where the number of records you select is greater than the capacity for the GUI to render.

changing your design is going to probably be the best decision; page the number of records being presented into something human consumable...add a end user filter criteria so they can limit the records based on some filter.....

NOONE can actually review 300K records, so it's not right to try to display them all in the first place...remember the purpose of a web page to report data is to report relevent data...not everything in the database!

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mirravi Mr or Mrs. 500 Points: 530 More actions · Answer 2

Thanks for your reply.

i need to generate the report and export it to excel , which will have 18 sheets on it.Its an monthly basis report i should run.

Lowell SSC Guru Points: 323518 More actions · Answer 3

mirravi (12/13/2010)
Thanks for your reply.
i need to generate the report and export it to excel , which will have 18 sheets on it.Its an monthly basis report i should run.

I'd recommend switching to SSIS and a CSV file instead of report services then; that will take the load off of trying to build a presentation and then saving it.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!