Crystal Reports XI Row to Column

[lm1340]

I am trying to get certain data from a row into a column. I would like to move a variable # of scholarships linked to one individual all to a single line item with multiple columns for each scholarship.

It currently looks like this:
Person_1 ID | Person_1 Name | Scholarship_1 ID | Scholarship 1 Name
Person_1 ID | Person_1 Name | Scholarship_2 ID | Scholarship 2 Name
Person_2 ID | Person_2 Name | Scholarship_3 ID | Scholarship 3 Name

I would like it to look like:
Person_1 ID | Person_1 Name | Scholarship_1 ID | Scholarship_1 Name | Scholarship_2 ID | Scholarship_2 Name
Person_2 ID | Person_2 Name | Scholarship_3 ID | Scholarship_3 Name

Is this possible in CRXI?

 

[kray4660]

The only way I know how to to that is with using a formula to concatenate the Scholarship_ID and Scholarship_Name into a long string. Thus you will need three formulas and a group (by Person ID). The first formula will go in the group header and just contain the reset formula (i.e., Shared stringVar somestring := '', then the second formula will go in the details (which will be hidden) and look something like this

i.e.
Shared stringVar somestring;
somestring := somestring + ' ' + {ScholarshipID} + ' ' + {ScholarshipName}

then in the group footer (where the other information will also go), the third formula will look like this ( Shared stringVar somestring; )

Of course replace the field names above with your field names.