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.