Home » Developer & Programmer » Application Express & MOD_PLSQL » Error in generating pdf report. (Oracle 11g R2.)
Error in generating pdf report. [message #551840] Sat, 21 April 2012 06:09 Go to next message
chintan.patel
Messages: 131
Registered: July 2008
Location: Ahmedabad
Senior Member
Hi Friends

I am using apex 3.2 on oracle 11g R2. Now I want to generate report in pdf format. so i tried report query & select output format pdf but it gives beloww error
ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.


Both the following Scripts run successfully without any error though above error comes.

1 Granting Connect Privileges to a Host
2 Granting Connect Privileges to a Local Host

Please Suggest me the way.

Chintan
Re: Error in generating pdf report. [message #551903 is a reply to message #551840] Sun, 22 April 2012 04:15 Go to previous messageGo to next message
Littlefoot
Messages: 19345
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
7. Enabling Network Services in Oracle Database 11g might be worth reading.
Re: Error in generating pdf report. [message #552057 is a reply to message #551903] Mon, 23 April 2012 06:31 Go to previous messageGo to next message
chintan.patel
Messages: 131
Registered: July 2008
Location: Ahmedabad
Senior Member
Thanks

I had read from your link that i have to "Installing and Configuring Apache FOP" for generating pdf. they suggest to deploy fop.war using application server console. my problem is that, i have only database server, how can i deploy "fop.war" without application server. i would like to give some more information, i am using apex 3.2 on oracle 11g R2 by embedded pl/sql getway.

Chintan

[Updated on: Mon, 23 April 2012 06:56]

Report message to a moderator

Re: Error in generating pdf report. [message #552124 is a reply to message #552057] Mon, 23 April 2012 11:50 Go to previous messageGo to next message
Littlefoot
Messages: 19345
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What I did was to use Apex + Apache Tomcat + iReport.

Follow (and research) these instructions:
Carl Backstrom's Blog: Apex + Cocoon = PDF
Video

Apex PDFs are ugly. Therefore, I integrated iReport & Apex in order to create beautiful reports.

iReport
Integration software
Re: Error in generating pdf report. [message #552151 is a reply to message #552124] Mon, 23 April 2012 23:58 Go to previous messageGo to next message
chintan.patel
Messages: 131
Registered: July 2008
Location: Ahmedabad
Senior Member
Thanks

I will work on it then let you know.

Chintan
Re: Error in generating pdf report. [message #552174 is a reply to message #552124] Tue, 24 April 2012 02:12 Go to previous messageGo to next message
chintan.patel
Messages: 131
Registered: July 2008
Location: Ahmedabad
Senior Member
Thanks

As you say I read and follow the instructions of
"Carl Backstrom's Blog: Apex + Cocoon = PDF" & "Video", Its works.
Its generate only list to print reports (SQL Reports), i have to generate customized formatted reports. i am herewith attached sample formats, please check it and suggest me that its possible in apex or i have to use some other report printing software to generate reports in excel, word, pdf etc.

Regards
Chintan
Re: Error in generating pdf report. [message #552175 is a reply to message #552174] Tue, 24 April 2012 02:19 Go to previous messageGo to next message
Littlefoot
Messages: 19345
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You should have read the rest of my previous message (starting with "Apex PDFs are ugly ...").
Re: Error in generating pdf report. [message #552340 is a reply to message #552175] Wed, 25 April 2012 03:23 Go to previous messageGo to next message
chintan.patel
Messages: 131
Registered: July 2008
Location: Ahmedabad
Senior Member
Hi

I read about iReport,
"iReport is the free, open source report designer for JasperReports." Now I would like to get more information regarding licensing compliance of iReport & Jasper Report. If any organization want to use iReport then is it required to buy the license of iReport & jasper report?

Thanks
Chintan
Re: Error in generating pdf report. [message #552343 is a reply to message #552340] Wed, 25 April 2012 03:29 Go to previous message
Littlefoot
Messages: 19345
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
At the bottom of the iReport homepage is a Community section, which contains GPL License link. Everything is described in there.
Previous Topic: Call creation timestamp changes when record is opened again
Next Topic: How to configure more than one database in weblogic
Goto Forum:
  


Current Time: Thu Jul 31 23:26:54 CDT 2014

Total time taken to generate the page: 0.08713 seconds