1452720 - How to connect to XML and Web Services data through a proxy

SAP Knowledge Base Article - Public

1452720 - How to connect to XML and Web Services data through a proxy

Symptom

  • Using the Crystal Reports 2008 XML & Web Services driver to connect either to HTTP or to a Web Service that is deployed outside your network with a proxy in place, may cause connection issues

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. Create Report using XML & Web Services driver against the datasource behind Proxy 
  2. Refresh report

Cause

Crystal Reports requires additional configuration to bypass Proxy

Resolution

***WARNING***: The following resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems. Use the Registry Editor at your own risk. Refer to Note 1323322 for more information.
  • A registry string value named JVMOptions needs to be created.
  • When logged on to a local machine and using the designer or a thick client application, create the string value in your HKEY_CURRENT_USER hive as follows:

HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports for CR 2008

or

HKEY_CURRENT_USER\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports for CR 2011 and higher

  • In a server environment (service running under some account (typically the local system account) like W3WP.exe/ Pageserver.exe etc.) using  BusinessObjects Enterprise, Edge or Crystal Reports Server, create the string value as below:

64-bit Windows (for BOE XI 3.1)
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports

64-bit Windows (for BI XI 4.X)
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite XI 4.0\Crystal Reports

32-bit Windows (for BOE XI 3.1)
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports

32-bit Windows (for BI XI 4.X)
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite XI 4.0\Crystal Reports

  • The JVMOptions string should have the following information:

-Dhttp.proxyHost=proxy_name;-Dhttp.proxyPort=port;-Dhttp.proxyUser=user_name;-Dhttp.proxyPassword=password
Replace proxy_name, port, user_name and password with the appropriate information for your proxy server.

  • Please contact your local IT department for more information.

 

Keywords

KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1