how to generate 2 lines in line graphs?

[mrssnowy123]

Hiie, im new to iReport and i need to do this task.

I have information that i need to display onto the line graph by having 2 lines.

one line is for Year07/08 and the other line for Year08/09.

so its actually an overlap line graph, but i have to show them into 2 different seperate lines. How do i do that?

Has it got to do with SQL statements?

This is the SQL i have:

select

day,case when sum(complaint)>0

then

sum(compliment)/sum(complaint) else 0 end) as 'cnt'

from

(

select

day(case_date) as day,

'compliment'

when

=case feedback_type='COMPLIMENT' then 1

else

0 end ,

'complaint'

when

=case feedback_type='COMPLAINT'

and

ltrim(rtrim(merit))<>''

and

cast(ltrim(rtrim(merit)) as int) < 0 then 1

else

from

0 end view_report_main

where

case_date

between

'01-dec-08'

and

'31-dec-08') k

group

by day

 I would appreciate any help. Thanks in advanced! =)

(