Home » Developer & Programmer » Reports & Discoverer » Reports generate postscript with .pdf extension (Oracle Reports 9 and 11)
Reports generate postscript with .pdf extension [message #450533] Wed, 07 April 2010 13:58 Go to next message
jfsaucier
Messages: 20
Registered: June 2009
Location: Quebec
Junior Member
Hi,

We are currently in the migration of Oracle Reports 9 to Oracle Reports 11. In doing this, I saw a strange behavior in Reports : it generate a file with a .pdf extension that is in reality a postscript file. It do this in both the 9 and 11 versions.

Here is the header of the .pdf file in the cache folder of Reports :

%!PS-Adobe-3.0
%%Creator: Oracle Toolkit 2 for Motif 11.1.1.2.0 PRODUCTION
%%Version: 11.1 1
%%CreationDate: (Wed Apr  7 13:41:57 2010)
%%For: ((oracle@localhost))
%%Title: 'RAPT_130' (Oracle Toolkit Application)
%%LanguageLevel: 2
%%Requirements: numcopies(1)
%%DocumentData: Clean7Bit
%%PageOrder: Ascend
%%Pages: (atend)
%%Orientation: Portrait
% NOTE: This file was generated with the PPD file default.ppd


As you can, it's a postscript file.

Why do Oracle do this? Because of this, I have some problem in printing the reports (cups complaint that's it's not a PDF file, and it is right...)


Thank you!
Re: Reports generate postscript with .pdf extension [message #451163 is a reply to message #450533] Mon, 12 April 2010 14:04 Go to previous messageGo to next message
dlwixon
Messages: 92
Registered: September 2008
Member
Make sure you have desformat set to pdf when calling the report.
Re: Reports generate postscript with .pdf extension [message #451164 is a reply to message #450533] Mon, 12 April 2010 14:15 Go to previous messageGo to next message
jfsaucier
Messages: 20
Registered: June 2009
Location: Quebec
Junior Member
I already have desformat=pdf. In fact, I think the trouble is that I have destype=printer and desformat=pdf...

But, I cannot change that in the code.
Re: Reports generate postscript with .pdf extension [message #451171 is a reply to message #450533] Mon, 12 April 2010 17:02 Go to previous messageGo to next message
dlwixon
Messages: 92
Registered: September 2008
Member
Why can't you change it to destype=file and desformat=pdf?
Re: Reports generate postscript with .pdf extension [message #451287 is a reply to message #450533] Tue, 13 April 2010 07:55 Go to previous message
jfsaucier
Messages: 20
Registered: June 2009
Location: Quebec
Junior Member
I know that it's really easy to do normally. But in our case, that include changing hundreds of Forms that call the various reports, so, in short, it is not possible to do in the current situation.

I was more looking for a way to fix it globally on the server side for the moment and after the migration, the developers could modify the Forms slowly.
Previous Topic: restrict users to run a report
Next Topic: Need help with a report
Goto Forum:
  


Current Time: Tue Aug 11 17:49:55 CDT 2020