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.
Select the report from the list on the left side of Mercury’ main window.
The parameters needed by the report (if any) appear in an area below the main list.
If necessary, specify the parameter values.
Each required setting is marked with the icon. These must be provided before the report can be run.
In this example, there are three required parameters.
The method for specifying a report's parameters varies based on the type of parameter and the design of the report. In some cases, you may simply enter a value. In others, you may be presented with a list of values from which you can choose (a "lookup-list").
Lookup-lists can be multi-select or single-select. Multi-select lists have checkboxes so you can choose more than one value.
In either case you can search for items using the built-in search-box at the top of the list.
Dates can be hand-entered, or you can click the drop-down icon (the downward-pointing triangle at the right of the date’s entry-box) to open a calendar date-picker.
For more information on the parameters used by a particular report, contact the report's designer or your database administrator.
Some reports may allow you to specify “comparison operators” in addition to parameter values. (For example, you could say that you want transaction dates “less than” a date you specify.) See Parameter comparison operators for details.
Click the Run button below the Report settings area.