locked
Need help with chart RRS feed

  • Question

  • Hi there,

    I'd like to ask how to approach a chart layout when I have the following table:

    |--------------------------------------------------------|
    |[Client Name] | [March 2008] | [April 2008] | [May 2008]|

    | Client 1     |
      200         | 100          | 500       |
    | Client 2     |  150         | 600          | 300       |
    | Client 3     |  540         | 102          | 256       |
    |--------------------------------------------------------|

    And I would like the table to be like the one below:

    It seems to me that I have to do some sort of pivot with my dataset/query before I could use it for the chart. Any ideas would be highly appreciated. I really need help with this. Thanks in advanced!

    Regards,
    Ver
    Monday, February 18, 2008 2:14 AM

Answers

  • For chart, I think you need create an additional dataset by using unpivot function in your SQL query and the dataset output should look like this:

    Client Name        Month                 Values

      Client 1         March 2008              200

      Client 1         April 2008                 100

     

     

    Anyway, if you have any problem with unpivot function, please let me know and past your orginal SQL query.

    Monday, February 18, 2008 9:37 PM

All replies

  • Oops... looks like the chart image has been blocked. Here is the link to the chart image that I am aiming for:

    http://img.photobucket.com/albums/v423/vaj/chartsample.gif

    Thanks everyone!
    Monday, February 18, 2008 2:16 AM
  • For chart, I think you need create an additional dataset by using unpivot function in your SQL query and the dataset output should look like this:

    Client Name        Month                 Values

      Client 1         March 2008              200

      Client 1         April 2008                 100

     

     

    Anyway, if you have any problem with unpivot function, please let me know and past your orginal SQL query.

    Monday, February 18, 2008 9:37 PM