Home » Developer & Programmer » Reports & Discoverer » Report in Export in Excel Format (Report 6i, Windows 7)
Report in Export in Excel Format [message #662657] Tue, 09 May 2017 01:03 Go to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Can we Export the Report 6i in Excel Format(.XLS)?
thanks
Re: Report in Export in Excel Format [message #662662 is a reply to message #662657] Tue, 09 May 2017 06:26 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not directly. However, if you specify report parameter DESFORMAT=DELIMITED, Excel will be able to read it.
Re: Report in Export in Excel Format [message #662664 is a reply to message #662662] Tue, 09 May 2017 06:30 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks for Reply Little Foot,
Read means then we can open the File in Excel, in whatever the format defined in the Report?
Re: Report in Export in Excel Format [message #662665 is a reply to message #662664] Tue, 09 May 2017 06:36 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Think!

I'll send you a PDF file; will you be able to open it with Excel?
Re: Report in Export in Excel Format [message #662669 is a reply to message #662665] Tue, 09 May 2017 07:32 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Sure it will not open in Excel, what i am requesting, as we can extract in XML, if we setup DESFORMAT=DELIMITED, will we be able to Extract data in Excel as CSV?
Thanks
Re: Report in Export in Excel Format [message #662695 is a reply to message #662669] Tue, 09 May 2017 14:04 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, that's not what you asked. You asked "in whatever the format defined in the Report".

As usual, if you tried it, you'd already know the answer. I'd suggest you to do so.
Re: Report in Export in Excel Format [message #662703 is a reply to message #662695] Wed, 10 May 2017 00:46 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks for reply and patience, Sorry for embarrassment, will follow the same by setting up DESFORMAT=DELIMITED
Re: Report in Export in Excel Format [message #663559 is a reply to message #662703] Thu, 08 June 2017 03:28 Go to previous messageGo to next message
Lubna
Messages: 12
Registered: June 2017
Junior Member
Yes we can export to excel,
Share you report sample to let you know how it works.
Re: Report in Export in Excel Format [message #663560 is a reply to message #663559] Thu, 08 June 2017 03:36 Go to previous message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Dear Lubna,
Thanks a lot for Reply,
which type of Report Sample i need to send you?
we can Export in Ms. word and XML format from File Menu, but Excel is not there,
Previous Topic: Oracle Reports 6i with Oracle DB 11g. Does it work?
Next Topic: Add text field to existing repeating frame
Goto Forum:
  


Current Time: Fri Mar 29 09:48:13 CDT 2024