Recent Articles
Database Queries for Reports and Lookups
To obtain data for your reports (and lookups), Mercury must query your database(s). Depending on the Connection used for your report or lookup, there will be one or more of the following query-types available. (For more on Connections, see Admin > ...
Evaluating Mercury with your Own BC Data
This article assumes that you have already installed Mercury. Mercury comes with a handful of sample reports, including several that use Dynamics 365. These BC sample reports all use a data “Connection” that points to the Mercury’s own BC-Online ...
Connections
Each Mercury report is associated with a specific Connection, which tells Mercury what data source to use and how to talk to it. Mercury can use a variety of different data providers – everything from SQL Server to CSV text files. The exact set of ...
Data Providers
A “Data Provider” designates the specific database, file-type, or other data source that Mercury can use to retrieve data for your reports. When you create a Connection to a particular data source, you choose the Data Provider. See Admin > ...
Evaluating Mercury with your Own GP Data
This article assumes that you have already installed Mercury. Mercury comes with a handful of sample reports, including several that use Dynamics GP data from our Test-and-Demo server on the web. Redirecting these reports to use your own GP server ...
Popular Articles
Mercury Overview
What is Mercury? Mercury is a general-purpose reporting and analysis tool that works with a variety of databases - for example: SQL Server, MySQL, Business Central (and other OData sources), CSV files, and others. Reporting and analysis are no longer ...
Ribbons
Ribbon Menus Mercury uses standard Microsoft-style ribbon menus for performing actions, specifying settings, and other application options. Some ribbons are always available; others may change depending on what you’re doing in Mercury at the time. ...
Report List
The Report List contains all the reports available to you. You can change its appearance in several ways. You can change how the list is presented To change the list appearance, use the small icons above the search box. Icon Description The pin ...
Report Canvas
Report results appear in the main window to the right of the report-list. This region is called the "report canvas" or the "results area". You can open (i.e. run) as many reports as you like, including multiple runs of the same report with different ...
Status Bar
The status bar is located at the bottom of the main window. The left side shows the status of your current (or most recent) action. The right side has a slider that makes the content of the main window larger or smaller. You can drag the slider or ...