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

Creating Custom Reports For Use Within The Admin Site


Synopsis
Store owners can create custom reports that can be run through the admin site

Procedure
First you'll need to add your custom report to the database through a SQL query.  You can do this one of two ways; through SQL management studioes express while connected to your database server OR you can run the SQL query tool in the admin, Configuration > Advanced > Run SQL.

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')

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.  Select your report from the drop down box and it will be populated in a datagrid below