Display Format
This page sets options for displaying and printing the selected Profile report.
Display Format determines the output format of the report.
Data exports enable viewing and manipulating data in external programs.
Examples of external programs include Microsoft Excel, Access, FoxPro, and other spreadsheet or database applications.
Report Format
- Results Window (Formatted HTML) is the default display format.
- Formatted HTML is also known as the Report Results Window.
- Start Row defines the first row to be used in the report.
- Per Page defines how many rows are returned per page.
- If there are additional rows, they are accessible via a link labeled "Next XX Rows", where "XX" is the Per Page value.
- Max Rows defines the maximum number of rows returned by the report.
- The default for Max Rows is 10000.
- Max Rows may be decreased but not increased.
- Export to Printable HTML exports the report results to 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 numerical data to the optimal format for use in Excel.
- Export to Acrobat PDF exports the Printable HTML report to PDF format.
- Adobe Reader or an equivalent application is required for this functionality.
- Export to CSV (comma separated values) delivers the report as a comma-separated text file (.csv) for importing into other software.
- Export to TSV (tab separated values) delivers the report as a tab-separated text file (.txt) for importing into many common database applications.
Data Format
The Data Format section determines the output format of the data in your report.
- Output data as stored presents all report data exactly as it is stored.
- There is no conversion.
- Convert alphabetical data to UPPERCASE converts all alphabetical (non-numeric) data to uppercase format for presentation in the report results.
- 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 converts 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; John Smith > JOHN SMITH.
Print Settings
Print Settings determine print options for reports in Printable HTML, Printable Excel and Adobe PDF formats.
- Print Settings determine print options 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, enabling you to 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 – 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 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 –
Related articles
- Mass Download of Profile Images using a Report