Creating and Editing Custom Reports

Contents of this Topic: Show

Overview

Monsoon Order Manager provides many standard reports that cover most forms of printed output that is required by a business, such as invoices, as well as some business analysis reports. In the event that the user wants to extract different information from the program, or the same information but in a different format, the program provides the Custom Report Maintenance feature to manage reports that are created by the user or a third party for use with Monsoon Order Manager .

Many of the standard reports also come with several different templates from which the user can choose. It is recommended that the user research the existing templates for selected reports before creating a custom report, which might not be necessary.

The template that a report uses is controlled by a series of system parameters, such as InvoiceTemplate,  etc., which are found in the Report parameter group. If a custom report is created, the user will have to type in the name of the desired custom report, as it will not be populated in the drop-down list for the parameter.  

Reports are housed in the Monsoon Order Manager program file that is installed on each workstation in the complex. When a custom report is created, it only exists in the program file of the workstation where it was developed. In order to share that new report with the other workstations, the user must export it from the local workstation to the Custom Reports database, which is located in the shared folder when Monsoon Order Manager is installed on a LAN . Once the report has been saved in the Custom Reports database, it can be exported to the other workstation's program files, so that all users have the same version of the report.  

Even a simple change, like altering the report to print on a specific printer, constitutes the creation of a custom report. Include your company name in the titles of any custom reports, e.g. Ajax Sales by Product. This helps distinguish them from the Monsoon Order Manager standard reports, and it will also group them together in the list of reports which makes them easier to locate.  

It is imperative that any changes made to a custom report must end in that report being exported to the Custom Reports database, or the changes may be lost during the program upgrade process. Saving the report in the Custom Reports database ensures that the reports will be available to the user in future releases of the program. Depending on properties of the custom reports and the nature of any changes made to Monsoon Order Manager, the possibility exists that the report may need to be modified to match the changes in the program.      

This article outlines the basic steps to follow to customize reports. For detailed information, refer to MS Access Help or other resources on the topic.

Monsoon Commerce can create custom reports for a fee. Contact the sales department at 484-927-4804 for a quote.

Creating or editing a custom report

  1. Make sure the program is set to Show the Microsoft Access ribbon before beginning this process. Go to Main Menu>Settings>Hide or Show the Microsoft Access Ribbon. Select Show.

  2. Go to the Main Menu.

  3.  Press F11. The database objects window opens if the user has access to that screen when the Monsoon Order Manager security system is enabled.

  4. Select Reports under Objects on the left-hand side of the screen to see the list of reports provided with the program.

Creating a custom report from one of the Monsoon Order Manager standard reports

  1. Select the report to be customized.

  2.  Press Ctrl+C, or right-click and choose Copy.

  3.  Press Ctrl+V, or right-click and choose Paste. Enter a file name for the new report.

  4.  Edit the report in design view, as needed.

  5.  Save the report.

  6.  Go to the Custom Report Maintenance screen and export the new report to the Custom Reports.mdb.

  7. Select Add to Custom Reports Menu.

  8.  The new report is listed in the Report Menu.

Building a custom report from scratch

  1. Select New and enter a name for the new report.

  2.  Use the report wizard to select the data and layout for the report.

  3. Save the report.

  4. Go to Custom Report Maintenance screen and export the new report to the Custom Reports.mdb.

  5. Select Add to Custom Reports Menu.

  6. The new report is listed in the Report Menu.

Additional information

Custom Report Maintenance

How to Create a Custom Report from a Stone Edge Standard Report

Report Menu

Security System

Report-Specific Printer Settings

 

Created: 5/2/12

Revised: 7/6/15

Published: 08/19/15