Use this section to determine the output format of the report.
Data exports enable you to view and manipulate data in external programs such as Excel, Access, FoxPro, or other spreadsheet and database applications.
Report Format
Results Window (Formatted HTML) is the default report format.
Formatted HTML is 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 is the maximum number of rows that can be returned by the report.
The default maximum is 10000. It may be decreased but not increased.
Export to Printable HTML
The report results are displayed in a Web page using a printer-friendly format (with minimal graphics and formatting).
Export to Printable Excel
The “Formatted HTML” table is saved or opened as a file in Excel with no conversion of numerical data.
Export to Excel Spreadsheet
Numerical data is converted to the optimal format for use in Excel.
Export to Acrobat PDF
The Printable HTML report is exported to Adobe Acrobat PDF format and can be opened or saved.
Note: This feature requires Adobe Reader or an equivalent application.
Export to CSV
The report is delivered as a CSV file for importing into other software.
Export to TSV
The report is delivered as a TSV (tab separated values) file (.txt). This file format can be imported into many database applications.
Data Format
Use the Data Format section to determine 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 stored in the Certain database, with no conversion.
Convert alphabetical data to UPPERCASE
Convert alphabetical data to UPPERCASE converts all alphabetic (non-numeric) data to uppercase for presentation in the report results.
Convert alphabetical data to lowercase
Convert alphabetical data to lowercase converts all alphabetic (non-numeric) data to lowercase format for presentation in the report results.
Convert alphabetical data to Titlecase
Convert alphabetical data to Titlecase converts all alphabetic (non-numeric) data to titlecase format for presentation in the report results.
Titlecase definition: 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.
Examples: Executive > EXECUTIVE; John Smith > JOHN SMITH.
Print Settings
Print Settings allows determining 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
Report Width is used to accommodate various sizes of paper.
The default report width is 6.5".
This is equivalent to an 8.5" wide letter page with an inch margin on each side.
Larger sizes are available, enabling you to either shrink the margins on either side of the report page or use landscape orientation or legal landscape.
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 enables you to change the look and feel of the report.
You may choose from several popular type faces.
You can shrink the font size to help 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 no matter whether it is the first, second, or third grouping specified 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).