Display Options (Supplier Reports)

Source:

Published:

Keywords: Supplier Reports, Display Format, Data Format, Print Settings, Report Format, Export formats, Printable HTML, CSV, TSV, PDF, Excel

Document ID: https://platform-support.certain.com/hc/en-us/articles/30505994092951-Display-Options-Supplier-Reports#split1

Display Options (Supplier Reports)

Here you define a Supplier Report's display and print settings.

Display Format

Display Format is the section that determines the output format of the report. Data exports enable data viewing in external programs.

Examples of external programs include Microsoft Excel, Access, Borland FoxPro, or other spreadsheet and database applications.

Report Format

Report Format determines how report results are displayed.

By default, all reports are displayed in Formatted HTML, also known as the Report Results window.

Start Row

Start Row determines which row of the result set will be used as the first row in the report.

Per Page

Per Page determines the number of rows returned per page in the Report Results screen.

If there are additional rows in the result set they will be accessible via a link labeled "Next XX Rows," where "XX" is the Per Page value.

Max Rows

Max Rows sets the maximum number of rows that can be returned by the report.

Defaults to 10000.

May be decreased but not increased.

Export to Printable HTML

Export to Printable HTML exports the report results to a printer-friendly format.

The results are displayed as a Web page with minimal graphics and formatting.

Export to Printable Excel

Export to Printable Excel saves or opens the “Formatted HTML” table as a file in Excel.

There is no conversion of numerical data.

Export to Excel Spreadsheet

Export to Excel Spreadsheet converts numerical data to the optimal format for use in Excel.

Export to Acrobat PDF

Export to Acrobat PDF exports the Printable HTML report to Adobe Acrobat PDF format.

The PDF can be opened or saved.

You must have the Adobe Reader application for this functionality to work.

Export to CSV (comma separated values)

Export to CSV delivers the report as a comma-separated text file (.csv) for importing into other software.

Export to TSV (tab separated values)

Export to TSV delivers the report as a tab-separated text file (.txt).

This file format can be easily imported into many common database applications.

Data Format

Data Format determines the output format of the data in your report.

The available options are:

Output data as stored

Output data as stored presents all report data exactly as it is stored in the Certain database with no conversion.

Convert alphabetical data to UPPERCASE

Convert alphabetical (non-numeric) data to UPPERCASE format for presentation in the report results.

Convert alphabetical data to lowercase

Convert alphabetical (non-numeric) data to lowercase format for presentation in the report results.

Convert alphabetical data to Titlecase

Convert alphabetical (non-numeric) data to Titlecase format for presentation in the report results.

Titlecase is defined as capitalizing the first letter of each word, with the remaining letters in lowercase.

Print Settings

Print Settings determine print settings for reports in Printable HTML, Printable Excel and Adobe PDF formats.

This is especially useful for reports that incorporate a large number of columns.

Report Width

Report Width is used to accommodate various sizes of paper.

The default report width is 6.5", which is equivalent to an 8.5" wide letter page with an inch margin on each side.

Larger sizes are available, enabling you to shrink the margins on either side of the report page or use landscape orientation or legal landscape.

Note that the report width setting applies to the output from Certain only; you will still need to modify your printer settings to accommodate landscape orientation or legal paper if this is how you wish to print the report.

Font Face and Font Size

Font Face and Font Size enable you to change the look and feel of the report.

You may choose from several popular type faces.

Shrinking the font size can be used as a technique to help you fit more data on a printed report.

Report Alignment

Report Alignment determines the placement of the report on the page.

Group Alignment

Group Alignment determines the placement of any group headers.

Column Alignment

Column Alignment determines the placement of the column values.

Insert an extra line break after each group

This feature also applies only to printable formats and creates more space after a grouping, regardless of its position in the reports tab.

Add bold line after each group

When selected, this option adds a blank row with a bold line between groups.

Insert page breaks after the first group

Creates separations by Group.

This feature is especially useful in Printable Excel, since it will create each Group as a separate worksheet within the Excel workbook.

Show grid lines around data cells

Shows grid lines around all data formatted cells, except for group header rows which span all columns and have a shaded background color (as is the case in Printable HTML format).