Display records on multiple columns

[tweetyng]

I have a report maximum each customer have 4 records, and if a customer have more than 2 records then split the page 1/2 and display on the other half, report run by CustomerID

Data:

CustomerID Date GivenBy
200 01/01/02 TNT
200 02/25/03 CNP
200 07/20/03 TNT
200 12/20/05 TNT

I would like the result showing like this:

Date GivenBy Date GivenBy
-----|-----------------------------------|------------|--------------------------------------
1st: | 01/01/02 TNT | 3rd: | 07/20/03 TNT
2nd:| 02/25/03 CNP | 4th: | 12/20/05 TTN
-------------------------------------------------------------------------------------------
Anyone has any ideas, please help, thanks






TN (USA). I'm using Windows XP, Crystal Reports 10 and SQL Server

 

[synapsevampire]

If that's going to be the entire page, then you can format the report by right clicking the details and selecting format field->format with multiple columns and setting it accordingly.

If you intend to have multiple customers per page, then you might resolve this by using an array to save the values in.

Please clarify.

-k

 

[lbass]

What else is on the page? I'm assuming you are formatting your detail section to multiple columns. The problem with using the down then across feature is that it won't wrap to the next column until it hits the page bottom. If you can, you could increase the page footer so that only two detail rows will fit. Otherwise, you would need to insert a subreport that is linked on a customer ID group and placed in a group section. Then you would use "format with multiple columns" in the subreport. You would have to format the subreport object (format subreport->common->UNCHECK "can grow") so that the limited subreport height will force the additional column.

-LB

 

[tweetyng]

I run only one customer per page, so I guess I can do what your suggestion. However, I try to right click the detail to check the "format with multiple columns", but I don't see it there. I'm using CR 10. Could you please help? thanks

TN (USA). I'm using Windows XP, Crystal Reports 10 and SQL Server

 

[tweetyng]

ignore my question, i found it ...let me see if it works, thanks

TN (USA). I'm using Windows XP, Crystal Reports 10 and SQL Server

 

[tweetyng]

Thanks synapsevampire and lbass, it worked.
I'm very appreciated.

TN (USA). I'm using Windows XP, Crystal Reports 10 and SQL Server