Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSRS Report Preview Problem

Posted on 2014-09-06
4
Medium Priority
?
735 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

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 …
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

715 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