Display sql columns horizontal?

I'm using a sql stored procedure to populate a crystal report. I want to have some of the values displayed horizontally based on whatever grouping i choose. The data from the stored procedure looks something like this:

Name Make Model rating category(multiple categories/ratings)
charger dodge rt 5 4
charger dodge sxt 6 5
mustang ford cobra 6 3


I'm trying to accomplish the following in crystal:

Make:dodge(grouping 1)
model:rt(grouping 2)
category4 category5 total
charger 6 5(ratings) 11(rating total)
charger 4 2 6

make:ford " "
model:mustang " "

total 10 7 27


I've been playing around with the groupings but cannot produce the correct results. Do I have to use a cross tab? any ideas?