Home » Developer & Programmer » Reports & Discoverer » Calling Report from Form asking enter Password (Form 6i.Reports 6i)
Calling Report from Form asking enter Password [message #484152] Sun, 28 November 2010 06:31 Go to next message
harshkumar79gmailcom
Messages: 2
Registered: November 2010
Junior Member
I am calling a report from Form 6i by using RUN_PRODUCT.After pressing the call button from Form 6i, report is showing box for enterning user id and password.

Anybody help me on it.Why it is showing like this?
Re: Calling Report from Form asking enter Password [message #484158 is a reply to message #484152] Sun, 28 November 2010 08:03 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Can you share your code which you write behind the button ?
Re: Calling Report from Form asking enter Password [message #484163 is a reply to message #484158] Sun, 28 November 2010 09:15 Go to previous messageGo to next message
harshkumar79gmailcom
Messages: 2
Registered: November 2010
Junior Member
Hi, here is code i am using
PROCEDURE print_report IS
pl_id ParamList;
pl_name varchar2(20):='print';
BEGIN
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;
end if;
add_Parameter(pl_id,'EMI_REF_NO',DATA_PARAMETER,8);
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Run_Product(REPORTS,'D:\Finapp_beta\bin\print.rdf',ASYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id, NULL);

end;
Re: Calling Report from Form asking enter Password [message #484202 is a reply to message #484163] Mon, 29 November 2010 00:44 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,

As a sample Please write this code behind the button and check it.

DECLARE
pl_id   ParamList; 
pl_name VARCHAR2(50) :='tempdata';
Begin
pl_id := Get_Parameter_List(pl_name); 
IF NOT Id_Null(pl_id) THEN 
Destroy_Parameter_List(pl_id); 
END IF; 
pl_id := Create_Parameter_List(pl_name);   		    
Add_Parameter(pl_id,'pono',TEXT_PARAMETER,:PO_header.po_no); 
Add_Parameter(pl_id,'destype',TEXT_PARAMETER,'preview'); 

Run_Product(REPORTS, 'C:\Irfan_Test280509\PO.REP', SYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id,Null);		     	   		     	  
end;  



Please Also read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards,

Irfan
Re: Calling Report from Form asking enter Password [message #484205 is a reply to message #484202] Mon, 29 November 2010 01:00 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@Irfan, where exactly did YOU indent the code?
Re: Calling Report from Form asking enter Password [message #484407 is a reply to message #484205] Tue, 30 November 2010 06:44 Go to previous message
mehediu
Messages: 46
Registered: February 2010
Location: Dhaka
Member

Sir ,
Is your problem solved ?

i use the following code , you can check that out
Declare
		P	Paramlist;
		V_WHR VARCHAR2(300);
Begin

 	--Report Parameters
 		
		P:=Create_Parameter_List('P');
		Add_Parameter(P,'BRCOD',Text_Parameter,:parameter.p_brcod);
		
		Add_Parameter(P,'Maximize',Text_Parameter,'Yes');
		Add_Parameter(P,'Paramform',Text_Parameter,'NO');
		Add_Parameter(P,'Oracle_Shutdown',Text_Parameter,'Yes');
		
		Run_Product(reports,'C:\Pblibs\Fex\Reports\Rfx_Client_Performance.rep',Synchronous,Runtime,Filesystem,'P','');
			
		Destroy_Parameter_List(P);						

--Error Exception
	Exception 
		When Others Then
		Message(Sqlerrm);			
		Message(Sqlerrm);			
		Raise Form_Trigger_Failure;
End;





Thanks
Previous Topic: Exclude 1 Group in Report
Next Topic: Oracle Report 10g (2 Merged)
Goto Forum:
  


Current Time: Thu Mar 28 08:46:14 CDT 2024