Edit report attributes

  1. In the left navigation pane, hover on the Data Analysis icon (Data Analysis icon), then click Report Definitions.
  2. On the Report Definitions page, accept the case series shown or click Browse to the right of Case Series to display the Select Case Series page and select a case series.
  3. Click a Report Definition's Row Action menu (Row Action menu icon), then click Edit.
  4. On the Edit Report Columns page, click the Report Attributes radio button.
  5. To disable drilldown for column variables in the report, click Generate drill-down Information, then change the value of the field to No.

    This option is not available for an all cases summary interactive report.

    Note:

    When generated, drilldown information increases the amount of memory used for report output. For large reports, this option should be set to No.
  6. To specify report restrictions, click Restrict by SQL WHERE Clause.

    Only cases that meet the criteria of the Where clause that you specify are included in the report.

  7. Type the SQL WHERE clause.
  8. To see the columns defined for the report, click Show Columns.

    Note:

    To know the list of supported SQL functions, see SQL functions.
  9. Click Apply.

Select another radio button to edit report columns or edit report descriptors. You can also save or run the report definition. For an interactive report definition, you can also define or edit a query.