Summary
This article describes how to configure the output settings for the report.
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.
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.