Solved

SSRS Report Preview Problem

Posted on 2014-09-06
4
587 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
Comment Utility
so it successfully runs sometimes and shows this error at other times?
0
 

Author Comment

by:spen_lang
Comment Utility
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 500 total points
Comment Utility
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
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

With most software applications trying to cater to multiple user needs nowadays, the focus is to make them as configurable as possible. For e.g., when creating Silverlight applications which will connect to WCF services, the service end point usuall…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
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…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

743 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now