1426248 - WSDL URL not working with Crystal Reports 2008 V0.

SAP Knowledge Base Article - Public

1426248 - WSDL URL not working with Crystal Reports 2008 V0.

Symptom

  • Crystal Report based on the WSDL using URL is not working.
  • The Service, Method and Port are not visible in report creation wizard. While the same url works in internet browser.

Environment

Crystal Reports 2008 V0

Reproducing the Issue

  1. Create a Crystal Report based on a WSDL.
  2. In Database Expert select new connection type as ‘XML and Web Services’.
  3. On the next window select the option for ‘Use Web Service Data Source’
  4. Check the option for ‘Use HTTP(S) WSDL’ and provide the URL for accessing the WSDL.
  5. Provide User Id and Password if required. In next window it does not show the Service, Port and Method. If it is manually entered it does not accept.

Cause

The problem arises due to WS-Security enabled Microsoft Web Service.

With Crystal Reports 2008 Service Pack 0 release, SOAP 1.2 was not supported. This limits connectivity to WS-Security enabled Microsoft Web Service stacks to ASP.NET (ASMX with WSE 3.0). Microsoft’s Windows Communication Foundation (WCF) WS-Security implementation (the WSHttpBinding) requires SOAP 1.2. Future Crystal Reports 2008 service packs are likely to add support for SOAP 1.2.

Resolution

Please see attached document which demonstrates how to create a WS-Security enabled Web Service and then write a Crystal report that can consume it.

Keywords

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

Product

Crystal Reports 2008 V0

Attachments

CR2008 using WS Security WSDL.pdf