Solved

SSRS loading problem

Posted on 2012-04-05
5
264 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
[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
  • 3
  • 2
5 Comments
 
LVL 11

Expert Comment

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

Expert Comment

by:SThaya
ID: 37815213
0
 

Author Comment

by:vdixon79
ID: 37825263
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
ID: 37897235
We have upgraded our SQL with a patch and that seems to have solved our problem.
0
 

Author Closing Comment

by:vdixon79
ID: 37913810
We figured out what to do.
0

Featured Post

Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

Question has a verified solution.

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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

691 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