Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Crystal Reports XI Row to Column

Crystal Reports XI Row to Column

Crystal Reports XI Row to Column

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?

RE: Crystal Reports XI Row to Column

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

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close