This article describes a Supplier Report's display and print settings within the Certain platform. It is intended for suppliers who use the Certain platform to generate and customize reports.
Display Format
- Results Window (Formatted HTML) is the default display for all reports.
- Formatted HTML is also known as the Report Results window.
- Start Row determines which row of the result set will be used as the first row in the report.
- 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 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 displays the report results in a printer-friendly web page.
- Export to Printable Excel saves or opens the Formatted HTML table as an Excel file with no conversion of numerical data.
- Export to Excel Spreadsheet converts data to the optimal format for use in Excel.
- Export to Acrobat PDF exports the Printable HTML report to PDF format.
- Adobe Reader is required for this functionality to work.
- Export to CSV (comma separated values) delivers the report as a comma-separated text file (.csv).
- Export to TSV (tab separated values) 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 the report.
- Available options are:
- Output data as stored.
- All report data is presented exactly as it is stored in the Certain database with no conversion.
- Convert alphabetical data to UPPERCASE.
- Convert all alphabetic (non-numeric) data to UPPERCASE format for presentation in the report results.
- Examples: Executive becomes EXECUTIVE; John Smith becomes JOHN SMITH.
- Convert alphabetical data to lowercase.
- All alphabetic (non-numeric) data is converted to lowercase format for presentation in the report results.
- Examples: Executive becomes executive; John Smith becomes john smith.
- Convert alphabetical data to Titlecase.
- Convert all alphabetic (non-numeric) data to titlecase format for presentation in the report results.
- Titlecase is defined as the writing of a word with the first letter in uppercase and the remaining letters in lowercase.
- Examples: I sat in the woods reading a novel becomes I Sat In The Woods Reading A Novel; john smith becomes John Smith.
- Titlecase is defined as the writing of a word (a continuous string of alphabetic characters with no spaces) with the first letter in uppercase and the remaining letters in lowercase.
Print Settings
You can determine print settings for reports in Printable HTML, Printable Excel and Adobe PDF formats. This is especially useful for those reports that incorporate a large number of columns.
- Report Width determines the paper width for the report.
- 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.
- Larger sizes enable 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 enables 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 determines the placement of the report on the page.
- Group Alignment determines the placement of any group headers.
- Column Alignment determines the placement of the column values.
- Insert an extra line break after each group applies only to printable formats.
- This feature creates more space after a grouping, regardless of its order in the Reports tab.
- Add bold line after each group 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 because 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.
- Group header rows span all columns and have a shaded background color in Printable HTML format.