Step 4: Specify a data source in a report

In a report definition, the data source of a column variable or row variable is the name of the source database variable from which data will be retrieved for the report. You also specify the label that will identify the variable in the report.

Note:

If a row variable's underlying column has the same name as any column in an analysis variable's table, then a SQL inner join of the same-named columns occurs in addition to the usual join on report ID.

1. In the left navigation pane, hover on the 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 (), then click Edit.
4. On the Edit Report Columns page, next to Data Source, click Select.
5. On the Edit Data Source page, in the Table field, select the name of the database table that contains the variable that you want to use, or select All Tables.

   Note:

   If you want to look at all cases, use the report ID (that is, the variable of the Report ID type in the configuration) in the demographics table. It is possible that a report has no record in the other tables. If you are not interested in getting all report IDs, but only those that have records in the table from which you are getting other data, use the report ID from that table.
6. Select a variable.
7. When you highlight a variable in the list, the Label field shows the variable name by default. You can type in a different label, which appears in the report as the column heading for the variable.

   For example, suppose that you use default labels for the ISR_drug and Generic_Name variables. The column headings in the report look like this:

   

   For clarity, you could modify them as follows:

   
8. To change the label, select the default label and change it.
9. Click OK.
10. If you chose a numeric value, you can click View Column Statistics to display a histogram showing the distribution of values for the variable in the source data.