Solved

SSRS Report Preview Problem

Posted on 2014-09-06
4
608 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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 video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

911 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

24 Experts available now in Live!

Get 1:1 Help Now