How to Generate or View Reports › Generate Custom Reports › Use Crystal Reports

Use Crystal Reports

CA ERwin DM includes Crystal Reports 2008 and SAP Crystal Reports 2011. Choose the version that you want to install and install it. Query ERwin ODBC through Crystal Reports. In addition generate reports and format it per the branding guidelines of your organization using Crystal Reports.

Note: For more information about the schema you can query, see Schemas under Appendix. For a list of useful queries, see Useful Queries under Appendix.

Using Crystal Reports 2008

Follow these steps:

1. Open a model in CA ERwin DM, or connect to Mart and open a model.
2. Click Tools, Crystal Reports Developer.

   Crystal Reports 2008 opens and the Start Page appears.

3. Click Report Wizard and select ERwin_r9_Current under My Connections.
4. If ERwin_r9_Current is not available under My Connections, follow these steps:
   1. In the Available Data Sources pane, expand Create a New Connection.
   2. Click ODBC (RDO) and select ERwin_r9_Current in the Data Source Selection pop-up window.
5. Expand Current, the appropriate schema, and then select the table that you want to include in the report.
6. Follow the wizard and complete the report.

Using SAP Crystal Reports 2011

Follow these steps:

1. To generate an ERwin report, follow these steps:
   1. Open a model and click Tools, Crystal Reports Developer.

      SAP Crystal Reports 2011 opens and the Start Page appears.

   2. Click Report Wizard and select ERwin_r9_Current under My Connections.
   3. If ERwin_r9_Current is not available under My Connections, follow these steps:
   4. In the Available Data Sources pane, expand Create a New Connection.
   5. Click ODBC (RDO) and select ERwin_r9_Current in the Data Source Selection pop-up window.
   6. Expand Current, the appropriate schema, and then select the table that you want to include in the report.
   7. Follow the wizard and complete the report.
2. To generate a Mart report, follow these steps:
   1. From Windows Start Menu, click All Programs, Crystal Reports 2011, Crystal Reports 2011.
   2. Click File, Open, and browse to the following folder:

      C:\Documents and Settings\Administrator\Local Settings\Application Data\CA\ERwin Data Modeler\9.0\Mart Reports\Global Reports.
      

   3. Open the report that you want to generate and click OK on the message.

      The report opens.

   4. Click Database, Set Data Source Locations and the Set Datasource Location dialog opens.
   5. Click Update and the XML and Web Services dialog opens.
   6. Change the Change HTTP(S) XML URL from

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

      to

      http://ServerName:Port/ApplicationName/service/report/generateReport/Libraries/User/Password
      

      Server name

      Specifies the name of the database server. This is the computer where the Mart database is installed.

      Port

      Specifies the port number of the database server.

      Application Name

      Specifies the application name with which the Web Server is identified.

      Default: MartServer

      User

      Specifies the user name with which you connect to the Mart database.

      Password

      Specifies the password with which you connect to the Mart database.

   7. Click Next till the Schema file type and location dialog appears.
   8. Change HTTP(S) XML URL from

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

      to

      http://ServerName:Port/ApplicationName/service/report/ generateSchema/Libraries /User/Password
      

   9. Click Finish.
   10. Press F5 and the report appears.

Back to Top