please help me out with graphs

[reddyogili]

hi in line chart i need to pass a formulae(@impact) in the datatab show values box.

i have 5 impacts in my table. NODE, MANAGER AND DATE

Impact1 Impact2 Impact3 Impact4 Impact5 NODE
0 50 300 100 45 jmon
200 400 35 55 1500 pacifi
45 200 350 400 700 xsi

600 300 450 450 300 abc

1000 250 300 50 400 edig

45 450 0 50 350 xyz


this formulae should be based on parameter. i mean once we refresh the report {?impact} parameter should prompt for impacts. i should be on my yaxis and generate the graph. i am able to do this with one impact. for this the formulae i am using is below. this is generating a perfect single line curve.

//{@Impact}:
if {?Impact} = 1.0 then {NETCOOL_HISTORY.IMPACT1} else
if {?Impact} = 2.0 then {NETCOOL_HISTORY.IMPACT2} else
if {?Impact} = 3.0 then {NETCOOL_HISTORY.IMPACT3} else
if {?Impact} = 4.0 then {NETCOOL_HISTORY.IMPACT4} else
if {?Impact} = 5.0 then {NETCOOL_HISTORY.IMPACT5}

how will i do the same thing for multiple impacts. What i mean is if the user wants to select impact3,impact4,impact5,once we refresh the report , by which he wants to see 3 lines with different colors on the chart, how can i do that.


my chart should look like this

1000 ' '
''' '' ' '
'' ' ' ' ' '
700 '' ' ' ' ' '
'' ' ' ' '' ' '
500 '' ' ' ' ' ' ' ' ' '
'' ' ' ' ' ' ' ' ' ' '
300 '' '' ' ' '' ' ' ' '
'' '' ' ' ' ' '' ' '
200 '' '' ' ' ' ' ' '' ' '
'' ' ' ' ' ' ' ' ' ' ' '
100 ''' ' '' ' ' ' ' ' '
0 '----------------------------------------------------
date ranges

---- impact3 ---impact4 ---impact5
i am placing my graph once per report and for each record(date) and show fileds(@impact)

BASICALLY MY GRAPH WILL BE BASED ON ONE NODE,ONE MANAGER, SPECIFIC DATE RANGE AND ON MULTIPLE IMPACTS(THESE IMPACTS I SHOULD PASS USING PARAMETER). so i created a formulae and called this parameter into it.it works for single graph but for multiple lines?????

please some one help me out..

thanks in advance,
reddy.