1294512 - How to configure the HTTP proxy for the Salesforce.com connectivity for Crystal Reports?

• 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.

• SAP Crystal Reports 2008
• SAP Crystal Reports 2011
• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
     
• Salesforce.com

• The proxy configuration for the Salesforce.com connectivity in Crystal Reports is set in the file: CRConfig.xml:
     

1. 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\

2. Open the CRConfig.xml file in a text editor, like: Notepad.

3. 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  

4. 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:
       
1. In Microsoft Internet Explorer, select "Tools - Internet Options"
2. In the "Internet Options" window, under the tab "Connections", click the button: "LAN Settings" 
3. 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.
   

SForce, configure HTTP proxy, proxy, salesforce.com, SFDC , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020