Home » Developer & Programmer » Reports & Discoverer » convert oracle report to pdf..
convert oracle report to pdf.. [message #584596] Wed, 15 May 2013 23:57 Go to next message
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
Junior Member
what is the code for converting oracle reports to pdf.
Re: convert oracle report to pdf.. [message #584600 is a reply to message #584596] Thu, 16 May 2013 01:05 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which Reports version do you use?

Because, there's no "code" ... Report parameters should be correctly set, such as
- DESTYPE = File
- DESFORMAT = PDF
Re: convert oracle report to pdf.. [message #584622 is a reply to message #584600] Thu, 16 May 2013 06:46 Go to previous messageGo to next message
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
Junior Member
i am using reports 6i with 9i database.
Re: convert oracle report to pdf.. [message #584623 is a reply to message #584622] Thu, 16 May 2013 06:52 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
And have you tried what littlefoot suggested?
Re: convert oracle report to pdf.. [message #584702 is a reply to message #584623] Fri, 17 May 2013 00:01 Go to previous messageGo to next message
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
Junior Member
yes i hve tried that ,but i want to attach one button on my report
and after clicking that button the report automatically convert to pdf
Re: convert oracle report to pdf.. [message #584712 is a reply to message #584702] Fri, 17 May 2013 01:05 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try to create a drill-down report which would call itself, just with different DES* parameters.
Re: convert oracle report to pdf.. [message #584715 is a reply to message #584712] Fri, 17 May 2013 01:25 Go to previous messageGo to next message
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
Junior Member
i need a code behind that button so that after clicking that it automaticaaly convert to pdf.
Re: convert oracle report to pdf.. [message #584717 is a reply to message #584715] Fri, 17 May 2013 01:43 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't have it; hopefully, someone else will be able to assist.

Meanwhile, I'd suggest you to research "drill down oracle report 6i" (hint: use Google).
Re: convert oracle report to pdf.. [message #584817 is a reply to message #584717] Sat, 18 May 2013 02:06 Go to previous messageGo to next message
vippysharma
Messages: 73
Registered: May 2013
Location: www
Member
hi littlefoot,
As u suggested Report parameters should be correctly set as
- DESTYPE = File
- DESFORMAT = pdf
Its working but can u please tell me how can i change my destination folder.
By default my pdf file saved into c:/orant/bin/report_name , i want to change this path and also after every execution, printer pop up is raised up and if i submitted (accept) that printer command the pdf file generated else nothing happens.

Regards
Viplove Sharma
Re: convert oracle report to pdf.. [message #584818 is a reply to message #584817] Sat, 18 May 2013 02:25 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use DESNAME parameter; set it to a directory which is supposed to contain output files.
Re: convert oracle report to pdf.. [message #584819 is a reply to message #584818] Sat, 18 May 2013 02:47 Go to previous messageGo to next message
vippysharma
Messages: 73
Registered: May 2013
Location: www
Member
using DESNAME file name is changing not the path.
Re: convert oracle report to pdf.. [message #584826 is a reply to message #584819] Sat, 18 May 2013 11:06 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is it?

Oracle Reports Reference (Release 6i), page 469:
Oracle

Full pathnames are supported for all file references (e.g., desname=/revenues/q1/nwsales).


Oracle Technology Reports forum discussion:
Quote:

If i am giving the absolute path like

DESNAME := 'D:\OraHome_2\reports\Project_One\'||:filename;

it is working fine.
Previous Topic: How to convert exponential number into pure number while writing on excel using report builder
Next Topic: Special characters coming in Text output format of Oracle reports
Goto Forum:
  


Current Time: Thu Mar 28 12:43:00 CDT 2024