Mercury Overview

Mercury Overview

What is Mercury?

Mercury is a general-purpose reporting and analysis tool that works with any SQL Server database(s).

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. And there’s no separate deployment step - the report is available immediately. There are no endless back-and-forth rounds of tweaking and customizing - you can do all that in place.

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.


Report Types

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:

  • SSRS
  • Crystal

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.


    • Related Articles

    • Installing Mercury

      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 ...
    • Users

      Every Mercury user must have a corresponding User record, which specifies the user’s permissions and also allows Mercury to manage user-specific content such as Favorites and report-colors. Only users that belong to the built-in SYSTEM (System ...
    • Microsoft Dynamics GP Actions

      By using Mercury "Actions" in a report based on a Dynamics GP database, you can: Open an underlying GP form associated with the data (a drillback) Open an attached document Each of these is features is discussed in detail below. For a general ...
    • 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 ...
    • 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 ...