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?

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 BusinessViews Manager , How To

Product

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