Introduction › Generate Reports using Crystal Reports

Generate Reports using Crystal Reports

This section describes how to generate reports using Crystal Reports.

Before attempting to generate a report, help ensure that at a minimum you have the View permissions on the Mart on which you want to report.

Follow these steps:

1. Start the web server where you have installed Mart Server, for example, start Tomcat.
2. Use the Crystal Reports Report Wizard and create a connection that uses XML and Web Services as the data source.
3. Use the HTTP(S) Data Source.
4. Follow the Report Wizard steps.
5. Use the following format to enter the URL for HTTP(S) XML URL:

   http://<Server Name>:<Port No>/MartServer/service/report/generateReport/<Report Name>/<Username>/<Password>
   

   For example:

   http://localhost:8084/MartServer/service/report/generateReport/Users/sa/erwin
   

6. Use the following format to enter the URL for HTTP(S) Schema:

   For example:

   http://<Server Name>:<Port No>/MartServer/service/report/generateSchema/<Schema Name>/<Username>/<Password>
   

   For example:

   http://localhost:8084/MartServer/service/report/generateSchema/Users/sa/erwin
   

   The URL details are as follows:

   • <Server Name>: Machine name where Mart Server is running.
   • <Port No>: Port number on which J2EE container is running.
   • <Report Name>: Name of the report which being created.
   • <Schema Name>: Name of the report schema which is being created.
   • <Username>: Username for a server user in Mart Server.
   • <Password>: Password for a server user in Mart Server.

   Enter the report URL and schema URL in the browser Address bar to see the correct data. If the username and/or password is incorrect or if you do not have the required authorization to View Reports on the Mart Server, the message, Logon Failed appears.

7. After the new connection is successfully created, expand it.
8. Select the tables for which you want to generate a report and create the report.