Summary

This article describes how to edit the output settings to configure the format for the report.

Table of Contents

• Configure Output Settings
• Output Formats
  • File Formats
    • Text File
      • Additional Attributes
    • Excel File
      • Additional Attributes
    • SAS Export
      • Additional Attributes

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

1. 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.

2. Complete any additional attributes required for the output type.
3. Click the ‘Next’ button to continue to the Permissions screen.

Output Formats

The system supports three types of file formats.

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

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.

Need more help?

Please visit the Fountayn Contact Information page.