| how to pass two parameter for graphs from form (merged by CM) [message #446134] |
Fri, 05 March 2010 10:31  |
mohaninforakle
Messages: 55
Registered: January 2009
|
Member |
|
|
hai friends,
i had a chart developed by graphics builder in which I am passing one parameter(ie year) and displaying the chart.Now i want to pass two parameter into chart.How to do this here i have attached my chart view and procedure which executes and display the chart from forms.
coding when button pressed
PROCEDURE CHART_DISPLAY IS
pl_id ParamList;
pl_name VARCHAR2(100) := 'tempdata';
BEGIN
pl_id := Get_Parameter_List(pl_name);
IF not Id_Null(pl_id) THEN
destroy_parameter_list(pl_id);
end if;
pl_id := Create_Parameter_List(pl_name);
/* Now add a parameter to pass to graphics*/
Add_Parameter(pl_id,'PYEAR',TEXT_PARAMETER,'2009');
/*if need more parameters, use more Add_parameter to list*/
/*now, call the graphics sal.ogd file to show on especified chart_area and with a parameter list*/
OG.open(C:\CHART\SALES_TREND.OGD','CHART.SALES_CHART',FALSE,TRUE,pl_id);
OG.close('C:\CHART\SALES_TREND.OGD','CHART.SALES_CHART');
END;
In the above procedure i had one parameter directly am passing value of year '2009' now i want to pass two parameter like between 'year1' and 'year2' for getting chart between two years.
Please somebody help me on this.
Am waiting for your reply.
thanks in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
