This article sets options for displaying and printing the selected Profile report.
Display Format
Display Format determines the output format of the report. Data exports enable you to view and manipulate data in external programs such as Microsoft Excel, Access, FoxPro, or other spreadsheet and database applications.
Report Format
Report Format defines how the report results are presented. By default, reports are displayed in Formatted HTML, also known as the Report Results Window.
- Start Row is the first row used as the starting point in the report.
- Per Page is the number of rows 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 is the Per Page value.
- Max Rows is the maximum number of rows to 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 in Excel with no conversion of numerical data.
- Export to Excel Spreadsheet converts numerical data to the optimal format for use in Excel.
- Export to Acrobat PDF exports the Printable HTML report to PDF. You must have the Adobe Reader or an equivalent application for this to work.
- Export to CSV (comma separated values) delivers the report as a .csv file for importing into other software.
- Export to TSV (tab separated values) delivers the report as a .txt file. This format can be easily imported into many common database applications.
Data Format
Data Format determines how the data is presented in the report. The available options are:
- Output data as stored presents all report data exactly as stored in the Certain database, with no conversion.
- Convert alphabetical data to UPPERCASE converts all alphabetical (non-numeric) data to uppercase for presentation in the report results. Examples: Executive -> EXECUTIVE; John Smith -> JOHN SMITH.
- Convert alphabetical data to lowercase converts all alphabetical (non-numeric) data to lowercase for presentation in the report results. Examples: Executive -> executive; John Smith -> john smith.
- Convert alphabetical data to TitleCase converts all alphabetical (non-numeric) data to TitleCase format for presentation in the report results. 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 printing-related options for reports in Printable HTML, Printable Excel and Adobe PDF formats. This is especially useful for reports that have many columns.
- Report Width determines the width of the printed report. The default width is 6.5", equivalent to an 8.5" wide letter page with a 1" margin on each side. Larger sizes are available, enabling you to shrink margins or use landscape orientation.
- 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 needed.
- Font Face and Font Size enables you to change the look 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 aligns the report on the page: Left, Center, or Right.
- Group Alignment aligns group headers: Left, Center, or Right.
- Column Alignment aligns 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 shows gridlines around data.
Was this article helpful? Yes No
Related articles Mass Download of Profile Images using a Report
Comments 0 comments Please sign in to leave a comment.