urgent Line Chart help needed

[2006 IR Open Dicussion]

By: Dawood - muhammed_dawood

urgent Line Chart help needed

2006-04-11 22:55

Hi,

I have a datasource with the following data:

 

Product_Name Product_ID Type Quarter_1 Quarter_2 Quarter_3 Quarter_4

Alphasone 20mg Tablet 54467-0244-10 100s NFAMP 52.13 52.43 52.73 53.11

Alphasone 20mg Tablet 54467-0244-25 250s NFAMP 128.78 128.19 128.03 129.21

Alphasone 20mg Tablet 54467-0244-25 1000s NFAMP 493.92 493.64 493.44 494.56

Betamax 100mg Tablets 54467-0390-10 100s NFAMP 18.43 18.92 18.86 19.23

Betamax 100mg Tablets 54467-0390-10 250s NFAMP 44.21 44.31 44.3 44.76

Betamax 100mg Tablets 54467-0390-10 1000s NFAMP 182.13 183.59 183.48 184.29

 

I want to draw a line chart using jasper reports which gives the following information for a particular product_name say "Alphasone 20mg Tablet"

 

on X-Axis all the quarters Quarter_1, Quarter_2, Quarter_3, Quarter_4.

On Y-Axis value per Quarter for a product_id

 

I have no idea how to pass this data from datasource to line chart somebody please help me in solving the above problem. it is pretty urgent.

 

Thanks in advance.

 

with Regards,

Dawood