We help IT Professionals succeed at work.
Get Started

Crystal Reports Detail into columns

Last Modified: 2012-05-09
I have a report i have created that has each page split by Group 1, which is the Employee number, then it has a detail field which fills out every benefit plan they choose. The problem is that it does not fit on one page. I currently have it suppressing blank entries, so it works for some. What i need is a way to split the detail section into 2 or 3 columns.
I tried to split it into two columns which almost worked. I did a mod function to display every other field, then created a formula to take the nextrecord of the same field. Then i applied the same mod function. This worked correctly until the very last record on the second column. If there were an odd number of detail entries it would not have a next record to place in the last spot so it would pull a record from the next group.
If anyone has any ideas on how to either make my current setup work, or how to create two columns I am all ears. Additionally I want to be able to set the size of the details section so it is the same size for everyone, but i may just stop suppressing blank fields which would fix that.
Watch Question
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE