Report Display Options (Profiles)

This page sets options for displaying and printing the selected Profile report.

Display Format

Use this section to determine the output format of the report.

Data exports enable viewing and manipulation of report data in external programs such as Microsoft Excel, Access, FoxPro, or other spreadsheet and database applications.

Report Format

Results Window (Formatted HTML) – By default, all reports are displayed in Formatted HTML (also known as the Report Results Window).
Start Row – Which row of the result set is to be used as the first row in the report.
Per Page – How many rows are to be returned per page in the Report Results screen. If there are additional rows in the result set, they are accessible via a link labeled "Next XX Rows", where "XX" is the Per Page value.
Max Rows – The maximum number of rows to be returned by the report. (Defaults to 10000. 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. This functionality requires the Adobe Reader or an equivalent application.
Export to CSV (comma separated values) – The report is delivered as a comma-separated text file (.csv) for importing into other software.
Export to TSV (tab separated values) – The report is delivered 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 the 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

You can determine print settings for reports in Printable HTML, Printable Excel, and Adobe PDF formats. This is especially useful for reports that have many columns.

Report Width

Use 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.
Larger sizes enable shrinking the margins on either side of the report page or using landscape orientation or legal landscape.
The report width setting applies to the output from Certain only.
Printing requires updating 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 changing the look and feel of the report.
Choosing from several popular type faces is available.
Shrinking the font size can help 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.
This applies regardless of whether the grouping is the first, second, or third grouping specified.