Reporting properties

  • Release version: Xanadu
  • Updated August 1, 2024
  • 7 minutes to read

    • Use properties to fine-tune report behavior and appearance.

    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

    Enable Natural Language Queries (NLQ) in Report Designer

    com.snc.par.nlq.report_designer.enabled
    • Type: true | false
    • Default value: true
    • Location: Reports > Administration > Properties

    Truncates x-axis labels to 20 characters. (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 the property 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

    Sets the default truncation for truncated values.

    glide.chart.data_labels.remove_leading    		 When enabled, the default truncation is left side. When disabled, the default is right side truncation.
    • Type: string
    • Default value: false
    • Location: Reports > Administration > Properties

    This property is applicable only if glide.chart.truncate.data_labels is set.

    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.
    glide.chart.drill.open_new_win If enabled, opens the default list drilldown in a new tab if no drilldown is defined. Applies only for non-list type reports.
    • 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 the 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 this property 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
    • Type: true | false
    • Default value: true
    • Location: 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_more_events_per_day Defines the maximum number of calendar events that can appear in the + <number> pop-up window 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 pop-up. For more information, see system property glide.report.calendar.max_events_displayed_per_cell.

    • Type: integer
    • Default value: 30
    • Location: Add the property to the System Property [sys_properties] table.
    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 the property 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 that 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.filter.first_day_of_week Identifies the first day of the calendar week for the company. By default, the start of the week is Monday, meaning that the calendar week begins with Monday and ends with Sunday. To change this behavior, add the property glide.ui.filter.first_day_of_week to the instance as an integer property. Enter the integer corresponding with the day of the week that the calendar begins on. 1 is Sunday, 2 is Monday, and so on. The function impacts all charts and calculations where the day of the week is used as a parameter.
    • Type: integer
    • Default value: 2
    • Location: Add a system property to the 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 the property 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 to display their labels.
    • Type: integer
    • Default value: 8
    • Location: Add the property 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.
    Note:
    This property does not apply to stacked bar chart reports.
    • 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.
    glide.report.metric_max_series Configure the number of series per data set in a MetricBase report.
    • Type: integer
    • Default value: 20
    • Maximum value: 100
    • Location: Add a system property to the System Property [sys_properties] table.
    glide.report.report_view.read_acl Configure READ-level security on report execution.
    • Type: string
    • Default value: enforce
    • Possible values:
      ignore
      No evaluation is conducted against the read ACL and all users can see the report as if they had passed the ACL.
      enforce
      Evaluation is conducted against the read ACL. Users can only view the report if they pass the read ACL.
      log
      The read ACL check is not enforced, but the administrator can see which users would have been blocked if the security check was enforced.
    • 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 check box interactive filters.
    • Type: integer
    • Default value: 25
    • Location: Reports > Administration > Properties

    Category: Choice list, Reference field, Date, Group