CA ERwin Data Modeler r8 New Feature Guided Tours › Reporting › Mart Reporting with Crystal Reports
Mart Reporting with Crystal Reports
Use the following steps to become familiar with mart reporting with Crystal Reports.
- Connect to your mart by clicking Mart, Connection on the File menu if you are not already connected. Enter your login credentials and details of the mart database in the Connection Manager dialog, and click Connect.
- Click Model Manager Reports, Global Reports on the Tools menu and launch the Libraries Diagram Entity report. This launches CA ERwin Report Viewer.
- Enter your mart Login ID and password in the Database Login dialog and click Finish. Note that the selected report is executed and the result is displayed in the CA ERwin Report Viewer.
- Verify the result of the report against the libraries, diagrams, and entities in your mart. Make some changes to your mart hierarchy and Refresh the report to see the changes reflected in the report output.
- Click Export, Export Report on the File menu to export the report contents in an external file format. Select PDF or any other format from the Export dialog and click OK. Select ‘All’ Page Range in the Export Options dialog and click OK. Enter a file name and provide a file path and click Save. Open the PDF file created and verify the contents of the report generated.
- Switch back to CA ERwin Data Modeler and explore the other reports present in Global Reports (see step 2). Execute some more reports and observe the results.