Exago Logo
Search
Generic filters
Exact matches only

Advanced Reports: Using the Toolbar (pre-v2021.1)

The toolbar contains the buttons and menus used to modify the report. Modifications can include aesthetic formatting, inserting formulas and images, linking reports, and much more.

Your system administrator has the ability to hide or show specific menu options and toolbar items. Some items may not be available to you.

firefox_t5ON8UbnFX.png
Advanced Report Designer toolbar in v2019.2+

For application versions pre-v2019.2:

Advanced Report Designer toolbar
Advanced Report Designer toolbar

pre-v2019.2

The toolbar begins with the Settings dropdown menu sometimes referred to as the cog wheel menu. This menu controls changes, such as renaming and filtering, that affect the entire report. All other buttons on the toolbar require that a cell (or cells) in the design grid be selected.

Settings menu
Settings menu
  • Rename.png Rename: Allows you to change the name and folder where the report will be saved.Enter a new name for the report, or choose a different folder. The name must be unique.
  • Description.png Description: Allows you to enter or change the description of the report or formula description (if enabled).
  • Categories.png Categories: Allows you to change the Categories which are included on the report. The article on Categories has more information.
  • SortsMenu.png Sorts: Allows you to change the Sorts on the report. The article on Sorts has more information.
  • Filter.png Filters: Allows you to change the Filters on the report. The article on Filters has more information.
  • Template.png Template: Allows you to setup document templates and forms. The article on Templates has more information.
  • Options: Allows you to change behavior of the report. The article on Options has detailed information about each option.

    • Options.png General: Allows you to change things such as report export types, filter execution windows and page formatting. Review the General Options article for full details.
    • ConnectionStringVisible.png Report Viewer: Allows you to change things such showing the report grid, the toolbar and interactive filters and sorts in the report viewer. Review the Report Options article for full details.
    • ExecutionCacheOptions.png Execution Caching: Allows you to setup Execution Caching options for this report. This is an advanced feature, contact your system administrator for assistance with it.
    • CustomOptions.png Custom: Allows you to set any Custom Options on the report. This is an advanced feature, contact your system administrator for assistance with it.
  • Advanced: Allows you to change advanced properties of the report.

    • Join.png Joins: Allows you to define how categories on a report are related to one another. The article on Joins has more information.
    • TreeParameter.png Parameters: Allows you to define reusable system variables, called Parameters, on the report. The article on Report Level Parameters has more information.
    • ExecutionCacheOptions.png Show Generated SQL: Allows you to view the generated SQL query which retrieves the data used on the report. The article on Show Generated SQL has more information.

Saving Reports

The report can be saved by clicking the Save floppy disk icon. Depending on system configuration, the report may also be saved when it is executed.

Undo/Redo

Any action on a report can be undone by clicking on the Undo Undo.png icon or pressing Ctrl + Z on the keyboard.

Undone actions can be redone by clicking Redo Redo.png icon or pressing Ctrl + Y on the keyboard.

Font & Alignment Options

The text of each cell can be formatted using dropdown menus and buttons in the toolbar. A cell or multiple cells must be selected for these tools to be used.

Font options

For application versions pre-v2019.2:

Font options

Font

  • To change the font, use the searchable dropdown menu. The font names appear in the style that they represent.
  • Text size can be controlled using the up and down arrows on font size spinner.
  • The Bold B, ItalicsI and UnderlineU icons make the selected font bold, italicized, and underlined, respectively. Clicking the icon will turn it slightly gray to indicate the function is turned on.

Color

  • To change the text color, click the Foreground Color A icon to show the foreground color selector. Select a color or enter an RGB value. Hexadecimal HTML color codes may be added in the Hex textbox, or decimal values may be entered into each of the R, G and B textboxes ranging from 0–255. Click the Reset struck droplet button to revert to the default color. A preview of the active foreground color appears below the Foreground Color icon.
  • To change the cell background color, click the Background Color paint can icon to show the background color selector. Select a color or enter an RGB value. Hexadecimal HTML color codes may be added in the Hex textbox, or decimal values may be entered into each of the R, G and B textboxes ranging from 0–255. Click the Reset struck droplet button to revert to the default color. A preview of the active background color appears below the Background Color icon.

For application versions pre-v2019.2:

  • To change the text color, click the Foreground Color ForegroundColor.png icon to show the foreground color selector. Select a color or enter a hexadecimal RGB value. Click the Clear ClearBtn.png icon to revert to the default color. A preview of the active foreground color appears below the Foreground Color icon.
  • To change the cell background color, click the Background Color BackgroundColor.png icon to show the background color selector. Select a color or enter a hexadecimal RGB value. Click the Clear ClearBtn.png icon to revert to the default color. A preview of the active background color appears below the Background Color icon.
colorpickert.png
Color picker

Note

The colors on the bottom row of the new color picker can be set via extensibility by a system administrator on a system-wide basis or they may be available for user preference.

For application versions pre-v2019.2:

screen.fontcolorpicker.png
Color picker

Alignment

  • Text can be aligned to the left, center, right or justified in the cell using the respective horizontal alignment icons. First, click the Horizontal Alignment Selector left alignv  icon, and then choose from Left left align, Right right align, Center align center or Justified align justified alignment. The horizontal alignment selector icon will change to show the currently selected alignment mode.
  • Text can be aligned to the top, center, or bottom in the cell using the respective vertical alignment icons. First, click the Vertical Alignment Selector middle alignv icon, and then choose from Top align top, Middle align middle or Bottom align bottom alignment. The vertical alignment selector icon will change to show the currently selected alignment mode.
  • Clicking on the Wrap Text wrap text icon will cause text longer than the width of a cell to wrap to new lines instead of being cut off by the cell’s boundary.

For application versions pre-v2019.2:

  • Text can be aligned to the left, center, right or justified in the cell using the respective horizontal alignment icons.
    Horizontal alignment icons
  • Text can be aligned to the top, center, or bottom in the cell using the respective vertical alignment icons.
    Vertical alignment icons
  • The Wrap Text icon will cause text longer than the width of a cell to wrap to new lines instead of being cut off by the cell’s boundary.

Formatting Cells

Cells can be formatted in the Cell Format Window. To open the window, first click on a cell and then click the Format Cell FormatCells.png icon. The window has three tabs: Number, Border, and Conditional.

Comprehensive cell formatting information including how to use each of the three tabs can be found in our Cell Formatting article.

Cell formatting can be copied using the Format Paintbrush tool. Select the cell you want to copy, click the Format Paintbrush paintbrush

Merge/Split Cells

Multiple cells can be merged together by first selecting the cells and then clicking the Merge Cells MergeCells.png icon. This is helpful when adding a chart to a report or when creating a heading, for example.

Conversely, merged cells may be split back up by selecting the cell to be split and the clicking the Split Cells SplitCells.png icon. Only cells which have been merged can be split.

AutoSum

To quickly get a total on a Data Field, place the field in a Report or Group Footer and click the AutoSum Sum.png icon. Alternatively, a sum can be created with the aggSum or Sum functions. See Formulas for more information.

Note

Do not use AutoSum on a cell with an aggregate formula such as aggSum.

Images

An image from your computer can be added to a cell using the Insert Image InsertPicture.png icon.

Functions

Complex calculations can be done using Formulas. A formula can be added to a cell by keying it in manually or using the Formula Editor. To open the Formula Editor click the Formula Editor FormulaLarge.png icon.

Detailed information about formulas and how to use them can be found in the Formulas Section of the product documentation.

Chart Wizard

A chart visualization may be added to the report by first clicking on a cell and then clicking on the Chart Wizard Chart.png icon to launch the chart wizard. Full details about chart types and how to use the chart wizard can be found in the article on Charts.

Gauge Wizard

A gauge visualization may be added to the report by clicking on a cell and then clicking on the Gauge Wizard Gauge.png icon to launch the gauge wizard. Full details about gauges and how to use the gauge wizard can be found in the article on Gauges.

Suppress Duplicates

You can suppress duplicate values of a Data Object from being displayed. Select the cell and click the Suppress Duplicates SuppressDuplicates.png icon.

For example, the two reports below are identical, except the second image has suppressed duplicates for the customer column.

Duplicates are not suppressed
Duplicates are suppressed

CrossTab Wizard

A CrossTab Report can be added to the report by clicking on the CrossTab Wizard CrossTabWizard.png icon.

Linked Reports (aka Drilldowns)

A “subreport” can be linked to data on the current report by creating a link or drilldown to another report. Click on a cell and then click the Link Reports LinkedReport.png icon to link a report to that cell. Review the Drilldowns article for full details on how to create a report link (drilldown).

Linked Action Event

Action Events are custom programs which can be activated by certain actions on a report. This is an advanced feature. Consult with your system administrator about which action events are available in your system. To add an Action Event to a cell, first click the cell and then click the Linked Action Event LinkedAction.png icon.

GeoChart Wizard

GeoCharts are a way to visualize geographical report data. To insert a GeoChart into a cell, first select the cell and the click on the GeoChart Wizard Map.pngicon.

GeoCharts are a legacy feature, and have been replaced with the Google Maps feature. More information about the GeoCharts feature can be found in the GeoCharts article.

Google Maps Wizard

Google Maps are a way to insert interactive maps in a report to visualize geoghraphical report data. To insert a Google Maps visualization into a cell, first select the cell and then click on the Google Maps Wizard Google Maps icon.

More information about using this feature can be found in the Google Maps article.

Run Report

gqyKFERY6Y.png
Run Report button

Clicking on the Run Report button will execute the report and display the result in the Report Viewer. Depending on system configuration, clicking Run Report may also save the report first.

Execution Caching

If Execution Caching is enabled for a report, the Cache Status icons will appear in the toolbar next to the Run Report and Export buttons. A report can only be run when the cache is valid.

  • CacheInvalid.png Cache Invalid: the cache is invalid or out of date. Click this icon to update the cache.
  • CacheValid.png Cache Valid: the cache is valid.

Export

k7PRN1fok0.png
Export PDF button
firefox_wYPbd9nxnF.png
Export file types button

To export the report as a downloadable file, click on the Export PDF button. You can also click on the More AccordionItemClosedArrow.png icon to select from the additional exportable file types.

The system administrator can make only certain file types available, so the menu may look differently depending on how your installation is configured.

Formula Bar

yBfXbiQRcQ.png

A formula may be added to cells by directly entering them into this formula bar. Click the Formula Editor FormulaLarge.png icon in the bar to open the Formula Editor for assistance building the formula.

Just as when entering formulas directly into cell content, formulae should be prefixed with an equals sign.

Examples

={Orders.OrderDate}
=AggCount({Products.ProductName})
=[A5]

Additional Resources

For more information about formulas, review these articles:

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents