What's New › New Reporting Tool--Report Designer

New Reporting Tool--Report Designer

A new reporting tool--Report Designer is included in this release. This tool lets you generate a wide variety of reports and on the current data available in your data models. You can create report templates for frequently used reports and you can save multiple reports under a Report Solution.

You can generate the following types of reports:

• Logical: This report includes the objects from a Logical only model
• Physical: This report includes the objects from a Physical only model
• Logical/Physical: This report includes the objects from a Logical/Physical model

Several sample reports are included with the application and they are available in the following location:

%Installdir%\ CA\ERwin Data Modeler r9\BackupFiles\Report Solutions 

Also at the following location:

Windows XP

C:\Documents and Settings\All users\Application Data\CA\ERwin Data Modeler\9.5\Configuration\Report Solutions\

Windows 7

C:\ProgramData\CA\ERwin Data Modeler\9.5\Configuration\Report Solutions\

Note: The sample reports are created using a Logical-Physical model. If you use the sample reports with a Logical-only or a Physical-only model, it may result in inappropriate results.

Report Designer includes the Filter By option that lets you generate drill-down reports. Some of the drill-down reports that you can generate are as follows:

Entity/Table level reports

• Entities and tables in the current Subject Area
• Entities and tables that are selected in the current diagram

Attribute/Column level reports

• Migrated attributes and columns
• Owned attributes and columns
• Role-named attributes and columns
• Foreign (FK) Key groups and indexes
• Generated indexes
• Nonunique (IE) Key groups and indexes
• Primary (PK) Key groups and indexes
• Unique (AK) Key groups and indexes

Subject Area reports:

• All entities and tables in the current subject area
• Members of the current diagram
• Members of all the diagrams in the current Subject Area
• Members of all the diagrams in the Main Subject Area, that is, the members of all diagrams at the model level
• Members of the diagrams that are specified at run time

You can use the Graphical Member option for diagrams and can view the images of diagrams.

The filters for Entity/Table and Key Group/Index are available when you select the members of a diagram or a Subject Area.

Attributes and columns can be displayed the following order:

• Alphabetic
• Attribute (the order in which attributes appear on the logical model)
• Column (the order in which columns appear on the physical model)
• Physical (the order in which columns appear in the DDL after Forward Engineering)
• Reverse Alphabetic

Note: For more information about generating reports using Report Designer, see the How to Generate or View Reports scenario. To access this scenario, open the ERwin Bookshelf, navigate to the Product Documentation - By User Role section, and then click Data Architect.

Report Designer Features

Report Designer includes the following features:

Report Explorer Features

Move child nodes: To move the child nodes up or down within a parent node, right-click the node and click Move Up or Move Down. This option is to move child nodes within a parent node and not to move parent nodes in a report.

Result Grid Features

• Drag-and-drop: To change the order of columns, drag-and-drop the report node to the desired position in the Report Explorer pane. Select the report template and click Run current report on the toolbar.
• Sort: To sort the report results on a specific column, click the column header. The default sort order is the order in which you have created the objects in the model.
• Hide a column: To hide a column, click the column header and drag it away from the report until you see the cross mark. To display a hidden column, right-click a column header, click Columns, and then select the column that you want to display.

  Note: Hidden columns are included when you export a report to CSV or HTML.

• Group the report result by a column: To group the report result by a column, click the column header and drag it to the Drag a column header here to group by that column section. The following illustration shows a report that is grouped by two columns:

  

• Rename a column: To rename a column, right-click the corresponding node in the Report Explorer and click Properties. Enter a new name in the Node Name field and click OK. Select the report template and click Run current report on the toolbar.
• Configure the look and feel of each column: To configure the look and feel of each column, right-click the corresponding node in the Report Explorer and click Properties. Complete the fields in the Customize report style section. Be aware that the styles applied to a parent node are not applied to child nodes automatically.
• Clear grid: To clear the data displayed in the result grid, click View, Clear gird. Clearing the result grid is a best practice when exporting a large or a complex report to HTML.
• Export to HTML, CSV and TXT: To export a report or a Report Solution, right-click it and click Export to HTML or Export to CSV. When you export a report to CSV, select the delimiter as Comma Delimited to view the report in CSV format.