SAP Knowledge Base Article - Public

1354315 - How to create QAAWS using Crystal Report SQL query in BOE 3.1?

Symptom

 What are the steps to create a Query As A Web Service from Crystal Report?

Environment

  • BusinessObjects Enterprise XI 3.1
  • Crystal Reports Designer 2008

Resolution

 
In Crystal Report Designer:
  1. Create a Crystal Reports from Database using drivers (ODBC/OLEDB/Native connection)
  2. Run the Report -> Go to Database -> Show SQL Query.
  3. Copy the SQL
  4. Convert the SQL to Stored Procedure.

 In Universe Designer: 

  1. In BOXI 3.1, Using Stored Procedure create a Universe in Designer.
  2. Save the universe
  3. Export it to repository 

In Query as a Web Service:

  1. Login to QAAWS
  2. Go to Query -> New -> Query
  3. Give the Query Name -> click on Next
  4. Select the Universe -> click on Next.
  5. Drag and drop the objects in to Result Objects -> click on Next
  6. Click on Publish. WSDL URL will generate.
  7. Double click on ‘To Clipboard’
  8. Copy the URL in the notepad.

In Crystal Reports Designer:

  1. Create a new CR 2008 report using the Standard Report Creation Wizard.
  2. Select the option XML and Web Services. It will prompt to select XML as a local data source or Web Service Data source.
  3. Select Web Service Data Source.
  4. Next prompt would be for selecting the Local WSDL file or HTTP WSDL file which comes as a URL.
  5. Select Http WSDL file which is stored on your local machine.
  6. Once finished, the service, port and method will appear in WSDL file.
  7. The connection is ready with WSDL file as a web service data source.
  8. Once finished, it will prompt for the values. 

 

Keywords

Crystal Reports,QAAWS. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

Crystal Reports 2008 V1