PDF GENERATION ISSUE [message #310135] |
Mon, 31 March 2008 06:53  |
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   |
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 #310351 is a reply to message #310303] |
Tue, 01 April 2008 00:39   |
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  |
 |
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
|
|
|