CA ERwin Data Modeler r8 New Feature Guided Tours › Reporting › Diagram Integration with Crystal Reports

Diagram Integration with Crystal Reports

Use the following steps to become familiar with diagram integration with Crystal Reports.

  1. Open one of your existing models and launch the pinned report Current Diagram Membership (Logical).rpt on the Tools, Pinned Reports menu (through CR Developer). This launches Crystal Reports Developer.
  2. Execute the report from the menu option Report, Refresh Report Data (or press F5), and observe the current diagram’s image in the report output. Close the Current Diagram Membership report (and not Crystal Reports Developer).
  3. Select the menu option File, New, Standard Report (or press Ctrl+N) to launch the Standard Report Creation Wizard. Select and double-click the CURRENT_DIAGRAM table under My Connections, ERwin_Current, Current, DGM, CURRENT_DIAGRAM to include the CURRENT_DIAGRAM in the Selected Tables list and click Finish.
  4. On the Design tab, insert a new OLE Object from the menu option Insert, OLE Object and selecting the option Object Type as Bitmap Image. Click OK and click anywhere on the report area to drop the image rectangle. Close the image editor by clicking anywhere on the report area.
  5. Right-click the OLE Object and select Format Graphic to launch the Format Editor dialog. On the Picture tab, click the Graphic Location command button to launch the Formula Workshop dialog. Select ENTIRE_MF under the ERwin_Current, CURRENT_DIAGRAM by double-clicking the same and click Save and Close (top left corner). Click OK in the Format Editor dialog.
  6. Refresh the Report (see Step 2), and note that the latest image of the current diagram is fetched in the result.
  7. Go back to CA ERwin Data Modeler and change the position of some of the entities in the current diagram. Alternatively, you can switch to a new diagram. Return to Crystal Reports Developer and click Refresh. Observe that the latest image of the current diagram is fetched and displayed in the report.
  8. Save your changes and exit Crystal Reports Developer. Close CA ERwin Report Viewer.