This page sets various options for report display and print settings.
Video: Video: Display Format (2 min)
Display Format
This section determines the output format of the report.
Data exports enable you to view data in external programs such as Excel, Access, or other spreadsheet and database applications.
Data exports enable you to manipulate data in external programs such as Excel, Access, or other spreadsheet and 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 alphabetic (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 those reports that incorporate a large number of 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 either 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 – 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 as a technique to help you fit more data on a printed report.
- Report Alignment – Determines the placement of the report on the page.
- Group Alignment – Determines the placement of any group headers.
- 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).
Was this article helpful? 0 out of 0 found this helpful
Have more questions? Submit a request