Hi, i have a select that returns this:
Date Product1, Product2, Product3, Code
2014-02-20 , 0 , 1 ,2 ,50
2014-02-21 , 4 , 8 ,1 ,50
2014-02-22 , 1 , 5 ,2 ,50
2014-02-20 , 1 , 1 ,6 ,51
2014-02-21 , 0 , 2 ,2 ,51
and i want a linechart per each group of codes (in this case i want 2 charts), my problem is that I get 5 linecharts (3 equals charts for the first code and 2 equals charts for the second code)
this happens if I put the chart into the details band, if I put the chart into the pageHeader band I get an empty chart.
Please, help!