Try Custom Reports > Customers and Orders. Shipping info is stored against the orders and it can be obtained through that report.
Thank you for your reply, but is there anyother way of doing this.
Can you please tell me from where can I access the BC database?
And how can I write custom code in BC.
Hi Suraj, you can not run server side code on BC nor can you have direct acccess to DB.
Can you use Webservices to get this information?