OraFAQ Forum: Reports & Discoverer » convert oracle report to pdf..

Home » Developer & Programmer » Reports & Discoverer » convert oracle report to pdf..

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

convert oracle report to pdf.. [message #584596]

Wed, 15 May 2013 23:57

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

what is the code for converting oracle reports to pdf.

Report message to a moderator

Re: convert oracle report to pdf.. [message #584600 is a reply to message #584596]

Thu, 16 May 2013 01:05

Littlefoot
Messages: 21826
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

Report message to a moderator

Re: convert oracle report to pdf.. [message #584622 is a reply to message #584600]

Thu, 16 May 2013 06:46

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

i am using reports 6i with 9i database.

Report message to a moderator

Re: convert oracle report to pdf.. [message #584623 is a reply to message #584622]

Thu, 16 May 2013 06:52

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

And have you tried what littlefoot suggested?

Report message to a moderator

Re: convert oracle report to pdf.. [message #584702 is a reply to message #584623]

Fri, 17 May 2013 00:01

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

Report message to a moderator

Re: convert oracle report to pdf.. [message #584712 is a reply to message #584702]

Fri, 17 May 2013 01:05

Littlefoot
Messages: 21826
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.

Report message to a moderator

Re: convert oracle report to pdf.. [message #584715 is a reply to message #584712]

Fri, 17 May 2013 01:25

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.

Report message to a moderator

Re: convert oracle report to pdf.. [message #584717 is a reply to message #584715]

Fri, 17 May 2013 01:43

Littlefoot
Messages: 21826
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).

Report message to a moderator

Re: convert oracle report to pdf.. [message #584817 is a reply to message #584717]

Sat, 18 May 2013 02:06

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

Report message to a moderator

Re: convert oracle report to pdf.. [message #584818 is a reply to message #584817]

Sat, 18 May 2013 02:25

Littlefoot
Messages: 21826
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.

Report message to a moderator

Re: convert oracle report to pdf.. [message #584819 is a reply to message #584818]

Sat, 18 May 2013 02:47

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

using DESNAME file name is changing not the path.

Report message to a moderator

Re: convert oracle report to pdf.. [message #584826 is a reply to message #584819]

Sat, 18 May 2013 11:06

Littlefoot
Messages: 21826
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 02 08:29:47 CDT 2026