Looking for the v10 manual? Visit our new user's guide!
Search Descriptions Version
This article applies to: ML8, MultiStore

Custom Report

From the Orders menu, click Reports → Custom Report (this page is included in the "Reports" page in MSx9.3.1.0+)

If the built-in reports don't meet the needs of your site, the store admin can create custom reports and run them through this page. The reports are simply SQL commands stored in the database, which can be run at any time. The Custom Reports/Reports page is simply the display page for reports created using the method below or built-in reports, and contains no additional means to create, modify or format the reports.

Adding a Custom Report

First you'll need to add your custom report to the database through a SQL query.

Values to be used:

- Name: Name of your custom report
- Description: Description of your custom report
- SQL Command: SQL query to call/populate your SQL report

Note: For beginners with SQL consult w3schools 'Introduction to SQL'

Sample Query:

INSERT INTO CustomReport (Name, Description, SQLCommand)
VALUES ('Test Report', 'Test Description of our report', 'SELECT Email, BillingZip FROM ORDERS')

You can use the Configuration - Advanced - Run SQL tool in the admin console to submit your customer report to the database. Once you've submitted your query to the database it's time to test your custom report. In the admin go to ORDERS > REPORTS > CUSTOM REPORTS (or REPORTS in MSx9.3.1.0+). Select your report from the drop down box (or selected Radio Buttons in MSx9.3.1.0+) and it will be populated in a datagrid below (or in the pane to the right in MSx9.3.1.0+)

Once the Report is displayed, it can be EXPORTED to Excel in version MSx9.3.1.0+