Home » Developer & Programmer » Forms » PDF GENERATION ISSUE
PDF GENERATION ISSUE [message #310135] Mon, 31 March 2008 06:53 Go to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
HI ALL
I DISPLAY THE DATA OF MY REPORTS IN PDF FORMAT FROM MY FORMS , MY CODE IS WORKING ALRIGHT. AND PDF FILE IS BEING LOADED THE WAY I WANT.
HERE IS THE CODE
DECLARE
	
	PL_ID   ParamList;
	PL_NAME VARCHAR2(10) := 'PARAM1';
	APPID   PLS_INTEGER ;
	
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, 'DESTYPE',   TEXT_PARAMETER, 'FILE');
  ADD_PARAMETER (PL_ID, 'DESFORMAT', TEXT_PARAMETER, 'PDF');
  ADD_PARAMETER (PL_ID, 'DESNAME',   TEXT_PARAMETER, 'D:\FORMS\EMPREP1.PDF'); 
  Run_Product(REPORTS, 'D:\FORMS\EMPREP.RDF', SYNCHRONOUS, RUNTIME,FILESYSTEM,PL_ID,NULL);
    
  HOST('[COLOR=orange]C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.EXE[/COLOR]'  D:\FORMS\EMPREP.PDF');
  
    
END ;
.
THE ISSUE IS WITH THE COLORED CODE.
I HAVE TO GIVE THE PATH OF EXE FILE OF ADOBE READER , BUT MY USER MAY HAVE ITS ACROBAT INSTALLED AT ANY LOCATION , OR MAY HAVE ANY VERSION.
SO CAN ANY BODY TELL ME THE CODE , TO FIND THE PATH, WHERE ACROBAT IS INSTALLED , DYNAMICALLY , OR CAN ANYONE PROVIDE ANY OTHER SOLUTION.
THANX IN ADVANCE
Re: PDF GENERATION ISSUE [message #310182 is a reply to message #310135] Mon, 31 March 2008 08:57 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Here is something we are using, maybe it can help you.


We are using windows library instead so no path to code for the application and it will use the adobe plugin from Internet explorer

host('rundll32 url.dll,FileProtocolHandler c:\test.pdf');




hope it help
Re: PDF GENERATION ISSUE [message #310303 is a reply to message #310135] Mon, 31 March 2008 20:11 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'web.show_document pdf'.

David
Re: PDF GENERATION ISSUE [message #310351 is a reply to message #310303] Tue, 01 April 2008 00:39 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
WELL ,DJ MARTIN
im am using forms 6i. so I THINK web.show_document will not help .i think.
and "KAELAUN" thanks.
the code u sent is working on the local machine alright , i will have a requirement to deploy it on remote machine soon so i will let u know about the outcome , thanks a lot once again.

REGARDS
IMTIAZ

[Updated on: Tue, 01 April 2008 00:41]

Report message to a moderator

Re: PDF GENERATION ISSUE [message #310359 is a reply to message #310351] Tue, 01 April 2008 00:49 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
WELL, IMTIAZ

If you had the decency to say what version you used I wouldn't have wasted my time writing something that so obviously wasted yours.

Blow it out your ...

David
Previous Topic: 'srw.do_sql' must be declared
Next Topic: integration forms and reports
Goto Forum:
  


Current Time: Fri Sep 27 10:32:16 CDT 2024