Skip to Content
0
Former Member
Aug 07, 2008 at 03:43 AM

How to display half of the records on left and another on the right side

1016 Views

Hi All

I am working on a crystal report in which we need to display the data in such away that half of the records on the left and another half on the right.

as shown below

I am having the data like this with 3 columns.

*Name     TimeShift    Schedule*     

Ashok    10.00-11.00   Football
Ashok1   09.00-11.00  Football
Ashok2   10.30-11.00  Cricket
Ashok3   10.00-11.30  Football
Ashok4   10.00-11.00  Football
Ashok5   10.00-11.00  Football
Ashok6   10.00-11.00  Baseball
Ashok7   10.00-11.00  Football
Ashok8   10.00-11.00  Football

Total 9 records I have. But I need to display

1st record on the left

2nd on the right

3rd on the left

4th on the right.......

Final Output should be like this.

*Name     TimeShift   Schedule       Name     TimeShift   Schedule* 
Ashok    10.00-11.00  Football       Ashok1   09.00-11.00  Football
Ashok2   10.30-11.00  Cricket        Ashok3   10.00-11.30  Football
Ashok4   10.00-11.00  Football       Ashok5   10.00-11.00  Football
Ashok6   10.00-11.00  Baseball       Ashok7   10.00-11.00  Football
Ashok8   10.00-11.00  Football

Appreciated ur help in advance.

Thanks.

Ashok