2-Column Report and Keep Together
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.
Re: 2-Column Report and Keep Together
1.- Create a new formula
Code:
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
Re: 2-Column Report and Keep Together
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.
Re: 2-Column Report and Keep Together
In Section Expert, select the desired group and check the New Page After checkbox
Re: 2-Column Report and Keep Together
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.