Using a Favorite

Share on facebook
Share on twitter
Share on linkedin

If you find that you are running the same report multiple times – especially if you want to change the layout or add calculated fields or conditional formatting – a favorite is exactly what you need.

Favorites allow you to save parameter values and layout changes (rearrangements, calculated fields, conditional formatting, etc.), so you can easily re-run a report at any time, just the way you want it.

Each report can have its own set of favorites, as many as you need.

See Creating A Favorite for more information.

Running a Favorite


1). Select the report from the list on the left side of the main Mercury window. If the report has at least one favorite defined, a fly-out menu appears to the right of the report’s entry, showing all the favorites available.

In the example below, four favorites have been defined for the report.

2). If you want to run the favorite exactly as it was saved – including parameter values – simply click its associated Run button in the favorites list.

If you’re unsure about the parameter values or want to run with different parameters, click the favorite to select it (click on the name of the favorite, not its Run button). That will populate the “Enter Parameters” area below the report list, so you can see the parameters that were saved with the favorite.

Tip: If you want the favorite layout but with different parameter values, simply change the displayed values in the “Enter Parameters” area and then click the Run button below the Enter Parameters area. You’ll get your favorite layout but with the parameter values as you changed them. However, the favorite itself is not updated. For more information on changing the favorite, see Updating an Existing Favorite.


Tip: Once you have run a favorite, Mercury keeps that favorite in use for the report until you change it, and shows you a reminder. To run a different favorite, follow the steps above. To clear the favorite so you can re-run the original report layout, right-click the favorite reminder and choose “Reset”.

Finding a Favorite


You can search the list of favorites. Both the name and description are used to search.

  • Search for the favorite by typing a portion of the favorite’s name into the Search text box.
  • Select a recent search from the Search box’s drop-down list.
  • Using the icons at the bottom of the Favorites menu, filter to show only “private” favorites (not shared) or those favorites that you have shared with others.
    Private favorites are shown in the list in normal type; shared favorites are in italics. In the favorites list above, the first and last items are shared; the middle two are shared.

When a category is active, it is highlighted.

Updating an Existing Favorite


You can update a previously created favorite at any time, adjusting the settings used by the favorite, the saved report layout, or both.

1). Run a report with desired parameter values – this can be based on an existing favorite, or a report from scratch.
2). (optional) Make layout changes as desired.
3). In the report’s Ribbon menu, click the Save Favorite button.
4). If your report is based on a favorite, the Name box should be pre-populated with the current favorite. Regardless, you can click the down-triangle on the far right of the Name box to choose any existing favorite you wish.
5). (optional) Adjust the favorite’s description and any other settings. For more details, see Creating A Favorite.
6). Click Save. A message appears, confirming that you want to update (replace) the favorite.
7). Click Yes. The selected favorite is updated.


Deleting a Favorite


You can delete a favorite at any time, permanently removing it from a report’s Favorites menu.

1). In the reports list, click the report that uses the favorite you want to delete.
2). On the Favorites menu that appears, right-click the favorite and choose Delete.
This immediately removes the favorite. If you deleted it by mistake you will have to re-create it. See creating a favorite for details.

Share on facebook
Share on twitter
Share on linkedin

Start your free 14-day trial

Try Mercury on a fully-functional 14-day trial. Download and install to use with your own data or try Mercury in a remote desktop session using our demo data. 

Try Mercury For Free

  • You can try Mercury using existing reports and data with our demo sandbox, or connect it to your own data (we can help you with that). The trial is fully functional; there are no restrictions or limitations.

    System Requirements