Data Format

A data format specifies report formatting details such as the text font, text color and the background color. A data format can also specify a SQL query. Within a data format, you can reference other data formats and SQL queries.

To create a data format, enter the following information:

• Data Format Name. Enter a name for the data format.
• Report Name. When you associate this data format with a report, the system populates this field with the report name
• Query Name. Click Select and, in the Custom Query List, click the name of a query to associate it with the data format.
• Sub/Child Query. If the query you selected has a child query, the system populate this field with the name of the child query.
• Parent Data Format. If you are creating a child for another data format, click Select, and in the Data Format List, click the name of the data format to select it.
• Team. From the drop-down list, select the team that is allowed to view the data format.
• Description. Enter a brief description of the data format.
• Table Width %. From the drop-down list, select Percentage or Pixels; enter a numeric value in the adjoining field.
• Font Size. From the drop-down list, select the font size for the report text.
• Exportable (CSV File Only). Select this box to enable users to export the data format in CSV format.
• Header Text Color. From the drop-down list, select a color for the report header.
• Show Header. Select this box to display the report header in the report.
• Body Text Color. From the drop-down list, select a color for the report text.
• Combine with Previous Data Format. Select this box to specify whether to leave a space between data format tables for display purposes.
• Header Background Color. From the drop-down list, select a background color for the report header.
• Group with Previous Header. Select this box to specify whether to make column widths the same as the data format above it.
• Body Background Color. From the drop-down list, select a color for the body background.