Edit 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 will be editable.

Important: When the report is run from the Entity/Table level asking for attribute/column names, and if some of the attributes/columns are marked as logical or physical only, or even if there is a difference between the number of displayed attributes and columns because of any transform, the report shows the displayed attributes and columns but the attributes and columns will not necessarily correspond to each other in the same line. This gives the appearance of mismatched attributes and columns, but the report is behaving as expected. If you want to see which attribute matches which column, then you need to run the report at the Attribute/Column level.

To edit a report

  1. Click Data Browser on the Standard toolbar.

    The Data Browser opens.

  2. Expand the folder that contains the report you want to edit, select the report you want to edit, and click Edit properties on the tree control toolbar.

    The Report Editor opens.

  3. Edit the reporting options from tree control:
    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

    Edits the definition for the report.

    Note

    Edits the note for the report.

    Click OK.

    The report is updated.

  4. Click Execute report.

    The report is run against the active model.