1452194 - Unable to connect Web services using Crystal Reports

SAP Knowledge Base Article - Public

1452194 - Unable to connect Web services using Crystal Reports

Symptom

  • After selecting Web Services as data source, the web Service cannot be accessed
  • The Port and Method are not populated and contain blank values                                               
                                                                                                                   
                                                                                                                                        
                 

Environment

  • Crystal Report XI Release 2
  • Crystal Report 2008

Reproducing the Issue

  • Launch Crystal Reports 2008
  • From the Start Page, choose Report wizard, this will launch the Standard Report Creation
  • Next expand Create New Connection, and scroll down to XML and Web Services and expand the folder.
  • The XML and Web Services data source  dialog box will appear.  Choose Use Web Service Data Source and choose Next>.
  • Choosing an HTTP Web Service >Use HTTP(S) WSDL and type in:  http://www.ecubicle.net/driving.asmx?WSDL and choose Next>.
  • This Web Service does not require a UserID/Password and choose Next.
  • Note:After a moment or two, the Web Service, Port and Method screen should appear with the following: driving, drivingSoap and GetDirections in the Service, Port and Method drop downs respectively. 

    Cause

    If using the Crystal Reports 2008 XML & Web Services driver to connect either or HTTP or to a Web Service that is deployed outside the network and having a proxy in place, there may be some connection issues due to the proxy.

    Resolution

    This can be resolved with a registry entry that specifies your proxy and the logon information required to connect to it.
    A registry string value named JVMOptions needs to be created in one of the following locations depending on on the following:

    - For personal Crystal Reports use, create the string value in your HKEY_CURRENT_USER here:

    HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports

    - For common or server usage in BusinessObjects Enterprise, Edge or Crystal Reports Server, create the string value here:

    64-bit Windows:
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports

    32-bit Windows:
    HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.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.

    FOr a test data source to try, create a report using the Crystal Reports 2008 XML & Web Services driver using HTTP to connect to the following sample data set:

    http://resources.businessobjects.com/support/downloads/samples/cr/customer_db/customer.xml
    http://resources.businessobjects.com/support/downloads/samples/cr/customer_db/customer.xsd

    This is the Customer data set for the Crystal Reports 2008 sample reports. If this data set can be loaded into a report, it will confirm that the proxy configuration set correctly.

    Keywords

    Data source, connection , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

    Product

    Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2