Setting Column Properties

Overview

In the Report Designer, the added Data Fields appear as columns, and the corresponding data appears in each row. When the name of a Data Field is selected, the Properties for the selected field will automatically populate. The default settings for columns are in place to ensure that the Report populates with data as expected during runtime.

Data Source

This section assigns the data source for the information in the selected column. The Name references the Data Source configured in the Report, and the Field references the values for the selected Data Field. 

Settings

This section offers some general settings to configure for the column.  

Formatting

The Formatting section provides settings that change how the text in the column is displayed.

Setting Name		Description
Column Header Alignment		Aligns the column header Text/Images: Left or Right
Column Data Alignment		Aligns the column text/images data: Left, Center or Right.
Text Display Options
	NoWrap	Displays text on a single line. If the content exceeds the column width, it is visually truncated with an ellipsis (...). When editing is enabled, the cell supports single-line editing only. Line breaks and whitespace are ignored.
	Wrap	Allows text to automatically wrap to a new line when it exceeds the column width. This enables full content visibility without truncation. When editing is enabled, the cell supports multi-line editing. However, manual line breaks entered by the user will not persist after saving, text appears as wrapped but is saved as a single line.
	PreserveAllSpaces	Truncates content like NoWrap, but preserves all manual line breaks and white space within the cell during editing. Content is displayed as single-line (with ellipsis if too long), but when editing is enabled, a multi-line editor appears, showing line breaks and spacing as entered. Upon saving, all line breaks are preserved.
	PreserveAllSpacesWithWrap	Displays wrapped text in the column and also preserves all line breaks and spacing from the original data or user input. Content wraps visually, and when editing is enabled, a multi-line editor is shown. Line breaks remain visible after exiting the cell, making it ideal for notes or multi-line fields.
Format		The drop-down options will change based on the data type of the column. There is the Other option to provide custom formatting. Custom Date & Time Formatting. This setting can format dates, integers, and decimals.
Color Rules		The field will render a color depending on how the data evaluates against the Rule parameters.
View		Override the default font settings or provide a name for a custom CSS class that the column can reference.

Help

Help Messages provide tooltips that guide users during runtime. When configured, a tooltip will appear when a user hovers column header that has an associated Help Message key.

Sorting

Users have the ability to custom-sort the Report based on specific values. These values must be entered in a list format under the "Specific Values Sort". The Report will load the sorted data accordingly at runtime.

Note: If the User has a custom sort specified in a Column, they should either Turn off the Use Paging or Turn on the In-Memory Data Pagination setting from the Report Properties for the data to be sorted correctly.

Feature Changes