Columnar Report

[Alan_Klein]

Hi all,____I have a report that groups names into eight groups. It is, of course, easy to see those groups vertically down the page. I can also use the Record Layout section to make two columns WITHIN a group so that Group one is at the top in two columns, followed by Group 2 in two columns, etc.____What I need is a report that will show all of Group 1 at the left, all of Group 2 to the right of Group 1, Group 3 below Group 1, Group 4 to the right of Group 3, etc., as below:____1 2__Smith, Jose Lopez, Arnold__Chen, Louise Davinderpaul, Jane____3 4__Wesson, Oyl Barbarino, Vinnie__Jagger, Mick Bartlett, Jed__ __5 6__Lane, Lois Bean, Jalapeno__Man, Super Ghandi, Mahatma____7 8__Man, Bat Vinegar, Fulla__Ortiz, David Rabbit, Jack____Is there any way to do this in R&R? I have Version 11.1.007.

[Alan_Klein]

Hopefully this looks more like what I need! (The lines are only there to keep the words lined up correctly, as this forum evidently strips out multiple spaces!)____1_______________2__Smith, Jose_______Lopez, Arnold__Chen, Louise______Davinderpaul, Jane____3_______________4__Wesson, Oyl______Barbarino, Vinnie__Jagger, Mick______Bartlett, Jed____5_______________6__Lane, Lois________Bean, Jalapeno__Man, Super_______Ghandi, Mahatma____7_______________8__Man, Bat_________Vinegar, Fulla__Ortiz, David_______Rabbit, Jack

[kfleming]

I cannot think of an easy way to do it in a single report. If you are willing to export the results of this report to a DBF file you could get there I think.____What I would do is to create a calc field that would return a group, a detail number and a column position and export that to DBF.____Smith, Jose-Group 1-Detail 1-Col 1__Lopez, Arnold-Group 1-Detail 1-Col 2__Chen, Louise-Group 1-Detail 2-Col 1__Davinderpaul, Jane-Group 1-Detail 2-Col 2__Wesson, Oyl-Group2-Detail 1-Col 1__Barbarino, Vinnie-Group 2-Detail 1-Col 2__Jagger, Mick-Group 2-Detail 2-Col 1__Bartlett, Jed-Group 2-Detail 2-Col 2____You would also need a second export file that would have a Group and a detail field with as many records as the maximum number of details for any group. This master then does two lookups into the first export, one to grab column 1 and one to grab column 2.____Exports and multiple reports often are the best solution for tricky report design problems.____Kathleen__R&R Support__

[Alan_Klein]

Thanks, Kathleen...I^ll try it and let you know how I do!

[Alan_Klein]

Kathleen,____Thanks...your export idea worked great! I modified it in that I did only the first export and then, using the exported dbf file, created a report with eight recursive fields - one for each group - that added a line feed [chr(10)] and the person^s name to itself, if that person qualified for that group. (e.g., PrintS, with the expression IIF(Group = "S", PrintS+CHR(10) + LAST_NAME + ", " + FIRST_NAME, PrintS).____I then put each of the eight fields, word-wrapped, into the Summary, with a long field of hard-coded spaces underneath each pair so that the pair of fields below would line up properly.