Skip to Content
0
Former Member
Apr 04, 2011 at 03:38 PM

Multiple columns for more than one record?

17 Views

Crystal Reports Xi

I have a list of addresses, etc. with attached route numbers. If an address has 2 different route numbers, it will appear as two records. Is there a way that I can list the address once, and have the route numbers just grow to more columns?

Example - Change this...

ADDRESS ROUTE

100 Main St. 1234

100 Main St. 1235

To This...

100 Main St. 1234 1235

Note: An address may have one route number attached, or several route numbers attached.

I tried playing around with the multiple columns, etc, but it kept on having everything in the section become multiple columns, etc. Any help is appreciated.