Creating new reports

[samanime]

Hello,

Is there any easy way to create new reports under the Report tab of the admin site?

The report I need is basically the Customer Report-Totals, but with geographical information added (address, etc).

Is there some way via the admin, or an easy way that I can just duplicate that report and add the new columns I need?

Thank you.

[fairestcape]

In the Free Software Downloads section (link above) you may find a suitable report mod in the ADMIN section. Blindside's SALES REPORT may be helpful.

Make sure to use add-ons that are compatible with your ZC version.

[samanime]

Unfortunately, that doesn't seem to help. It still doesn't display the geographical information (the address), which is the vital element here.

[gharls]

Are you handy with SQL?

You could probably pull out the information you need from your ZC database by tweaking the following model:

SELECT (necessary fields)
FROM customers a, address_book b, countries c, zones d, orders e
WHERE (your particular conditions for the subject report)
GROUP BY (if necessary)
ORDER BY (your sort preference)

Of course, if you avoid SQL crunching by preference, then the above syntax may seem like gobblety-gook to you. My sincerest apologies if the latter instance stands in your case.