OraFAQ Forum: Forms » passing values from oracle forms to oracle reports

Home » Developer & Programmer » Forms » passing values from oracle forms to oracle reports

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

passing values from oracle forms to oracle reports [message #157194]

Tue, 31 January 2006 23:10

cumars
Messages: 16
Registered: October 2005

Junior Member

hi friends,

how to pass the values from oracle froms to oracle reports?. please help.

cumars.

Report message to a moderator

Re: passing values from oracle forms to oracle reports [message #157196 is a reply to message #157194]

Tue, 31 January 2006 23:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Search this forum for 'pass forms reports'. There are numerous answers.

David

[Updated on: Tue, 31 January 2006 23:32]

Report message to a moderator

Re: passing values from oracle forms to oracle reports [message #157212 is a reply to message #157194]

Wed, 01 February 2006 01:39

cumars
Messages: 16
Registered: October 2005

Junior Member

hi friends,

I will explain my question clearly. I am using oracle forms and reports. I am storing a value in a variable in the forms. I want to get that value in the reports.

please help

Report message to a moderator

Re: passing values from oracle forms to oracle reports [message #157462 is a reply to message #157212]

Thu, 02 February 2006 09:19

mail2me
Messages: 5
Registered: February 2006

Junior Member

hi
have u tried creating parameter list
if not then try creating it
this is one of the same code we are using

DECLARE
pl_id ParamList;
pl_name VARCHAR2(10) := 'Temp';

BEGIN

--Create Parameter List With Name 'TEMP'
pl_id := Get_Parameter_List(pl_name);

IF Id_Null(pl_id) THEN
pl_id := Create_Parameter_List(pl_name);
IF Id_Null(pl_id) THEN
Message('Error creating parameter list '||pl_name);
RAISE Form_Trigger_Failure;
END IF;
ELSE
Message('Clear the screen,to run the report again!');
RAISE Form_Trigger_Failure;
END IF;

pl_id := Get_Parameter_List('Temp');

-- Adding Parameters Runtime

IF NOT Id_Null(pl_id) THEN

Add_Parameter(pl_id,'ENT_ID',TEXT_PARAMETER,:REPORT.NBT_ENT_ID);
Add_Parameter(pl_id,'INPUT_DATE',TEXT_PARAMETER,to_char(:REPORT.NBT_INPUT_DT,'DD-MON-YYYY'));

--running the report
Run_Product(REPORTS, 'C:\Reports\client.rdf', ASYNCHRONOUS, RUNTIME,FILESYSTEM,'Temp');
clear_form;
Destroy_Parameter_List(pl_id);
END IF

the parameters you have to create in report

Report message to a moderator

Previous Topic:	how to fetch previous record values into next record
Next Topic:	menu

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:48:27 CDT 2024