Table Reports Information
Sparklines
A Sparkline is a small, generalized chart that provides a condensed visual representation of the data from which it is drawn. They are an effective way to show trends and birds-eye-view comparisons. In Mercury, a Sparkline resides in a Table Report ...
Table Reports - Parameter Comparison Operators
How are Comparison Operators Used? Some reports, in addition to asking for parameter values, allows you to specify the type of comparison you want to use when selecting data records for your report. For example, you might have a general ledger report ...
Summarizing and Grouping
Summarizing Table Reports provide several different summarizing functions (Count, Sum, and others). You can display summaries at two different levels: Total (for the entire report), and by Group (you can select one or more columns for grouping ...
Conditional Formatting
Conditional formatting is a rule-based method to apply formatting to individual cells based on their values. It helps you to spot trends and patterns without having to closely examine each row or cell. You can use conditional formatting to change ...
Calculated Fields
Calculated fields (also called "unbound columns" or "unbound fields") are report fields that you create. A calculated field is not part of the report’s original data source but is derived from the data based on an expression (a formula) that you ...
Printing Table Reports
You can print a Mercury report in two different ways: Print-Preview - displays the report in a "Print Preview" window, so that you can see what it looks like and change your page layout before printing. Quick-Print - immediately sends the report to ...
Exporting Table Report Results
This article is about exporting report results - saving report data in another format (Excel, PDF, etc). Mercury also offers another type of export - exporting the report definition. You might wish to do this for backup purposes or for subsequently ...
Filtering
Filtering means limiting the data displayed on your report, based on criteria that you specify. You can add, modify, or remove filters as you wish. When filtering is applied, only data rows that meet the specified criteria are displayed. You can ...
Searching and Sorting
Searching To search within the results: Right-click on any column header and select Show Search Panel. A Search text box is displayed on top of the report. It allows you to search for terms or phrases within the report. Enter your search term or ...
Working with Columns
To show or hide columns: Right click on any column header and select Show Column Chooser. ...
Right-Click Menus
Right-click on a column header Sort Ascending - Sorts the column data in ascending order. See Searching and Sorting. Sort Descending - Sorts the column data in descending order. See Searching and Sorting. Clear Sorting - Removes sorting from ...
Favorites
What is a Favorite? A favorite lets you save, reuse, and share your work. When you run a report, you typically provide values for report parameters. And when the report appears on screen, you might change the layout, add calculated fields, filter the ...
Running Table Reports
Pivot reports and Table reports are run in exactly the same way. The following examples may show pivot-reports, table-reports, or a mixture - it doesn’t matter. Reports are run in one of two ways. Running from scratch: select the report, specify the ...
The Table Report Ribbon
General Run - Run the selected report (values for all parameters must be supplied for this to be enabled). See Running Table Reports for more information. Print - Print the current report. See Printing Table Reports for more information. Export - ...
Introduction to Table Reports
A Table report presents data in a simple tabular layout, similar to an Excel worksheet. Unlike Pivot reports, Table reports do not allow you to have multiple levels of row or column breakouts, or exchange rows and columns. But you can still do a lot: ...