Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Crystal Reports 9 extremely slow connection to APS on Windows XP

Posted on 2005-05-12
Medium Priority
Last Modified: 2008-03-17
I'm currently using Crystal Reports 9 (all current service packs applied) and running it on Windows XP Professional (SP2).  Everything works fine until I try to Login to the APS to edit a report which exists in the Crystal Enterprise 9 server running Windows 2000 Server.  Connecting to the APS from Crystal Reports takes a little over a minute, and once logged in, it takes a long time to retrieve a report.  In the past, I've used to run Crystal Reports 9 in a Windows 2000 PC, and did not experience the delayed connection to the APS from Crystal Reports.  It seems to me that Windows XP Pro has problems talking to the Windows 2000 Server.  Has anybody experienced this same issue with Crystal Reports 9 running under Windows XP Pro (SP2)?  Any possible hints or solutions will be greatly appreciated!

Question by:edmanu
  • 2
LVL 26

Accepted Solution

Kurt Reinhardt earned 2000 total points
ID: 13991750
XP Pro, SP2 may indeed be a problem, but lets look at your network, first...

I have experienced this, but only with slow networks or networks with lots of hops or access restrictions.  In your case, how long does it take for you to access and login to CE via the web (ePortfolio, for example)? What is your authentication method:  LDAP, NT (SSO?) or Enterprise?  How long does it take you to access a shared drive that is based on the APS?  There's a lot of handshaking going on when open a report from an Enterprise folder across the network.  Are you on the same domain?  Is there a geographic separation between the APS and the client (offsite data center, for example)?

Regarding XP Pro, SP2 - do you have a third-party firewall running (you should)?  Is it running in conjunction with the ICF or Windows Firewall (it shouldn't be - that's bad - if you have a good third party firewall--and they're all better than the Windows firewall--it should be running on it's own).  You should double-check these settings.  If all is good, then try turning off the firewall (whichever you have running, if any) and see if there's any improvement.  Also, you could try to uninstall the Enterprise Folder plugins from Add/Remove Programs - unfortunately, I only have 8.5 (no CE) and XI with XI Crystal Reports Server running on my laptop, so I can't tell you the exact name of the plugin(s).  When you try to open a report from the Enterprise folder again, the plugin will reinstall (which will make things seem slow until they're all installed).


Author Comment

ID: 13996422

Thanks for the quick response!  The response time from accessing CE via the web is still very good, and I'm using the Enterprise authentication method.  Also, the response time from a shared drive in the server where Crystal Enterprise and its APS reside is very good.  Regarding the firewalls, yes, I've initially thought my slow connection was due to the Windows Firewall, and I disabled it and installed a third-party firewall, but the connection is still slow.  I even tried momentarily disabling the third-party firewall, just to make sure, and nothing happened, the same slow connection exists when accessing a report from Crystal Reports in Crystal Enterprise.  I will check on the domain and maybe reinstall the plugins today.  I will let you know if this works.


Author Comment

ID: 14062691

I've reinstalled the plugins and that seemed to do it.  To reinstall the plugins I just completely uninstalled then reinstalled Crystal Reports, though before applying the SP4 to Crystal Reports, I connected to Crystal Enterprise from Crystal Reports to download/create the plugins first, then I applied SP4, just in case.  Crystal Reports connects to CE as fast as before.

Thanks for your help!

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses

581 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