Report on one row

[gc6294]

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

 

[TheBlondOne]

Try inserting a text box and including all your fields in that side by side. Then when the report is exported it should all be on one line

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[gc6294]

How do I get delivery address and billing address to print side-by-side instead of creating a new row for each one?

 

[Madawc]

If you link a customer record and an address record, both should be present in the 'row'.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[gc6294]

Thanks.. I was hoping to get the customer record and multiple address records to appear on one row.. If there's 1 customer master record and 4 address record (delivery, billing addresses, etc) I was hoping to get all addresses to appear horizontally on 1 row, rather than creating 4 rows.

 

[Madawc]

You could do that with subreports. It will run slowly, since there is a separate database access each time a subreport is called at detail level. But it would do the job.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10