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.