Display a certain number of rows to columns on crystal report

For example

SQL Rows

Name

Fred

Jack

Dan

Bryan

Chris

Paul

William

This is what i need on the Crystal report

___Fred ___Jack ___Dan ___Bryan

___Chris ___Paul ___ William

Solution:

Here's what you need to do:

1) Place the fields on the details section

2) Go the Section Expert > select Details section > check "Format with multiple columns"

3) Then go to the Layout tab in the same window, set the width to 2.00 inches (you would need to play with this depending on the size of field)

4) Then check the option "Across then Down"

5) To draw the line, simply use the Line Object before the field