Edit Column Alignment Options

You can change the way text displays in report columns.

1. Right-click the header of the column you want to modify and select Edit Format.
   The Column Format window opens.
2. Click the Alignment tab.
3. Enter field information.

   Alignment Tab

   Field	Description
   Header	The fields in this section determine the alignment for the column’s header.
   Text Alignment	Click this drop-down list to select the column header’s horizontal alignment. Options include Left, Center, and Right.
   Line Alignment	Click this drop-down list to select the column header’s vertical alignment. Options include Bottom, Center, and Top.
   Wrap Text	Select this check box to allow the column header’s text to wrap to a new line if it exceeds the width of the column.
   Data	The fields in this section determine the alignment for the column’s data.
   Text Alignment	Click this drop-down list to select the horizontal alignment for the column’s data. Options include Left, Center, and Right.
   Line Alignment	Click this drop-down list to select the vertical alignment for the column’s data. Options include Bottom, Center, and Top.
   Wrap Text	Select this check box to allow the column’s data to wrap to a new line if it exceeds the width of the column.
   Limit Wrapped Text to x Rows	If the Wrap Text check box is selected, enter the maximum number of wrapped rows that should be shown in the report output. You can enter a value between 1 and 100.
   Repeating Values	The fields in this section let you hide repeating values in the column.
   Hide Repeating Values	Select this check box to hide repeating values in the column. The value will display in the first row with value, but subsequent rows with the same value will be blank. Selecting this option can make a report’s output more legible by hiding repetitive text in a column.
   Exclude Hidden Values from Calculations and Auto-Filtering	Select this check box to exclude hidden values from consideration in column calculations and column auto-filter options.