In this section Hide
The Edit Report Columns page appears when you create or edit a report definition, or when you click Report Columns on one of the report definition pages. On this page, you specify the variables and values (from source data) to define rows and columns in the report, the labels of report columns, and the aggregation method (such as count, percentage, mean, or actual value) to be used to show values in the report.
A report can include columns from multiple tables. The application assumes that the tables can be linked by the case ID. As a result, only tables containing a case ID column are suitable for use with reports.
If you are creating a report definition, a placeholder appears for the variables that define rows and columns for the report in a tabular display:
When specifying columns and rows:
The following instructions do not include changing the labels of row and column variables or changing the aggregation method. These instructions use default labels, which are the variable names, and the default aggregation method (Value).
To define the first row variable:
1. Click {New Row Variable} to highlight it in yellow.
2. To specify the corresponding source data variable, next to Data Source, click Select.
The Edit Data Source dialog box appears.
3. Specify a data source. For more information, see Specifying a data source.
4. Click OK.
The selected variable appears as the row variable.
To define the first column variable:
1. Click {New Column Variable} to highlight it in yellow.
2. To specify the corresponding source data variable, next to Data Source, click Select.
The Edit Data Source dialog box appears.
3. Specify a data source. For more information, see Specifying a data source.
4. Click OK.
The selected variable appears as the column variable.
To add a row variable:
1. Click the name of an existing row to highlight it in yellow.
2. Click Insert Left or Insert Right.
The Edit Data Source dialog box appears.
3. Specify a data source. For more information, see Specifying a data source.
4. Click OK.
The application adds the new row variable to the report definition.
To add a column variable:
1. Click the name of an existing column variable to highlight it in yellow.
2. Click Insert Left, Insert Right, Insert Above, or Insert Below.
The Edit Data Source dialog box appears.
3. Specify a data source. For more information, see Specifying a data source.
4. Click OK.
The selected variable appears as a column variable.
Note: For a column breakdown variable, you are required to specify breakdown values. If there are 10 or fewer distinct values for the variable in the source data, the application automatically uses those values as breakdown values. You can modify them as needed. If there are more than 10 distinct values, a message informs you that breakdown details are missing and you must specify them.
1. Add rows and columns as described above.
2. To select an aggregation method for an analysis variable, highlight the variable in the cell.
3. Next to Content Details click Select.
The Contents Details dialog box appears.
4. Specify content details. For more information, see Specifying content details.
5. Click OK.
6. To select which source values for a variable will appear in the report, highlight the variable in the cell.
7. Next to Breakdown Details, click Select.
The Breakdown Details dialog box appears.
8. Specify breakdown details. For more information, see Defining breakdown details.
9. Click OK.