Symptom
- How to configure the proxy?
- My company as a proxy set on the network. Salesforce.com is in the cloud, and it's only accessible via an http url. How to setup the proxy for the Salesforce.com connectivity in Crystal Reports?
- Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
- Salesforce.com
Resolution
- The proxy configuration for the Salesforce.com connectivity in Crystal Reports is set in the file: CRConfig.xml:
-
Navigate to the CRConfig.xml file, which is by default at the following location:
- For Crystal Reports 2008:
C:\Program Files (x86)\Business Objects\Common\4.0\java
- For Crystal Reports 2011, 2013, and 2016:
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\ -
Open the CRConfig.xml file in a text editor, like: Notepad.
-
Add the following lines to the <SForce> section of the XML file, with your proxy settings:
<UseProxy>TRUE</UseProxy>
<ProxyAddress> Add the proxy name here </ProxyAddress>
<ProxyPort> Add the proxy port number here </ProxyPort>
Below is an example of how the xml file will look after adding the proxy setting for the Salesforce.com connection, if the proxy name is: MyProxy, and the port number: 1234
<SForce>
<UseProxy>TRUE</UseProxy>
<ProxyAddress>MyProxy</ProxyAddress>
<ProxyPort>1234</ProxyPort>
<CacheRowSetSize>100</CacheRowSetSize>
<QueryBatchSize>2000</QueryBatchSize>
<SocketTimeout>600000</SocketTimeout>
<BatchLookupCacheJoinSize>200</BatchLookupCacheJoinSize>
</SForce>
If your Proxy has a user name and password, you can add the option ProxyUsername and ProxyPassword.
Below is a second example of how the xml file will look after adding the proxy setting for the Salesforce.com connection, if the proxy name is: MyProxy2, and the port number: 5678, and the user name and password are: MyUser / MyPassword
<SForce>
<UseProxy>TRUE</UseProxy>
<ProxyAddress>MyProxy2</ProxyAddress>
<ProxyPort>5678</ProxyPort>
<ProxyUsername>MyUser</ProxyUsername>
<ProxyPassword>MyPassword</ProxyPassword>
<CacheRowSetSize>100</CacheRowSetSize>
<QueryBatchSize>2000</QueryBatchSize>
<SocketTimeout>600000</SocketTimeout>
<BatchLookupCacheJoinSize>200</BatchLookupCacheJoinSize>
</SForce>
And if your Proxy servers require a domain name as well. Then use: DOMAIN\USERNAME, for the option: ProxyUsername -
Save the CRConfig.xml file, and re-start Crystal Reports.
- Note:
To know your company network proxy configuration, contact your IT Administrator.
A second suggestion will be to verify if the proxy information is available in Internet Explorer (IE).
To verify the proxy setting in Internet Explorer:
- In Microsoft Internet Explorer, select "Tools - Internet Options"
- In the "Internet Options" window, under the tab "Connections", click the button: "LAN Settings"
- In the "Local Area Network (LAN) Settings" window, if a proxy setting was added in Internet Explorer, it will display it in the format:
http://<Proxy Name>:<Proxy Port>
Take the proxy configuration setting found in Internet Exploter and add it to the CRConfig.xml file.
Keywords
SForce, configure HTTP proxy, proxy, salesforce.com, SFDC , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To