This article applies to the Admin Console > General > Feature/UI Settings.
The Feature/UI settings allow administrators to hide various features in the user interface. As each heading indicates, settings may apply to specific report types or the entire application.
The parameters are broken up into several sub-sections:
- Available Report Types
- ExpressView Settings
- Express Report Designer Settings pre-v2019.2
- Advanced Report Designer Settings
- Dashboard Report Designer Settings
- Common Settings
Available Report Types
These settings enable/disable report types.
The Allow Creation/Editing of Express Reports flag was removed from the Admin Console in v2019.2 of Exago but it remains available in the configuration file and the API.
Allow Creation/Editing of Express Reports pre-v2019.2
Enables/Disables the Express Report wizard.
Allow Creation/Editing of Advanced Reports
Enables/Disables the Advanced Report Wizard and Report Designer
Allow Creation/Editing of CrossTabs
Enables/disables the creation of new CrossTab reports from the main menu.
When False, the Show CrossTab Wizard setting will appear under Advanced Report Designer Settings, permitting CrossTabs to be enabled/disabled separately in the Advanced Report Designer.
Allow Creation/Editing of Dashboards
Enables/Disables the Dashboard Designer.
Both Allow Creation/Editing of Dashboards and General > Main Settings > Allow Execution in Viewer must be True to enable the Dashboard Designer.
Allow Creation/Editing of Chained Reports
Enables/Disables the Chained Report wizard.
Allow Creation/Editing of ExpressViews
Enables/Disables the ExpressView designer.
These settings only apply to the ExpressView designer.
Allow Editing ExpressView with Live Data
When True, users are allowed to make changes to an ExpressView when the in Live Data (Run) mode. When False, users must click the Stop button on the toolbar before changes may be made.
The default value is false for pre-v2021.1.1 or true for v2021.1.1+
Prior to v2021.1.1 we recommend setting this to False. Editing live ExpressViews will cause an increase in Data Source requests, and may reduce performance.
Fields Enabled in Data Fields Tree v2017.1.2+
This setting controls whether users are allowed to add fields to an ExpressView that are not directly joinable to another field on the report.
- All joinable fields (default): Users can add any fields with a join path to existing report fields.
- Direct joins only: Users can only add fields with a direct join to an existing report field.
As of v2018.1.23+, the join algorithm has been modified for ExpressViews with Direct joins only enabled. The Disable Non-Joined Data Objects database setting is now taken into consideration when generating a join path, allowing these ExpressViews to properly analyze join weight and encompass constructed SQL.
Join Path Algorithm
Select the join path algorithm to use when running ExpressViews with multiple data objects.
- Standard (default): More performant in most cases.
- Legacy: Select if you are experiencing issues with ExpressViews created in an older version.
ExpressView Tutorial v2018.2–v2020.1
Enables an instructive tutorial guide using ExpressViews to guide new users through the process of building an ExpressView report. The user can opt out during the course of the tutorial.
ExpressView Hints v2018.2–v2020.1
Enable context-sensitive hints when using different features in ExpressViews.
The Express Report Designer Settings were removed from the Admin Console in v2019.2 but they remain available in the configuration file and the API.
Express Report Designer Settings pre-v2019.2
These settings only apply to the Express Report wizard.
Show Styling Toolbar
Enables/Disables the styling tools in the Layout tab of the Express Report wizard.
Enables/Disables the Theme dropdown in the Layout tab of the Express Report wizard.
Enables/Disables the grouping tools in the Layout tab of the Express Report wizard.
Show Formula Button
Enables/Disables the formula editor button in the Layout tab of the Express Report wizard.
Advanced Report Designer Settings
These settings only apply to the Advanced Report designer.
Show CrossTab Wizard
If Allow Creation/Editing of CrossTabs in Available Report Types is False, this option becomes available. When Allow Creation/Editing of CrossTabs is True, this option is hidden from view in the Admin Console.
Set to True to allow CrossTab widgets to be added to Advanced Reports in the Designer, or False to completely disable the creation of CrossTabs in the application.
Show Chart Wizard
Enables/disables the Chart Wizard icon in the toolbar (pre-v2021.1) or from the Insert menu (v2021.1+). Set to False to disable users from creating or editing charts.
Lists the values used for default chart colors, except for heatmap charts. Hexadecimal values should be separated by commas or semicolons.
Heatmap Chart Colors v2020.1.3+
Lists the values used for default heatmap chart colors, either as CSS color names or hexadecimal color codes with a leading # sign. Values must be separated by commas or semicolons. This list of colors will be applied to a heatmap when selecting Default from the Theme dropdown in the chart wizard.
Maximum Number of Chart Data Points
Upper limit on the number of data points visible on a chart. If the limit is exceeded, a warning will be displayed to the user. Charts with large numbers of data points could cause browser performance issues.
Default Chart Font
Specifies a default font for charts created in the Advanced Report Designer. This setting can be overridden on a per-Report basis. Does not apply to ExpressView charts or Dashboard visualization tiles.
Show Geochart Map Wizard
Enables/Disables the GeoCharts icon in the toolbar (pre-v2021.1) or from the Insert menu (v2021.1+). Set to False to disable users from creating or editing GeoCharts.
The first time Show Geochart Map Wizard is set to true a dialog appears prompting you to accept the terms of using the Google Charts Api. Type “I accept” in the first box and your full name in the second to accept the terms and enable mapping.
GeoChart Map Key
Due to a change in Google’s Maps API Terms of Service, if geocharting was enabled after June 2016, or if you had geocharting enabled before, but changed your host domain name after June 2016, you need a license key to use this feature.
Geochart Map Colors
List the values used for default Geochart map colors. Hexadecimal values or CSS color names should be separated by commas (or semicolons).
Show Google Map Wizard
Enables/Disables the Google Maps icon in the toolbar (pre-v2021.1) or from the Insert menu (v2021.1+). Set to False to disable users from creating or editing Google Maps.
In order to use Google Maps, a license key must be obtained from Google, a polygon file must be downloaded from our support site and the Exago server must have an Internet connection. See Installing Optional Features for more information.
Google Map Key
Google Map Key (unlimited or JS API restricted)
License key for Google Maps permissions. Must contain either:
When upgrading from a version prior to v2018.1, the value previously supplied for the Google Map Key will appear here.
Google Map Key (optional Geocode API restricted)
Google Map Colors
List the values used for default Google map colors. Hexadecimal values or CSS color names should be separated by commas or semicolons.
Show Gauge Wizard
Enables/Disables the Gauge Wizard icon in the toolbar (pre-v2021.1) or from the Insert menu (v2021.1+). Set to False to disable users from creating or editing gauges.
List the values used for default gauge colors. Hexadecimal values or CSS color names should be separated by commas (or semicolons).
Show Document Template
Enables/Disables working with document templates. Set to False to disable users from using the Document Template menu.
Show Document Template Upload Button
Set to True to allow users to upload document template files from their local computer. Set to False to prevent users from uploading Document Templates.
Show Linked Report
Enables/Disables the Linked Report icon in the toolbar. Set to False to disable users from linking reports.
Show Linked Report Fields
Enables/Disables the Fields tab in the Linked Report dialog.
Show Linked Report Formula
Enables/Disables the Formula tab in the Linked Report dialog.
Show Linked Action
Enables/Disables the Linked Action Event icon. When True, users will be able to add Action Events to reports.
Show Auto Sum Button v2021.1+
Enable/disable the AutoSum icon in the Advanced Report Designer’s toolbar. The default value is False.
Show Insert Image
Enables/Disables the Image icon in the toolbar (pre-v2021.1) or from the Insert menu (v2021.1+). Set to False to disable users from inserting images.
Show Joins Window
Enables/Disables the Joins menu under Advanced Options. Set to False to disable users from modifying joins.
Show Advanced Joins
Enables/Disables additional options in the Joins menu. Set to True to enable advanced users to create, delete, and modify joins.
Advanced Joins Display v2017.3.1+
Select whether to show complex join options in the report Joins menu.
- Complex — allow users to modify join operators and expressions, and allow conjoining clauses.
- Standard — only permit joining data columns on equality.
Allow Category Aliasing v2017.3.1—2020.1
Allow Data Object Aliasing v2021.1+
Category renamed Data Object aliasing allows users to add categories multiple times on the same report. This may be necessary for some advanced join operations.
Show Events Window
Enables/Disables the Events item under Advanced Options. Set to True to allow users to apply Server Event Handlers in the report. See Server Events for more information.
Show Report-Level Parameters Window v2019.1.3+
Enables/Disables the Parameters item under Advanced Options. Set to True to allow users to view system-parameters and define their own report-level parameters for use within reports. See Advanced Options for more information.
Show SQL Window
Enables/Disables the Show Generated SQL menu under Advanced Options. Set to True to allow users to view the SQL that will be sent to the data sources upon execution. See Advanced Options for more information.
Show Linked Reports in New Tab pre-v2017.3
The Show Linked Reports in New Tab flag has been replaced with the Linked Report Display setting as of v2017.3.
Specify how to display Linked Reports. Set to True to open Linked Reports in a new tab. Set to False to display Linked Reports in a floating window above the parent report.
Linked Report Display v2017.3+
Specify where to display drilldowns for linked reports.
- Cursor — a popup window appears at the mouse cursor
- New Tab — the linked report opens in a new user interface tab
- Center of screen — a popup window appears at the center of the screen
Allow Grouping on Non-Sorts
Enables/disables users to create groups on non-sort formulas.
Grouping on non-sort formulas is deprecated and unsupported.
Allow Creation of Custom SQL Objects v2018.1+
Allow end-users to write custom SQL objects at the report level.
Carefully review the Report Level SQL article before enabling.
Data Sources to Exclude from Custom SQL Creation v2018.1+
When Allow Creation of Custom SQL Objects is enabled, enter the data sources to exclude from Report-Level SQL. Write each data source in double quotation marks (“), and separate sources by a comma (,). Example:
Dashboard Report Designer Settings
These settings only apply to the Dashboard designer. If Allow Creation/Editing of Dashboards is false these settings will be ignored.
Prompt user for Parameters/Filters on Execution
Default setting indicating whether to prompt the user for filter and/or parameter values when executing a dashboard. The option can be overridden on an individual dashboard in the Options menu.
Automatically Refresh Reports v2021.1+
In the Dashboard Designer, enable/disable automatically loading data into the tiles, requiring the end user to manually refresh the tile in order to see any data in it.
When True, reports and visualization tiles will automatically load data when the Dashboard Designer is first opened, and whenever changes are made to the Dashboard or the tiles on the canvas. This is the pre-v2021.1 behavior.
When False, reports and visualization tiles will display placeholder data until either the Refresh icon on the tile, or the Refresh icon on the Designer’s toolbar is explicitly clicked. If changes are made to the Dashboard or the tile, a notification icon will appear in the tile and toolbar. By limiting the frequency of calls to the Data Sources and execution engine, responsiveness of the Dashboard Designer can increase especially for very complex and data intensive Dashboards.
This functionality is referred to as the Refresh Reminder feature in the Dashboards documentation. When False, the default value, tiles do not automatically load and therefore the Refresh Reminder feature is enabled.
Show URL Item Button
Display/Hide the URL item in the New Tile Menu of the Dashboard Designer. When False, users will not be able to add URL tiles to the Dasboard canvas.
Allow Creation/Editing of Dashboard Visualizations
Display/Hide the Visualization item in the New Tile Menu and Tile Properties Pane of the Dashboard Designer.
Use Sample Data for Dashboard Visualization Design pre-v2019.2
Set to True to use sample data while creating and editing Dashboard Visualizations. This will reduce the number of calls to the database. Set to False to query the Data Source for each change made while editing Dashboard Visualizations.
Visualization Database Row Limit pre-2017.2
Maximum number of rows returned on a queries made by Data Visualizations. This only applies to Tables, Views and Functions. Set to 0 to return all rows.
Refresh Reports/Visualizations on Dashboards Silently
Set to True to disable the refresh hourglass animation for timed automatic dashboard reloads.
Minimum Tile Width for Dashboard Reflow v2019.1+
Specifies the minimum width a tile will be drawn when Dashboard Reflow is enabled. Please see the Canvas section of the Dashboard Designer article for more information.
Minimum Window Width for Dashboard Reflow v2019.1+
Specifies the minimum window size where Dashboard Reflow will begin to take effect. Please see the Canvas section of the Dashboard Designer article for more information.
Default Designer Font
Specifies a default font for reports created in the Advanced Report Wizard, Express Report Wizard, Advanced Report Designer and Dashboard Designer. This setting can be overridden on a per-report basis.
End-users must have the selected font installed locally in order to display. Otherwise, Exago will default to Sans Serif.
Default Designer Font Size
Specifies a default font size for reports created in the Advanced Report Wizard, Express Report Wizard, Advanced Report Designer, and Dashboard Designer. This setting can be overridden on a per-report basis. Does not apply to CrossTabs.
Show Help Button
Enables/Disables the Help icon in the top right corner of the user interface. Set to False to disable users from accessing the context-sensitive help system.
Custom Help Source
Specifies the URL that contains custom context-sensitive help content. See Custom Context Sensitive Help for more details.
Show Exports in Tab
Set to True to open PDF reports in an Exago tab. Set to False to prompt the user to download the PDF.
Show IE Download Button
Set to True if Internet Explorer is not automatically prompting users to download PDF, XLS, RTF or CSV export files.
Show Join Fields
Enables/Disables any Data Fields that are used as Unique Keys or Joins. Set to False to hide all unique key and join Data Fields from users. To hide specific Data Fields see Column Metadata.
Show Grid Lines in Report Viewer
Sets the default output to show grid lines or not. This can be overriden on a per-report basis.
Show Enhanced Tooltips
Sets the style of tooltips to display. If True, enhanced tooltips which support HTML will be displayed. If False, standard browser tooltips will be shown.
Save on Report Execution
Set to False to disable automatic saving of reports when executing from the Report Designer.
Save on Finish Press
Set to False to disable automatic saving of reports when finish button is pressed in a wizard.
Enable Right-Click Menus
Set to False to disable right click menus.
Enable Reports Tree Drag and Drop
Set to False to disable the dragging of reports and folders in the Report Tree.
Show Report Upload/Download Options
Set to True to enable users to upload and download report files by right clicking on folders and reports. Default value is False.
Allow interactivity in Report Viewer
Set to False to disable Interactive Report Viewer capabilities, including: changing column width, styling output, and interactive filters.
Show Toolbar in Report Viewer
Specify if Report Viewer should display paging, search, and export options.
- Auto — Exago will detect if the report only displays a single page of content from the Report Footer Section. If so the HTML Toolbar will be hidden, otherwise it will show.
- Show —the toolbar will always show.
- Hide — the toolbar will never show.
Default interactive report viewer dock is open
Set to True to have the Interactive Dock opened by default when a report is executed in the Report Viewer.
Interactive report viewer default dock placement
Specify if the Interactive Dock should appear on the left or right of the Report Viewer. The default value is is Left pre-v2021.1.5 or Right v2021.1.5+
Allow save to report design for report viewer
Set to False to prevent users from saving changes to a report made in the Report Viewer back to the original report design. This effectively removes the Save Changes To This Report and Save Changes to New Report options in the Report Viewer.
Maximum number of fields in a CrossTab header or tabulation source
Specify the maximum allowed fields in a CrossTab header or tabulation source. Note that adding a large number of data fields to a CrossTab will significantly increase the execution time of the report.
Use SVG for Application Icons v2016.3+
Set to True to se SVG icons instead of the default PNG icons in user interface elements. SVG icons look nicer on high-pixel density screens, but they may not be compatible with some web browsers.
When using a custom application theme, this setting should be set to True.
Application Theme Selection v2016.3+
Choose from a selection of available user interface themes, or choose Create New Application Theme… to create a new theme. See Application Themes for more information.
After choosing a theme, users should clear their browser cache and refresh the user interface in order for the theme change to take effect.
Update All Application Themes v2020.1.3+
Click the Update button to update all custom application themes with the newest copy of the image and CSS files available in the Basic theme. It is recommended to click this button after updating Exago from one major version to another (e.g. v2020.1–v2021.1).
Depending on the number of the themes available and the number of changes made between versions, this operation may take a minute or so to complete.
The context-sensitive help will not be affected by the theme selection.
Show Data Fields Search Box v2017.2+
Data Fields Search Mode
Enables/Disables the data field search tools in the Data Fields Pane of the ExpressView, Advanced Report and Dashboard Designers.
- Disabled — there is no search box
- As You Type — search results display as the user types
- On Submit — search results display after hitting the Enter key
We highly recommend setting Column Metadata, and setting Schema Access Type to Metadata for all available objects, before enabling this feature.