The page sets options for displaying and printing the selected Profile report.
Audience: This article is for users who configure and print Profile reports.
Display Format
Data exports enable viewing and manipulating data in external programs such as Microsoft Excel, Access, FoxPro, or other spreadsheet and database applications.
Report Format
The default display is Formatted HTML, also known as the Report Results Window.
Start Row
Start Row specifies which row of the result set is used as the first row in the report.
Per Page
Per Page specifies how many rows are returned per page in the Report Results screen.
If there are additional rows, they are accessible via a link labeled "Next XX Rows", where XX equals the Per Page value.
Max Rows
Max Rows specifies the maximum number of rows returned by the report.
The default is 10000.
The maximum may be decreased but not increased.
Export to Printable HTML
Export to Printable HTML displays the report results in a printer-friendly format with minimal graphics and formatting.
Export to Printable Excel
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
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 and can be opened or saved.
Please note that you must have the Adobe Reader or equivalent 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
Use the Data Format section to determine the output format of the data in your report.
The 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 alphabetical (non-numeric) data to UPPERCASE format for presentation in the report results.
Examples: Executive > EXECUTIVE; John Smith > JOHN SMITH.
Convert alphabetical data to lowercase
Convert all alphabetic (non-numeric) data to lowercase format for presentation in the report results.
Examples: Executive > executive; John Smith > 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 (a continuous string of alphabetic characters with no spaces) with the first letter in uppercase and the remaining letters (prior to the next space) in lowercase.
Examples: I sat in the woods reading a novel > I Sat In The Woods Reading A Novel; john smith > John Smith.
Print Settings
Print Settings determine print configurations for Printable HTML, Printable Excel, and Adobe PDF formats.
This is especially useful for reports that have many columns.
Report Width
Report Width determines paper width.
The default 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 changing the look and feel of the report.
You may choose from several popular type faces.
Shrinking the font size can be used to help you fit more data on a printed report.
Report Alignment
Align the report on the page: Left, Center, or Right.
Group Alignment
Align group headers: Left, Center, or Right.
Column Alignment
Align column values: Left, Center, or Right.
Insert extra line break after each group
Applies only to printable formats.
If selected, creates more space after a grouping no matter whether it is the first, second, or third grouping specified.
Add bold line after each group
If selected, a blank row with a bold line separates groups.
Insert page breaks after the first group
If selected, this creates separations by Group.
Especially useful in Printable Excel, since it will create each Group as a separate worksheet within the Excel workbook.
Show Gridlines around data cells
[End of content]