Skip to main content

The Report Wizard

The article refers to Jet Reports version 2019 and higher.  Older versions will appear slightly differently.

Overview

You can easily create an entire report from a single table in your database using the Report Wizard, accessible from the Report Wizard button on the Jet ribbon.

Using the Wizard

  1. The first step is to select the Data Source, Company, and database Table from which you want to retrieve data.

  2. Clicking the arrow in any of the text boxes will display a pull-down list for that information.  By default, t he Report Wizard will show all the tables and fields in your database.  If you have set up favorite tables and/or fields, you can click the star symbol next to to the item you are selecting to display only your favorites.  You can scroll through the list or type in the text box to find those fields that match what you have typed.

    You can navigate between sections of the Report Wizard by using the Next and Previous buttons at the bottom or by using the Navigation pane to the left.

  3. Once you click Next , you can select the fields you want in your report.  You can adjust the order in which the fields will appear in your report by clicking and dragging them up or down in the Column Order pane on the right.

  4. The next screen allows you to set filters.  Clicking the funnel symbol in the Filter Value box, will display a list of available values you can use in your filter.

    If you check the Add as a report option box below the filter, the option to set filter will be displayed to anyone who runs the report.

  5. The next screen allows you to Group your data by a specific field you are including in your report (and, later, you have the option for including subtotals for any numeric fields you may have selected).

  6. The next screen allows you to sort your data by any of the selected fields (in ascending or descending order).

  7. If you have numeric fields in your report, you have the option to create totals for those fields and to display subtotals for any groups you may have created.

  8. The next screen gives you the option to add basic Excel formatting to your report and/or to use Excel's Data Grouping feature to outline any groups you may have added earlier.

  9. Finally, you are presented with a summary of the report you have defined.  Once you have reviewed and are ready to proceed, you can click the Finish button to create your report. The report is created in an entirely new Excel workbook so it does not overwrite any existing worksheets in currently open workbooks

Related Articles

Was this article helpful?

We're sorry to hear that.