Solved

SSRS loading problem

Posted on 2012-04-05
5
257 Views
Last Modified: 2012-05-01
We have a simple report that sometimes runs fine and other times just keeps saying it is loading.

I can run other reports that are very complex and the report pops right up, but not this one.

I have stopped and restarterd the services, but that did not help.

Any Suggestion?
0
Comment
Question by:vdixon79
  • 3
  • 2
5 Comments
 
LVL 11

Expert Comment

by:SThaya
Comment Utility
can you increase virtual memory in your server or sytem
0
 
LVL 11

Expert Comment

by:SThaya
Comment Utility
0
 

Author Comment

by:vdixon79
Comment Utility
The virtual memory is fine.

I looked at the times and data retrieval is where the problem is.

We did find that there is a service pack suggested by MS, so we are going to do that.

Any ideas to track down the data retreival time problem?  (Sometimes the data retrieval is quick and sometimes it is awful).
Thanks,
0
 

Accepted Solution

by:
vdixon79 earned 0 total points
Comment Utility
We have upgraded our SQL with a patch and that seems to have solved our problem.
0
 

Author Closing Comment

by:vdixon79
Comment Utility
We figured out what to do.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

728 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

13 Experts available now in Live!

Get 1:1 Help Now