Rows To Columns

[zigstick]

Hello, using Crystal Reports 2000 and am struggling with what seems should be simple but isn't. I've seen other related threads but none seem to aptly apply.

I have rows of records for a particular ticket number such as below, only more of them.

TICKET# REQ VALUE NAME REQ VALUE
32228 Application Process Management
32228 Client_Name Acme Corp
32228 Type_of_Request Bug

How can I get these rows into a column for each ticket number
Ex:
Ticket Application Client_Name Type_of_Request
32228 Process Management Acme Corp Bug

Thanks for any help!!!

 

[hilfy]

You need to look at using a cross tab for this. Here's how I would configure it in the Cross-Tab Expert:

On the Cross-Tab Tab
Rows: Ticket number
Columns: Req Value Name
Summarized Fields: Max of Req Value (yes, you can get the max of a string!)

On the Customize Tab
Turn on "Suppress Row Grand Totals" and "Suppress Column Grand Totals"

This will only work correctly if you have only one of any value in Req Value Name for any given ticket.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com