[charts][summary] - need help !

[jbeausse]

Hi all,

I'm currently facing a design problem regarding charts.
Imagine this simple data structure representing sales in value/volume of ranges/product among zones/countries :

LIB_YEAR LIB_GAMME LIB_PDT LIB_ZONE LIB_PAYS VENTES VOLUMES
2001 Gamme A Product A Europe Suisse 157 1222
2001 Gamme A Product A USA Etats Unis 341 2602
2001 Gamme A Product A Europe France 650 2738
2001 Gamme A Product A Europe Suisse 664 5796
2001 Gamme B Product B USA Etats Unis 169 1104
2001 Gamme B Product B Europe France 1165 1014
2001 Gamme B Product B Europe France 1680 15750
etc.

I want to generate a report with the following structure :

Group 1 : Year 2001

• 
  
• Group 2 : Gamme A
  • Data Table for Gamme A
    
  • Chart for current Gamme A
  • [/ul]
    
    
  • Group 2 : Gamme B
    • Data Table for Gamme B
      
    • Chart for current Gamme B
    • [/ul]
      
      [/ul]
      
      Summary :
      A bar chart representing sales per year/gamme (see image in attachment) :
      - Values = sales
      - Categories = year
      - Series = gammes
      
      My problem is in the summary chart definition : I can't find out how to define custom variables allowing
      me to sum data correctly ! (you will notice that the sort order for my groups and summary chart is a priori different).
      
      I join an attachment containing an XLS file + current jrxml and report generated.
      Thn'x in advance for your help !
      
      Julien, France
      
      PS : I use a custom datasource and on-the-fly JRXML generation
      Post edited by: jbeausse, at: 2006/12/15 15:29

[jbeausse]

Here is the attachment... [file name=pb_graphe_summary.zip size=65011]

[jbeausse]

Here are 2 screenshots of the generated PDF : body and summary [file name=pdf_fragments.zip size=85404]

[jbeausse]

Do you have any idea about this topic please ??