Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS Report Preview Problem

Posted on 2014-09-06
4
Medium Priority
?
754 Views
Last Modified: 2014-09-09
Hi,

I have created a dashboard report that connects to several different database connections. The report takes several minutes to run due to the amount of data that is being queried.

I have just tired to preview the report and I am getting the following error:

SSRS Preview Error
Please could someone help? Is this a time-out issue?
0
Comment
Question by:spen_lang
  • 2
  • 2
4 Comments
 
LVL 3

Expert Comment

by:prequel_server
ID: 40308992
so it successfully runs sometimes and shows this error at other times?
0
 

Author Comment

by:spen_lang
ID: 40309315
Yes, I believe it is a time-out issue in Visual Studio 2008. The dataset is very large and therefore takes several minutes to load the report. I reduce the parameter range, reducing the dataset size the report runs fine.

There is no problem running the report in production once it has been uploaded to the report server.

I think I will have to put this down to another Microsoft bug...
0
 
LVL 3

Accepted Solution

by:
prequel_server earned 2000 total points
ID: 40311299
not really a bug but yes it's possible to get different behavior in Visual Studio vs running the report in the report server.  When the report is deployed onto the report server it has more resources to fetch and compile data than the Visual Studio client.  Having said that, how long does this report take in your production report server? Several minutes is not acceptable in today's inpatient society so I'm wondering how your users/the person consuming this report feels about the length of time it takes to render.

There are several ways to make it run faster. One way is to use SSIS to setup a few ETL jobs that would get the data for the report preemptively and stores it on a local sql server db.  The data would be pre-compiled and pre-aggregated to a level that's granular enough for the user. Then when the user run the report, the data is fetched from one data source and gets less rows so it will run much faster.  If you can't do this warehouse model that you may want to look at optimizing your query for better performance.

cheers
0
 

Author Comment

by:spen_lang
ID: 40311462
Hi,

Thanks for your recommendations, I would like to do this but I just haven't got the time to do this.... The report is a KPI dashboard report that compares year on year data, so the dataset is always going to be very large. The report is Snapshot every 12 hours so the users do not notice the slowness of the running of the report.

Thanks, Greg
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

783 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