What is the best method (using Crystal 9) to display report data in a series of 3 columns?
The report is a deposit slip. One column set would include (payee, check number & check amount). When the quantity of rows exceeds column set 1, the next record(s) should roll to column set 2, then column set 3.
I don't have any problem returning the data in one column set. The main problem is rolling the records to the next column set on the same page.
See my mock up in attached excel. I tried cross tabs w/o success.
I'll award points best I can. I hope you can provide the theory and get me started.