I have a problem with building a report that splits data in two columns. I build a payslip that shows all the data but have a problem with the last part. On the YTD data the report should show data in two columns, by splitting them evenly obviously for even numbers and if case there is odd numbers of elements the first columns should have one more row then the second one. There are total of 38 elements but not all are used.

 

Example

 

Column 1             Amt        Column 2        Amt

YTD Gross Pay     12000     YTD NI            125.00

YTD Taxable Pay  254.55    YTD Pension   254.25

YTD Emp NI         125.3      YTD Niable      455.00

 

I dont know who can I tell crystal to show it in two columns. I would be very grateful if you give me some suggestions ? I am using crystal 8.5

 

Thanks