Field Format Settings
Feature Location: Format tabAvailability: Version 1.3+
Use the up/down arrows to specify the column display order.
Yes - the column will be displayed in the report. This is the default setting.
No - the column will NOT be displayed in the report. The entire row for the column turns gray when Display is set to No.
The list of columns (fields) returned by the data source.
Specifies a new (user-friendly) name for each column in the report.
Note: The Group By setting and the Duplicates setting will be affected if they have previously been set using a column that is later renamed. This can be corrected by specifying the appropriate setting after the column has been renamed.
Change the case for the column (field) heading. This will NOT change the case of the data in the column (see Case (data options)).
lower - change all letters to lower case
Title - Capitalize The First Letter Of Each Word
UPPER - CHANGE ALL LETTERS TO UPPER CASE
Sentence - Capitalize the first letter of each sentence.
Default - leave the case as is
This feature activate's Excel's Wrap Text setting for the specified columns. The text in those columns will display in multiple lines as necessary to fit the cell's content. Use this feature when you want to see all the data in a cell. This may expand the size of the row to display all the data (dependent on the amount of cell contents and the width of the column).
Yes - the data in the column will be wrapped.
No - the data in the column will NOT be wrapped. This is the default setting.
Note: The data will not wrap if you have checked the Summary setting until you click the Detail button.
Note: Resize columns has no effect when wrap is set.
This feature will resize the width of the column to fit the contents.
Note: Resize columns has no effect when Wrap is set.
Enter a comma separated list of columns you want bolded in this field. Data in those columns will be bolded.
Yes - the data in the column will be bolded.
No - the data in the column will NOT be bolded. This is the default setting.