Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

passing parameters from forms to reports

Status
Not open for further replies.

mriou

Programmer
Jun 28, 2001
4
TN
i made an text-item in forms to enter a interrogation(code for example), i would to pass this parameter to report in order to see then informations concerning this code. the problem is :report don't read the parameter transfering from forms, it dosn't display the result.
if i run reports only i have a result.
plz help me, it's important
 
run_product (Reports, '<report_name>', Synchronous, runtime, filesystem, ' ', null);

the above is the proper way to call the report...
now you can build a paramter list and pass it.
declare
p1 = PARAMLIST;
begin
p1 := GET_PARAMTER_LIST ('xxx');

if not id_null (p1) then
destroy_paramter_list (p1);
end if;
p1 := Create_paramter_list ('xxx');
add_paramter (p1, 'YYYY', TEXT_PARAMETER, '1');

YYYY is the value you want to pass, calling the run product replace null with p1....
it should work
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top