Creating new reports

[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.