Results 1 to 1 of 1

Thread: Display sql columns horizontal?

Threaded View

  1. Jun 13th, 2007, 07:23 PM #1
    VBjunkie
    VBjunkie is offline

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Posts
    137

    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?
    Last edited by VBjunkie; Jun 13th, 2007 at 07:26 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width