Quick Tour

The Quick Tour is the quickest way to get familiar with the basic features of Maxene Reporter. This tour takes you through the various steps required to generate a sample Sales Report (as shown in the figure below) using Maxene Reporter™. As you can see the report is presented as a Microsoft® Excel workbook.

Sales Report generated with Maxene Reporter

The above report shows data for top 10 invoices to customers of a given state. The report is based on a Sales database (MR_SAMPLE.mdb) located at the server and uses the Customers and Sales tables in the database. The data retrieved from these tables for the report includes:

Customers:    Customer name

Sales:              Invoice number, Sales amount.

The following topics in this tour take you through the different steps required to create the Sales report. (Click any of the links below to see complete details of the associated step).

1. Login to Maxene Reporter: This topic shows how to log-in Report Administration mode and then start creating a new report.
2. Report Maintenance: This topic introduces the options in Report Maintenance screen and shows how to enter a report name and choose a Report Template.
3. Report Parameters and Constants: This topic dwells further on the Report Maintenance screen showing how to create Report Parameters and Constants.
4. Querying the database: This topic shows how to use DSN to connect to a database and write SQL queries to retrieve data from the database.
5. Query Parameters and Output: This topic shows how to define query parameters and to set up an Output list for the query.
6. Creating a Job: This topic shows how to schedule jobs from a report after completing the report definition.

                                                                                                                                                                                                                Next