Home » Developer & Programmer » Forms » passing parameter to report from texts on form by using menu item in menu toolbar
passing parameter to report from texts on form by using menu item in menu toolbar [message #81777] Thu, 20 March 2003 00:54 Go to next message
poy
Messages: 9
Registered: February 2003
Junior Member
hi friends;

i want to pass parameters to my report using some texts
on my form using menu item in my menu toolbar,please help me?

note:
1- the menu dose not see the texts on the form.
2- i prepare parameters in my report to receive variables
from the texts on the form.

thanks
Re: passing parameter to report from texts on form by using menu item in menu toolbar [message #81796 is a reply to message #81777] Mon, 24 March 2003 01:28 Go to previous message
waris
Messages: 115
Registered: November 2001
Senior Member
THis is the code to be written in ur Menu Code :

declare
pl_id ParamList;
begin

pl_id :=Get_Parameter_List('tmpdata');

IF NOT id_null(pl_id) THEN
Destroy_Parameter_List(pl_id);
END IF;

pl_id:=Create_Parameter_List('tmpdata');

/* Here the ur block name and text item name should be in NAME_IN function */

Add_Parameter(pl_id,'LISTPATH',TEXT_PARAMETER,NAME_IN('blockname.tex_item_name'));

run_product(REPORTS,:global.report_path||'abrepins',SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id,NULL);

end;

Cheers
waris
Previous Topic: Vdio
Next Topic: Re: Very Very Urgent --Report Printing
Goto Forum:
  


Current Time: Thu Mar 28 14:24:51 CDT 2024