Reporting properties

Use properties to fine-tune report behavior and appearance.

Introduction

Navigate to Reports > Administration > Properties to configure the main reporting properties. In the Filter navigator, enter sys_properties.list to configure other reporting properties.

Reporting properties

Property Description

Use new report designer.

glide.ui.report.new_report_designer
Enable the use of the report designer.
  • Type: true | false
  • Default value: true
  • Location: Reports > Administration > Properties

Truncates x-axis labels to 20 characters, if selected (Applicable only to charts generated with the charting v2 plugin)

glide.chart.truncate.x_axis_labels
  • Type: true | false
  • Default value: true
  • Location: Reports > Administration > Properties
glide.ui.chart.bar.horiz.max_col_slant_labels Sets the maximum number of columns in a horizontal bar chart before slanting (angling) the labels.
  • Type: integer
  • Default value: 5
  • Location: add to the System Property [sys_properties] table

Toggle animations on and off for charts generated with the charting v2 plugin

glide.chart.animation
Enables animations for reports and Performance Analytics visualizations that support animations.
Note: Map reports do not support animations and therefore do not follow this property.
  • Type: true | false
  • Default value: true
  • Location: Reports > Administration > Properties

Truncates data labels from the front of the label.

glide.chart.data_labels.remove_leading
This property is applicable only if glide.chart.truncate.data_labels is set.
  • Type: string
  • Default value: false
  • Location: Reports > Administration > Properties

Number of bins in a histogram chart (minimum 1, maximum 20)

glide.chart.histogram.bins
Determines the number of sections that appear on the Y axis of the histogram.
  • Type: integer
  • Default value: 10 (Allowed range of values 1–20)
  • Location: Reports > Administration > Properties

This property applies to histogram reports.

Color of the mean value dot in box and trendbox charts.

glide.chart.box.mean.color
Sets the color of the 'mean' value dot in a box or trendbox report.
  • Type: string
  • Default value: #2f7ed8
  • Location: Reports > Administration > Properties

This property applies to box and trendbox reports.

Opens drill down information or a list in a new window or tab when user clicks a chart item

glide.chart.drill.open_new_win
When enabled:
  • For reports that have a drill down defined, each clicked drill down report opens in a new window or tab.
  • For reports that do not have a drill down defined, when a chart item is clicked, this opens a list in a new window or tab.

When set to false, opens a new page.

  • Type: true | false
  • Default value: false
  • Location: Reports > Administration > Properties

Color of the box and whisker in box charts

glide.chart.box.color
Sets the color of the box report.
  • Type: string
  • Default value: #FF0000
  • Location: Reports > Administration > Properties

This property applies to box reports.

Default Color list name for each dataset

glide.ui.report.datasets.default_colors
Sets the default colors to use when adding multiple data sets to a single chart. These values are used when the Chart color value is Use one color.

Enter a comma-separated list of chart color Color name values. You can view available colors and define new colors on the Chart Colors [sys_report_chart_color] table.

Each color is used in order as the default chart color when adding a data set to a chart. If there are more data sets than default colors, the colors repeat.

  • Type: string
  • Default value: Default Color
  • Location: Reports > Administration > Properties

List of color palette names that are used as a default color palette for each dataset

glide.ui.report.datasets.default_palettes
Sets the default palette to use when adding multiple data sets to a single chart. These values are used when the Chart color value is Use color palette.

Enter a comma-separated list of chart color scheme Name values. You can view available palettes and define new palettes on the Chart Color Schemes [pa_chart_color_schemes] table.

Each palette is used in order as the default chart palette when adding a data set to a chart. If there are more data sets than default palettes, the palettes repeat.

  • Type: string
  • Default value: Default UI14
  • Location: Reports > Administration > Properties

This property applies to pie, bar, horizontal bar, donut, and semi-donut reports.

Set the default map for reports of type 'Map'

glide.ui.report.map.default_map
Specifies the default map to use when creating Map-type reports.
  • Type: string
  • Default value: world
  • Location: Reports > Administration > Properties

This property applies to Map reports.

glide.ui.chart.color Specify the chart color.
  • Type: string
  • Default value: #006DDA
  • Location: Add a system property to the System Property [sys_properties] table
glide.ui.chart.use_full_color_palette Enable to generate bars in bar and Pareto charts with different colors for each bar.
  • Type: true | false
  • Default value: #false
  • Location: Reports > Administration > Properties

This property applies to bar, horizontal bar, and Pareto reports.

glide.chart.label.legend.truncate_to Truncates legend labels for left or right legend alignment for all chart sizes except large charts. Prevents shrinking of charts when labels are too long.
  • Type: integer
  • Default value: 14
  • Location: System Property [sys_properties] table
glide.chart.label.legend.truncate_to.large Truncates legend labels for left or right legend alignment for large charts. Prevents shrinking of charts when labels are too long.
  • Type: integer
  • Default value: 20
  • Location: System Property [sys_properties] table
glide.report.new_calendar Enables (true) or disables (false) new calendar reports. Internet Explorer 7 and 8 do not support new calendars. If you open a calendar report in one of these browsers the old version of calendar reports is always used.
  • Type: true | false
  • Default value: true
  • Location: add to the system Property [sys_properties] table
glide.report.calendar.max_days_back Enables you to specify the number of days with events that are returned when you browse backward and forward in a calendar report. Evaluated on the Calendar by field in the report creator.
  • Type: integer
  • Default value: 30
  • Location: Add a system property to the System Property [sys_properties] table

This property applies to calendar reports.

glide.report.calendar.default_event_duration The default duration for an event without a specified end date.
  • Type: string
  • Default value: 01:00:00 (One hour, zero minutes, zero seconds)
  • Location: System Property [sys_properties] table

This property applies to calendar reports.

glide.report.calendar.max_events_displayed_per_cell Defines the maximum number of events that can appear in calendar report for:
  • A calendar day when calendar is in month or year view
  • The top 'full day' section of a calendar day when a calendar is in day or week view

Events that exceed this value are visible via a link in the calendar cell. See glide.report.calendar.max_more_events_per_day for more information.

  • Type: integer
  • Default value: 3
  • Location: add to the System Property [sys_properties] table
glide.report.calendar.max_more_events_per_day Defines that maximum number of calendar events that can appear in the + <number> popup for:
  • A calendar day when calendar is in month or year view
  • The top 'full day' section of a calendar day when a calendar is in day or week view

When this number is exceeded, a + many link appears, which opens a list of events instead of a popup. For more information about the maximum number of events that can be displayed in a calendar day, see system property glide.report.calendar.max_events_displayed_per_cell.

  • Type: integer
  • Default value: 30
  • Location: add to the System Property [sys_properties] table
glide.ui.report.extend_calendar_choices Controls which field styles are applied during calendar highlighting. If this property is set to false, field styles in only the Task table are used. If this property is set to true, the calendar first uses field styles from the table the report is based on. If no applicable styles exist in that table, the calendar uses field styles from the Task table.
  • Type: true | false
  • Default value: true
  • Location: System Property [sys_properties] table
glide.ui.chart.bar.horiz.max_col_slant_labels Sets the maximum number of columns in a horizontal bar chart before slanting (angling) the labels.
  • Type: integer
  • Default value: 5
  • Location: Add a system property to the System Property [sys_properties] table

This property applies to horizontal bar reports.

glide.ui.chart.pie.labels Enables (true) or disables (false) labels on pie chart slices.
  • Type: true | false
  • Default value: true
  • Location: add to the System Property [sys_properties] table
glide.ui.chart.pie.labels.max_items Sets the maximum number of pie chart slice values that can be returned in order to display their labels.
  • Type: integer
  • Default value: 8
  • Location: add to the System Property [sys_properties] table
glide.chart.data.label.truncate_to

Sets the maximum length of a data label for a chart. If longer, the label is truncated and an ellipsis (…) appended.

  • Type: integer
  • Default value: 13
  • Location: System Property [sys_properties] table
glide.report.pivot.fixed_headers

When disabled, the header row of a multiple level pivot table is unfrozen and scrolls out of frame when the user scrolls through the table.

  • Type: true | false
  • Default value: true
  • Location: Add a system property to the System Property [sys_properties] table

This property applies to multilevel pivot tables.

glide.report.metric_max_data_points Configure the maximum number of data points per MetricBase report. Typically only MetricBase time series reports display enough data to require this limitation.
  • Type: integer
  • Default value: 2000
  • Location: Add a system property to the System Property [sys_properties] table

Interactive Filters properties

Property Description
glide.homepage_interactivity.ui_ctrls_max_display_options Maximum number of choices for radio button and checkbox interactive filters.
  • Type: integer
  • Default value: 25
  • Location: Reports > Administration > Properties

Category: Choice list, Reference field, Date, Group