2-Column Report and Keep Together

[eugz]

Hi All.
I create crystal report using VS2005 and grouped it by LastName and keep together. Now I would like to modify report that all groups of users with same first letter of LastName will print on separate pages and report has two columns on page. How to do it?
Thanks.

[jggtz]

1.- Create a new formula

Left ({Table1.LastName},1)

2.- Insert a Group on that formula (eliminate your actual group before)
3.- Now you have your data ordered by first letter
4.- Enter to Section Expert & select Details Section
5.- Check 'Format With Multiple Columns' check box (at right side)
6.- Enter to Layout tab ( upper right )
7.- Define your columns
8.- Good luck

JG

[eugz]

Hi All.
jggtz, thanks for replay. It works.
The keep together works fine across pages, but the groups of LastName still break across columns. Is there any way to prevent these groups from breaking this way? The groups are all different sizes. And if it doesn't fit whole group start other coulmn with new group of LastName. Is it posiable to do? And if yes, how to do it?
Thanks.

[jggtz]

In Section Expert, select the desired group and check the New Page After checkbox

[eugz]

Hi All.
jggtz, thanks for replay. It doesn't work.
The option New Page After works for page. I'm asking how to keep together the groups of LastName on page and keep together across columns.