OraFAQ Forum: Reports & Discoverer » Calling Report from Form asking enter Password

Home » Developer & Programmer » Reports & Discoverer » Calling Report from Form asking enter Password (Form 6i.Reports 6i)

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

Calling Report from Form asking enter Password [message #484152]

Sun, 28 November 2010 06:31

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?

Report message to a moderator

Re: Calling Report from Form asking enter Password [message #484158 is a reply to message #484152]

Sun, 28 November 2010 08:03

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Can you share your code which you write behind the button ?

Report message to a moderator

Re: Calling Report from Form asking enter Password [message #484163 is a reply to message #484158]

Sun, 28 November 2010 09:15

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;

Report message to a moderator

Re: Calling Report from Form asking enter Password [message #484202 is a reply to message #484163]

Mon, 29 November 2010 00:44

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

Report message to a moderator

Re: Calling Report from Form asking enter Password [message #484205 is a reply to message #484202]

Mon, 29 November 2010 01:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

@Irfan, where exactly did YOU indent the code?

Report message to a moderator

Re: Calling Report from Form asking enter Password [message #484407 is a reply to message #484205]

Tue, 30 November 2010 06:44

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 10:09:46 CST 2024