Create Report from Table

The Create Report from Table tool allows any element that can be exported to "Tab delimited text" to be turned into a report with a single table.

Many element types are accepted as input, including:

Note that tables with many rows will create very long reports. Consider filtering tables first using tools such as Filter on Custom Criteria, Filter Based on Overlap, Filter Against Known Variants, etc. Tables can also be filtered manually when in a table view, see

To run Create Report from Table, go to:

        Toolbox | Utility Tools (Image utilities_closed_16_n_p) | Reports (Image reporttools_folder_closed_16_n_p) | Create Report from Table (Image table_report_16_n_p)

After selecting the input element, the columns to include in the report must be defined. Column definitions consist of four parts:

Image createreportfromtabledialog
Figure 19.1: Define the columns to be included in the report.

To make defining columns easier, the Load Attributes button can be used to populate a dropdown list of the columns found in the element selected in the Template element field (figure 19.1). By default, the tool's input is preselected. Use the browse (Image browse) button to select a different element.

If a template element is not used for populating a dropdown list, columns can be entered by typing directly in the Column field.

The Add button adds additional columns while pressing the X (Image close_x_red_16_n_p) button to the right of a column removes it. It is possible to reorder columns using the Up and Down buttons. The Clear button removes all defined columns.

If a column is defined that is not present in the input element, then an empty column with that name will be placed in the report.

Sample and combined reports

The report from this tool can be used in Create Sample Report. The name of the section in the sample report can be customized by running the Modify Report Type tool ( prior to running Create Sample Report.

Report sections from this tool cannot be used in Combine Reports, because the contents of the tables may be specific to each sample (an example would be variants found in each sample, where one of the selected table columns is the allele frequency).