Intellicus Enterprise Reporting and Business Insights 19.1

Selecting Display Fields

0 views June 28, 2020 0

Under the Fields tab, you can select the fields to be displayed on the report.

Display fields
Figure 2: Selecting Display fields

To select a field, check the checkbox displayed before each field from Available Fields and click arrow button to bring the fields in Selected Fields.  To select all the fields, click  button arrow.

To select a group, check the checkbox displayed before the group and click arrow button.

To deselect a field, highlight it from Selected Fields and click arrow button.  To deselect a group, highlight the group-name from Selected Fields and click arrow button. Click arrow button to deselect all the fields.

To reposition fields on the report, you can use the up arrow and down arrow arrows.

Click the Apply button after selecting the fields.

You can quickly search a field name by entering any text in the Search textbox. The searched field appears highlighted in the shown list.

Display Field Properties
Item Values Comments
Width 0-N Number of characters of this field to show on the report. Field data may wrap beyond this width
Render As

 

 

(Default)

 

DataBar

Applies to Number Data type fields

Blank option (Default) = render numbers as numbers

DataBar = render numbers as a horizontal bar whose size is in ratio to its value

DataBar Base 0-N (in case Custom option is checked)

 

 

Avg

 

Min

Max

Custom = Choose your base number for Data bar. Rows with value equal to base value will show zero width data bar. All greater numbers will be green bars towards right and lower to base will be red bar towards left.

Avg = Average of the group becomes base of data bar. All values below average will be red bars and all values above average will be green bars

Min = Minimum of the group becomes base of data bar

Max = Maximum of the group becomes base of data bar

Rendering data bars

Rendering data bars
Figure 3: Rendering Databar

In case Update Fields At Runtime is enabled at Query Object level and you have added a new field in the database file, you would see the new field when Add New Fields At Runtime is checked here. In case this is unchecked, then you can add new fields from PowerViewer.
In case of a hyperlinked field (specified at the query object level), you can drill down to open another report or URL on clicking the value of field on grid.