From the admin console, clickReportsin the left navigation.
If the built-in reports don't meet the needs of your site, the store administrator 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
VALUES('Test Report', 'Test Description of our report', 'SELECT Email, BillingZip FROM ORDERS')
You can use the Configuration > 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 console, go to the Reports page, choose your custom report from the drop down list, then click Get Report. If there are no errors in your SQL statement or the SQL Command you're using to generate your custom report, your results should appear in a data grid on the right. If there are errors, they should appear onscreen right away. You may also want to choose View System Log from the Configuration menu to track down any custom report issues.
Once the report has run, you can click to Save Excel Export.