I need to create a crystal report off of a MS SQL 2000 database. The report is an customer address master report, with the customer info coming from CUSTOMER_SQL and delivery, billing , etc addresses coming off of ADDRESSES_SQL. I'd like to format everything on one line, such that I can put customer master, bill-to address, delivery address on one line of an Excel spreadsheet if I export it to excel. I don't want multiple lines for each customer. The ADDRESSES_SQL table contains a separate record for delivery address, billing address, etc... Any idea how best to report under one row?
Thanks
Thanks