R&R Ver. 2.0 Questions displaying output Horizontally

[adonisd]

I am stuck and can^t figure out what command to use in order to display the entries under a heading in my database horizontally instead of vertically. I have a list of names, but I want them to print at the end of the report one after another seperated by a comma. Help!!

[cstrasser]

[updated:LAST EDITED ON Nov-21-12 AT 10:32 AM (EST)]Trying to turn vertical output into horizontal data isn^t simple. From what you^re saying, the output looks like:____Jim__Dawn__Mike__Grace__Betsy__Fred____But you want to create____Jim,Dawn,Mike,Grace,Betsy,Fred______If you have a good idea of the maximum number of entries you^d get in a given category, there is an option:____Create a total field that generates a running count of the number of entries in the group. For instance, I created a report showing the categories of pay elements (E / D / T). The calculation (called PostCount) is a running grand total accumulating on each group. The output looks like:____Group E 1__Group D 2__Group T 3____Then I created three calculated fields:____ShowFirst IIf(PostCount = 1, POSTTYPE, "")__ShowSecnd IIf(PostCount = 2, POSTTYPE, "")__ShowThird. IIf(PostCount = 3, POSTTYPE, "")____With these calculations on the report layout, the output now looks like (note that the dots are just for spacing):____Group E 1 . . . E__Group D 2 . . . . . . D__Group T 3 . . . . . . . . . T____Finally, I created a total for each of the Show... calculated fields called FinalFirst, etc. These I dropped into the summary band. They are defined as:____FinalFirst: Maximum(ShowFirst(), Grand, POSTTYPE, Running)__FinalSecnd: Maximum(ShowSecnd(), Grand, POSTTYPE, Running)__FinalThird: Maximum(ShowThird(), Grand, POSTTYPE, Running)____Which means that they will evaluate the output of each calculation, either a letter or a blank space and drop the higher system value of each. In all cases, a letter is "greater" than a blank, so the letter drops down into the summary band. I placed a comma between the three totals and set the trim on and get:____Group E 1 . . . E__Group D 2 . . . . . . D__Group T 3 . . . . . . . . . T____Summary E,D,T____