Summary
This article describes the different formats reports can be displayed or rendered in.
Table of Contents
Reports can be displayed or rendered 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
- Using the Output Formats section as a guide, select the appropriate format type.
Note: If creating a Report Package, only the File Format types are available.
- Complete any additional attributes required for the output type.
- Click the ‘Next’ button to continue to the Permissions screen.
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.
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.
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
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.
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. See the Graphical Reporting page for additional information related to graphical configurations and sample reports.
Need more help?
Please visit the Fountayn Contact Information page.