Summary

This article covers the different formats reports can be displayed in.

Table of Contents

Reports can be displayed in several different formats. Once the report fields and properties have been configured, you can edit the output settings to configure the format for the report.
 

Configure Output Settings

  1. Select the appropriate format type.
Note: If creating a Report Package, only the File Format types are available.
  1. Complete any additional attributes required for the output type.
     

Output Formats

The system supports three general types of formats.

Browser Window

Upon running the report, it will open within the browser in tabular format. Browser Window reports can also be displayed on the study homepage as a widget. Clicking a value in the Browser window navigates the user to the form on which the data is populated on. Formula fields will not contain a link.


File Formats

Upon writing a report to a file, the system will prompt you to either open or save the file. The file will be compressed to a zip file and be named based off the date/time stamp of generation.

Text File

The report will be written to a text file.

Additional Attributes

  • Column Delimiter: The character that separates each column name and value.
  • Column Qualifier: The character that surrounds a column name or value.
  • Line Separator: Designates how line breaks are coded in the file.

JSON File

The report will generate JSON format information. This output type is only recommended if needed for an API connection. If the report is run from within the Ad Hoc reports screen by clicking the Run button, the JSON format information will display on screen.

Excel File

The report will be written to an Excel file.

Additional Attributes

  • Max Column Width: Always leave this setting with the default value.
  • Print as Landscape: Sets the excel spreadsheet to print as landscape.
  • Use adaptive cell width: Resizes the width of the cells to fit the length of the column names.
  • Wrap cell text if necessary: resizes the height of the cells to fit the length of the column names.

SAS Export

The report will be written to a SAS file.

Additional Attributes

  • Column Delimiter: The character that separates each column name and value.
  • Column Qualifier: The character that surrounds a column name or value.
  • Line Separator: Designates how line breaks are coded in the file.
  • Expected Extraction Path: Defines the location where the file may be decompressed (unzipped).
  • SAS Library Name: Name of expected SAS library.
  • SAS Library Path: The path to the expected library.

 

Graphical Reports

Upon running the report, graphical reports will open within the browser. Graphical reports can also be displayed on the study homepage as a widget.

Bar Chart

The Bar Chart plots values against one another using bars to represent the data. The expected values are numeric with or without a column that includes data identifiers. If no record identifiers are present in the fields, a sequential number will be used to represent separate datasets.

Additional Attributes

  • Height: This height will be used to size the area where the chart will be drawn. The chart will be sized accordingly within the container. The measurement is in pixels, with approximately 100 pixels per inch on the average monitor.
  • Width: This width will be used to size the area where the chart will be drawn. The chart will be sized accordingly within the container. The measurement is in pixels with approximately 100 pixels per inch on the average monitor.
  • Chart Data Mode: Data can be presented to the chart in the following ways:
    • Row Oriented (most common): 1 Field in the report = 1 set of data on the report
    • Column Oriented: 1 Field in the report = 1 point within a set of data on the chart

Line Chart

The Line Chart plots values against one another using lines to represent the changes in the trends from one data point to the next. The expected values are numeric with or without a column that includes data identifiers (e.g. record names). If no record identifiers are present in the fields, a sequential number will be used to represent separate datasets.

Additional Attributes

  • Height: This height will be used to size the area where the chart will be drawn. The chart will be sized accordingly within the container. The measurement is in pixels, with approximately 100 pixels per inch on the average monitor.
  • Width: This width will be used to size the area where the chart will be drawn. The chart will be sized accordingly within the container. The measurement is in pixels, with approximately 100 pixels per inch on the average monitor.
  • Chart Data Mode: Data can be presented to the chart in the following ways:
    • Row Oriented (most common) – 1 Field in the report = 1 set of data on the report
    • Column Oriented – 1 Field in the report = 1 point within a set of data on the chart
  • X Axis Label: This label appears on the horizontal axis of the chart. It should be descriptive of the horizontal scale.
  • Y Axis Label: This label appears on the vertical axis of the chart. It should be descriptive of the vertical scale.
  • Line Width: This setting determines the line width in pixels. Use zero to hide all lines and show only the points.

Pie Chart

The Pie Chart produces a chart where the data is categorized and displayed like pieces of a pie. This report works with one field defined in the Fields section.

Additional Attributes

  • Height: This height will be used to size the area where the chart will be drawn. The chart will be sized accordingly within the container. The measurement is in pixels, with approximately 100 pixels per inch on the average monitor.
  • Width: This width will be used to size the area where the chart will be drawn. The chart will be sized accordingly within the container. The measurement is in pixels, with approximately 100 pixels per inch on the average monitor.

Need more help?

Please visit the Fountayn Contact Information page.