Creating a Crystal Report from a View

You can create a SAP Crystal Reports report from a view created with View Builder. Unlike a view that is accessible in standard Excel or HTML formats, SAP Crystal Reports gives you the flexibility of designing and formatting the report with all that the reporting tool offers.

Along with the design and format capabilities of SAP Crystal Reports, the security that is built into the View Builder view is preserved in the report. This ensures that only the individuals who are in the specific roles to which the view was assigned when it was created, can access and view the report.

Before you begin, do the following:

• Install SAP Crystal Reports on your HRMS Employee Self Service web server.
• Create your view using View Builder. This is the view you will use for your report. Make sure all fields you want in the report are selected in the view.

To create a Crystal Report from a view

1. Open SAP Crystal Reports.
2. From the Start page, select Blank Report.
3. In the Available Data Sources section, expand the Create New Connection folder, and then expand XML and Web Services.
4. In the XML (data source) type and location dialog box, select Use Web Service Data Source.
5. Click Next.

6. In the Web Service Location dialog box:

   1. Select Use HTTP(S) WSDL.
   2. For HTTP(S) WSDL URL, enter the following URL for the web service:
      http://[server]/selfservice/Viewserver.adv?wsdl
      where [server] is the name of your HRMS Employee Self Service web server.
7. Click Next.
8. In the Authentication for HTTP WSDL URL dialog box, leave User ID and Password blank.
9. Click Next.
10. In the Web Service, Port and Method dialog box, the Service and Port fields identify the way in which the information will be retrieved for the report. The Method list enables you to select the view (entity) that will be retrieved (by the "Get" method) for your report. All active views from View Builder are included in the list.
11. Select a view and click Finish.

12. The Data Source Selection dialog box shows the new connection you just created. Expand the connection to see the record types in the view. Select the last record type in the list and move it to the Selected Tables list.

    For example, the following illustration shows that the Contact List view and the last record type (GetContactListResponse/GetContactListResult/ContactListRecord ) is selected.
    
    

13. When you select the last record type, the Enter Values dialog box opens. Enter the parameters for the "Get" method.
14. Enter the Username and password of an employee who has access to the View selected for the report. For example, if the view selected for the report has an access level set to Executive Viewer, you would enter the user name and password of an employee who is assigned to the Executive Viewer role.
15. Click OK, select the fields for the report, and then proceed to create and save your report.

    Note: If there are too many fields in the report, you might see unusual text wrapping inside columns. If this occurs, you will need to remove some fields.

16. You can now load the report to the Employee Self Service server so that others can access and view it.