Background Reporting in the Jet Excel add-in – Support Topics

Applies to versions 2018R2 and higher

Overview

Jet Excel add-in includes the ability to run reports saved on your local computer and continue to use Excel or even run reports from your local desktop, without loading Excel at all.

The Run in Background feature is supported for reports that are saved on a local machine. Running reports from cloud-hosted environments is not supported.

Running in Background from Excel

With your report open in Excel, select Run in Background from the Run button on the Jet ribbon...

Click on the arrow at the bottom of the button to display all choices.
If your report is configured to prompt for Report Options, a dialog will display asking for the specific parameters to use for this run...

Once all options are correct, click the Run button on the dialog window

A warning dialog box will come up, press OK to continue with running the report.
Your report will close, a new Excel workbook will be opened for you, and the Jet tray application will start, and a notification will be displayed letting you know that your report is running...

If desired, you can click on the notification or the Jet icon in the tray to view the progress of your report.
You will receive another notification once your report is completed and available for viewing.

Click the notification or the Jet icon in the tray to display the Jet Reports Report Queue.
In the Jet Reports Report Queue, you can see the status for any reports that are currently running, completed and available for viewing, stopped, or are pending.

Click Open for the report you wish to view.
Your report will then be opened in Excel.

Running in Background from your Desktop or folder

Navigate to the local folder where you have saved your report(s), right-click on the file(s), and select Run Jet Report:

You can select up to 100 reports to run at one time.
If any of the selected reports are configured to prompt for Report Options, a dialog will appear asking for the specific parameters to use for each report...

Once all options are correct, click the Run All button on the dialog window to start all of the selected reports.
The Jet tray application will start and a notification will be displayed letting you know that your reports are running...

If desired, you can click on the notification or the Jet icon in tray to view the progress of your reports.
As your reports complete and become available for viewing, you will receive additional notifications...

Click a notification or the Jet icon in the tray to display the Jet Report Queue.
In the Jet Report Queue, you can see the status of any of the reports that are: currently running, completed and available for viewing, stopped, or are pending.

Click Open for any Completed report you wish to view.
The report will then be opened in Excel.