How to build a Line chart from a crosstab data source? RRS feed

  • Question

  • I've been going through the tutorials and can't find what I'm looking. I hope someone can point me in the right direction.


    I'm trying to build a line chart based on a dataset that consist of the following fields:




    week3 ... week28


    Data source will have 4 records with funnelcode values of "Above, Middle, Low, and  below".  Each record containing values in the week fields.


    So I'm trying to define the X axis labels to coordinate with the week fields, but having no luck.


    Is this going to be doable, or do I need to normalize this table?



    Thursday, July 12, 2007 5:50 PM

All replies

  • bump...could use some help still
    Tuesday, July 24, 2007 7:38 PM
  • Would I be better off trying to normalize the data into a temp table?


    Thursday, July 26, 2007 7:23 PM
  • I think that you should not use crosstab data source.
    Your dataset should consist this following fields :

    So in your chart properties, on the data tab:
     Values ->use Values
     Category Group->use WeekName field
     Series Group -> use FunnelcodeValue field

    Then the report will create it self.

    Please tell me that this work.

    Monday, July 30, 2007 10:27 AM