Reports › The Data Browser › Create a Report

Create a Report

You can use the Options tab in the Report Editor to specify the information you want to include in a report. The options you select become columns in a result set generated by the report. A pencil icon next to an option indicates that the corresponding column in the generated result set is editable.

To create a report

1. Click Data Browser on the Standard toolbar.

   The Data Browser opens.

2. Click New report or folder on the toolbar.

   The New Object dialog opens.

3. Double-click on the report item.

   The Reports dialog opens.

4. Select the following options:

   Name

   Displays the name of the report.

   Category

   Displays type of report you want to generate. The options in the list change based on whether you click Logical or Physical.

   Logical

   Filters the Category list to show only those reports available for the logical model.

   Physical

   Filters the Category list to show only those reports available for the physical model.

   Option tab

   Edit

   Displays all report options in the Options list.

   Show Selected Only

   Displays only the currently selected report options in the Options list.

   Show Selected

   Expands only folders in the Options list that contain selected items. Unselected items in these folders are also shown.

   Collapse All

   Closes all open folders except the first folder.

   Clear All

   Clears all previously selected options.

   Options

   Displays the information you can include in a report. The options available depend on the report type selected in the Category list. Expand or collapse each folder to select three possible types of options:

   Check box options

   Select the check box next to an option to include that information in the report. A pencil icon next to an option indicates that the corresponding column in the generated result set will be editable.

   Filter options

   Click the plus sign next to a Filter By folder to view the filtering options. Click one or more of the filter buttons to include only rows in the report that satisfy the filter options you select.

   Sort By options

   Click the plus sign next to a Sort By folder to view the sorting options. Click on one of the Sort By buttons to sort the report rows using the option you select.

   Definition tab

   Displays a definition for the report.

   Note tab

   Displays a note for the report.

5. Click OK.

   The report is added to the tree control in the main Data Browser window.

6. Click Execute report.

   The report is run against the active model.