Report Writer Field Properties

When a field is added to a report it is added with default values for Heading and Width.  These properties and others can be changed for each field that is added to the report.

•      Heading – This is what displays as the heading for the field when the report is ran.

•      Width – This is the number of characters in width the report will be given when it is output.

•      Justify – Controls the alignment of the field.  Possible choices are Left, Right and Center.

•      Total – Causes the report to be totaled with the chosen total type.  Possible choices are Sum, Avg, Count, Min and Max.

•      Format – Controls the formatting of the field.  The settings for this field are very similar to the settings that are accepted by Excel for formatting numbers in a spreadsheet.  For instance you can enter #,##0.00 to have numbers formatted with thousand separators and two trailing decimal places.

•      No Rep – When checked this tells the report to not duplicate data on two consecutive lines.  Instead the data is left blank.  This can be useful for increasing the readability of reports that contain the same data in a field over and over.

•      Bold – When checked this causes the field to output with a bold font (when applicable).

•      Wrap – When checked this causes the field to wrap to the next line if it cannot fit within the specified width.  If unchecked the value in the field is cut off if it is too long to fit.

•      Font Size – Controls the font size for this individual field.  This is an override setting.  If left blank the font size in place in the report writer properties is used.