SSRS loading problem

Posted on 2012-04-05
Medium Priority
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?
Question by:E J Pope
  • 3
  • 2
LVL 11

Expert Comment

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

Expert Comment

ID: 37815213

Author Comment

by:E J Pope
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).

Accepted Solution

E J Pope earned 0 total points
ID: 37897235
We have upgraded our SQL with a patch and that seems to have solved our problem.

Author Closing Comment

by:E J Pope
ID: 37913810
We figured out what to do.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

624 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