OraFAQ Forum: Forms » passing parameters

Home » Developer & Programmer » Forms » passing parameters (Reports 6i windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

passing parameters [message #516720]

Wed, 20 July 2011 04:38

jo28
Messages: 1
Registered: July 2011

Junior Member

Hi,

In my application (forms6i) initially data will be displayed in a non-database block after a lot of calculations and validations
which is time consuming.

Now, if the user want to print it as a report, we store the displayed data in a dummy table and run the report using that dummy table and then delete records from it.

Is it possilbe to pass the records displayed to the report as a parameter so that I can avoid un-necessary add/delete records?

Please help

Report message to a moderator

Re: passing parameters [message #516922 is a reply to message #516720]

Thu, 21 July 2011 07:49

yeahia
Messages: 22
Registered: June 2010
Location: Bangladesh

Junior Member

you can pass the filed as parameter but not the record. you can try with this:

PROCEDURE Print_Report IS
	opt varchar2(200);
  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'); 
  opt:='\\Reports\NFD_Production.REP';
  Add_Parameter(pl_id,'date_from',TEXT_PARAMETER,:date_range.date_from);
  Add_Parameter(pl_id,'date_to',TEXT_PARAMETER,:date_range.date_to);
  Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
  Add_Parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'SCREEN');
  Run_Product(REPORTS, opt, SYNCHRONOUS, RUNTIME, 
             FILESYSTEM, pl_id, NULL); 
END;

yeahia

Report message to a moderator

Previous Topic:	Mail using OLE2 Backage
Next Topic:	Need a D2k Project

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 23:06:32 CDT 2024