Home » Developer & Programmer » Reports & Discoverer » reports
reports [message #89474] Wed, 14 April 2004 18:32 Go to next message
ARSHAD
Messages: 5
Registered: April 2004
Junior Member
hi its the message can anybody guide me about parameters used in oracle reprots waiting for good responses
khan
Re: reports [message #89475 is a reply to message #89474] Thu, 15 April 2004 01:40 Go to previous message
Riaz
Messages: 112
Registered: February 2002
Senior Member
create a parameter, add parameters to it.This 
procedure is used to pass parameters from Forms6i to 
Reports.

 
 
 
Trigger name:	when-button-pressed 
 
 
declare 
	cr_param paramlist; 
begin 
 
 cr_param := create_parameter_list('CREATEP'); 
 add_parameter(cr_param,'reg_pass',text_parameter, 
:gp.regno); 

 RUN_PRODUCT(REPORTS,'e:riaze_rzit_rept', 
ASYNCHRONOUS,RUNTIME,FILESYSTEM,CR_PARAM,NULL); 
 destroy_parameter_list(cr_param); 
end 
 
 
 
 
Report's Query 
 
Select * from it where rn=:reg_pass

hope it helps...
Previous Topic: summarry problem
Next Topic: open more than one report at a time
Goto Forum:
  


Current Time: Fri Mar 29 02:31:43 CDT 2024