Column Format Properties

Formatting options for the selected column or columns.

To apply formatting options to more than one column, press [Shift] and click on the desired columns in the layout.

To apply formatting options to all the columns in one layout section, click in the section and select Edit, then Select All.

Property	Description
Width	Column width in characters. Change the width to truncate the value.
Height	Maximum number of lines on which the column prints. When the information prints on two (or more) lines, SQR Production Reporting Studio breaks the lines at words, rather than truncating the words. For example: If line height = 1 Susan B. Anthony School for Gi If line height = 2 Susan B. Anthony School for Girls For height values greater than one, the Wrap Options enable. (See Wrap Options below).
Format	Format for the column or expression. Character Description X Prints a character. B Prints a blank space. ~ (tilde) Skips a character. R[n] Reverses the sequence of the string (for Hebrew). The optional number, n, indicates right justification within the length indicated. These are two sample formats. A caret (^) represents a printed blank space. Column Name Width Format Value Printed Value ENAME 15 bbbbxxxxxxxxxxx Smith ^^^^Smith^^^^^^ JOB 10 bbxxxxxxxx Accountant ^^Accounta
Alias	Alternate column name. For example, an alias for Store Street Address could be stor_address. To view aliases in the report layout, select View, then Column Aliases.
Wrap Options	Enabled for Height values greater than 1. Wrap options wrap text at word spaces, and additional text is moved to a new line. Convert these characters to spaces—Converts characters to spaces before wrapping. Typical usage for data with embedded line feeds is to set this option to <13>. Wrap these characters—Forces a wrap to occur at the character(s) specified. Typical usage for data with embedded line feeds is to set this option to <10>. Wrap options correspond to the STRIP and ON arguments in the WRAP command. See WRAP in Volume 2 of the Hyperion SQR Production Reporting Developer's Guide for more information.