SAP Knowledge Base Article - Public

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

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

Resolution

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

Keywords

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

Product

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