• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

oracle reports

Hi
Using ORacle forms to call the oracle reports.
the report default DESTFORMAT is pdf i changed it to spread sheet.
but i am getting error when trying to open the excel file
The file you are trying to open getjobid357.xls is in a diferent format than specified by the file extension.

report name is test1.rdf
and binary is test1.rep.

can I get the excel report from forms without the above error message. please advise.
thanks.
0
Sarma Vadlamani
Asked:
Sarma Vadlamani
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
The file really isn't a native Excel file so Microsoft is warning you.

Microsoft has ways to get around the warning message if you want to:
https://support.microsoft.com/en-us/kb/948615


Check the online Oracle docs:
http://docs.oracle.com/cd/E17904_01/bi.1111/b32121/pbr_cla005.htm#RSPUB23808


SPREADSHEET
 
(Command line only) The report output is sent to an HTML file that can be directly opened with Microsoft Excel 2000. You can generate spreadsheet output from the paper layout of reports saved in any format (.rdf, .jsp, .xml). See Usage Notes.
 
0
 
Sarma VadlamaniprogrammeranalystAuthor Commented:
any other work around. or can i generate an excel report directly from oracle forms without using the oracle reports.
I need to generate a user audit report by passing parameters like user name
acess date from and access date to.
thanks.
0
 
slightwv (䄆 Netminder) Commented:
Sorry but I'm not a Forms and Reports person.

Hopefully an Expert that is will post later.
0
 
Helena Markováprogrammer-analystCommented:
Yes, the excel output can be generated directly from Oracle Forms. You ought to use WebUtil library (Client_Text_IO.package). It is a part of Oracle Forms and is very well described in the Forms on-line help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now