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 separate; you work directly with your report results to customize the layout and perform whatever analysis you need.
Mercury makes creating and using reports easy. Your IT department just needs to get the data. There’s no need for the typical time and frustration involved in micro-managing a report layout. Once data are available, creating a report is easily done by anybody and typically takes 5 minutes. If you don’t like something, change it yourself, on the spot. No more waiting for someone else, or enduring endless rounds of back-and-forth tweaking.
Your customization - including layout changes, analysis (like calculated fields or conditional formatting) - can be saved, re-used, and shared.
Mercury’s Main Window
The main Mercury window has four sections.
- The Report List (and parameter entry area) on the left. You can search, sort, filter, group, and color-code your reports.
- The Report Canvas / Result Tabs in the open area. Report results are displayed and analyzed here. Work with multiple reports at the same time, and arrange them however you wish.
- The Ribbon Menu at the top - offers various features and operations. The Ribbon may change based on the report that you’re currently working in.
- The Status Bar along the bottom - usually has a brief note about the last operation. On the right side, contains a zoom/magnification control.
Here is the main window after three reports have been run.
Mercury supports four different report types.
Two "native" report types allow you to interactively customize and analyze your report results.
You can also run these types of reports:
If your company has SSRS and/or Crystal reports, they’ll appear in your Mercury report list. All your reports are together, run from the same place, in the same way.
Requirements Microsoft Windows 64-bit (Windows 7 or higher) .NET Framework 4.8 or higher If you’re installing a trial, there are no restrictions or limitations, and no credit card is required. Some Background Report layouts and other metadata are ...
Mercury Quick Start for Users
Thank you for installing Mercury! Here you’ll find a quick introduction – what you see when you launch Mercury, and a few examples of how to run reports. When You Launch Mercury Depending on whether your organization already has Mercury, you’ll ...
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 ...
Every Mercury user must have a corresponding User record, which specifies the user’s report permissions and also allows Mercury to manage user-specific content such as Favorites and report-colors. Only users who belong to the built-in SYSTEM (System ...
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 ...