Reports › Use Crystal Reports With CA ERwin Data Modeler

Use Crystal Reports With CA ERwin Data Modeler

You can use Crystal Reports to query the CA ERwin DM metadata and build reports on an open model. Use this process to create a report:

• Start CA ERwin DM and open the models you want to report on. This ensures that the data source is loaded and available to Crystal Reports when you begin.
• Start Crystal Reports and identify ERwin or ERwin_Current as the current data source. You can do this when you create a Blank Report or work with the Report wizard. A user name and password are not required to access the ERwin data source - you can leave these fields blank and click Finish.

Note: If you see a "Logon failed" message, it is probably because you do not have CA ERwin DM open. When you start CA ERwin DM, it loads the data sources and makes them available to Crystal Reports.

• Build your report from ERwin schema objects. For example, work with modeling data using the M0 Schema, metadata using the M1 schema, the EM0 schema, the EM1 schema, or the AL schema.

For more information on the schemas, see the ODBC Reporting Guide, Chapter 3. For detailed information about the CA ERwin DM metadata, see the Metadata Reference Guide. Both guides are available from the Start menu, and are installed to the \Doc folder where you installed CA ERwin DM.