How to work with multiple columns in a crystal report?

I am creating a report where the fields will be coming from SQL. In the report I'll be using two fields from the DB. If the number of records exceeds ten(meaning there are already 10 rows), the other records will be carried to the next column.I dont know how to create a new column for the remaining records(those... show more I am creating a report where the fields will be coming from SQL. In the report I'll be using two fields from the DB. If the number of records exceeds ten(meaning there are already 10 rows), the other records will be carried to the next column.I dont know how to create a new column for the remaining records(those that exceed ten). The format of the report goes like this:

table.NUM table.NAME______| table.NUM table.NAME
1___________record1_______| 11_____________record11
-___________ -____________| - ______________-
-___________-_____________| - ______________-
-___________-_____________| -______________-
10__________record10______| 20_____________record20

Thanks...
3 answers 3