please wait while the document is being processed

[Former Member]

I am using Crystal Reports 2008 with ASP .Net. We have been facing a weird problem for one of our clients. Whenever this client takes a report and tries to navigate to other pages of the report, Crystal gives "Please wait while the document is being processed" and never does anything. Our client is very frustrated and wants to have this fixed ASAP but unfortunately we are unable to find the cause and resolution of this problem. Few of our other clients have also faced this problem but with a lot less frequency and few of our clients never faced this problem. We never encountered this problem in our development environment as well.

Please help

Thanks

[former_member183750 · Accepted solution]

You mention CR 2008 but not the Service Pack. I'd like you to be on SP 4 - both on your dev computer and on the client computer(s). To update your dev computer download SP 4 from here:

https://smpdl.sap-ag.de/~sapidp/012002523100008782452011E/cr2008sp4.exe

To update the client, you will have to uninstall the existing rubntime on their computer, then deploy SP 4 runtime:

MSM

https://smpdl.sap-ag.de/~sapidp/012002523100008782522011E/cr2008sp4_mm.zip

MSI

https://smpdl.sap-ag.de/~sapidp/012002523100008782532011E/cr2008sp4_redist.zip

See if that helps.

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

[Former Member]

Hi Matt,

Please check your code. I have exactly the same issue and I am able to rectify the situation by commenting this line.

CrystalReportViewer1.ID = String.Format("VMD - {0}", Session["ReportVin"].ToString().Substring(11));

If you are setting the CrystalReportViewer's ID(This is done in my case to modify the report's name when exporting it to PDF) this will most likely cause the above. I have noticed, when I comment this line, the mentioned popup does not appear. Hope this helps!

[Former Member]

Ludek,

We are using Crystal Reports with ASP .Net. Crystal Report complete package, including designer, is installed on the server. And on server i opened the report in Designer and navigated through pages and it worked just fine. But even on server when i run the application and took report, it didn't work and gave the subjected popup. And as per your suggestion we have already installed Server Pack 4 on server.

It's an HTML viewer that downloads on client workstations and on navigating gives the popup. I have also put the Business Objects directory in Norton Antivirus safe list but it didn't work.

Please let me know if you want me to share the code and detail design of the viewer with you guys.

Thanks,

Matt

[former_member183750]

No, I do not want the code, but answers to my queries would be good to have :). E.g.;

Subreports set to reimport on open?

OLE objects that need to be re-linked?

Do you have to point to the customer's database in the designer before you can run it?

Create a simple app to just run the report; one line of code;

CrystalReportViewer1.ReportSource = <path to report>

Let the report prompt for the database login. How does that work?

- Ludek

[Former Member]

Don,

This happens sporadically with all reports for our all clients. But for one of our clients this issue comes very frequently and he is getting annoyed with us. There are no logs in the VSS for this specific error. I put Business Objects directory in safe list of Norton Antivirus running on server and today i will observe the affect of this change.

Thanks,

Matt

[former_member183750]

Subreports set to reimport on open?

OLE objects that need to be re-linked?

You mention that the CR designer is installed on this computer. That still does not mean you are on the latest Service Pack (highly recommended). And I am still not sure on how the report works inthe designer on that same problem machine -> do you

see any delays there?

Any status messages re. OLE linking, etc., etc.

Do you have to point to the customer's database in the designer before you can run it?

Or does the report just work in the designer as expected?

Create a simple app to just run the report; one line of code;

CrystalReportViewer1.ReportSource = <path to report>

Let the report prompt for the database login. How does that work?

- Ludek

[Former Member]

Ludek,

We install complete Crystal Reports on our servers. It means that the design is also installed on the server, which means the package we installed on the server is correct one and we don't need to run any of the other packages on our server! Right? but the problem is unfortunately not solved.

-Matt

[former_member183750]

If it is just one client (I take that to be a user on one site and other users have no issues(?)), then I'd suspect permissions. Couple of utilities you may want to consider:

1) [Process Monitor|http://technet.microsoft.com/en-ca/sysinternals/bb896645.aspx], see if when this user runs a report, you see "Access Denied" messages in the ProcMon logs.

2) [Charles|http://xk72.com/] may help sniffing out the HTTP requests. Alternatively [Fiddler|http://www.fiddlertool.com/fiddler/] will do the same and has no Java framework dependencies.

- Ludek

[former_member11696]

Hi Matt,

Does it happen with any report or just one of them? If you run that report in CR designer on the Server what happens, try running it multiple times and various time, like when they report there is a problem.

Any logs, IIS, Anti-virus etc. show access denied or an attempt to access type errors?

There was another post I read recently where the issue was due to the anti-virus software scanning the report which introduced huge delay. They add CR runtime and designer to the trusted list and it resolved the issue.

Not sure if this is Server Client side issue but can be easy enough to check their logs also.

Don

[Former Member]

Ludek,

As i mentioned earlier that we are using Crystal 208 with ASP .Net. It's an HTML control that opens the report on client workstations. We have upgarded our server to SP4 but it didn't fix the problem. We have upgraded the server by pick up the SP4 from https://smpdl.sap-ag.de/~sapidp/012002523100008782452011E/cr2008sp4.exe. And i am not sure whether this was the one we needed to install on server or was it from one of these:

MSM

https://smpdl.sap-ag.de/~sapidp/012002523100008782522011E/cr2008sp4_mm.zip

MSI

https://smpdl.sap-ag.de/~sapidp/012002523100008782532011E/cr2008sp4_redist.zip

And i have absolutely no idea what is the difference between all these. Will you please clarify.

Matt

[former_member183750]

cr2008sp4.exe is the Service Pack you apply to your development computer that has CR 2008 designer installed. You can not run this SP on a client computer as it will error out - unless there is the CR designer installed there also.

cr2008sp4_mm.zip will give you the MSM distribution package. You can create your own distribution package out of that using .NET, InstallShield, Wise, etc. MSM only contains CR files and no dependency files are included. These would be included by you into your deployment project. See KB 1544708 (it's written for CRVS2010, but the same applies to CR 2008).

cr2008sp4_redist.zip gives you the MSI which you can simply copy on to the client, double click and all the CR runtime as well as the dependencies will install. No pretty interface, no lipstick, just function.

If you want to see what files (versoins, etc.) are loaded on a computer use the [Modules|https://smpdl.sap-ag.de/~sapidp/012002523100006252802008E/modules.zip] utility.

- Ludek

[former_member11696]

Moved to .NET SDK forum