OraFAQ Forum: Reports & Discoverer » how to get report output in an excel file.

Home » Developer & Programmer » Reports & Discoverer » how to get report output in an excel file.

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

how to get report output in an excel file. [message #90294]

Tue, 25 January 2005 02:44

Rohit
Messages: 43
Registered: January 2002

Member

How to get report output in an excel file while running the report from a form.

Report message to a moderator

Re: how to get report output in an excel file. [message #90296 is a reply to message #90294]

Tue, 25 January 2005 05:49

irfan
Messages: 19
Registered: July 2001

Junior Member

dear you can simply use plsql devloper for this purpose.

or u first generate report in pdf.
then copy
then paste in excel

Report message to a moderator

Re: how to get report output in an excel file. [message #90301 is a reply to message #90296]

Wed, 26 January 2005 20:44

Rohit
Messages: 43
Registered: January 2002

Member

Thanks for your advice.

But I think there is a better way of getting the output by distributing the file grom the report previewer.

I want the report to run from the from button press and generate the output in the excel file directly, without even getting the report previwer.

Report message to a moderator

Re: how to get report output in an excel file. [message #90306 is a reply to message #90301]

Thu, 27 January 2005 06:58

ÇÊ
Messages: 15
Registered: September 2002

Junior Member

Option 1:
Use OLE or DDE and poke the data into your excel spreadsheet.

Option 2:
Use delimiteddata from reports to save the report as a csv file.

Report message to a moderator

Re: how to get report output in an excel file. [message #90323 is a reply to message #90306]

Fri, 28 January 2005 20:19

Rohit
Messages: 43
Registered: January 2002

Member

Thanks for your help.
Could you please explain the steps in detail.
As i have tried but failed to get the desired output.

Report message to a moderator

Re: how to get report output in an excel file. [message #109729 is a reply to message #90294]

Mon, 28 February 2005 05:21

jyotijeevan
Messages: 1
Registered: February 2005
Location: Kolkata,India

Junior Member

Hi Rohit,

Please try the following steps:

1.you can concatenate all the fields of your report with a
delimeter . e.g the query of the reports is select
ename||'|'||sal||'|'||hiredate from emp;

2. Save the report output as .txt file.
3. Open this .txt file with MS excel specifying the delimeter
as ( | ) i.e. the one which you had concatenated the report
columns in the select clause above. (In step 1).

Let me know if thi solves your purpose.

Rgds,
Jeevan

Report message to a moderator

Re: how to get report output in an excel file. [message #111802 is a reply to message #90294]

Sun, 20 March 2005 22:49

ravikumargunda
Messages: 2
Registered: March 2005
Location: Chennai

Junior Member

STEPS TO TRANSFER DATA FROM REPORT TO EXECL SHEET

1) First save that html browser file as .txt file
2) And open the excel sheet
3) Go to data =>import external data =>import data
4) Then it ask the file name to open
5) After opening the file it display one window
6) There it gives two options 1.delmited
7) 2.fixed width
8)Their u select delimited
9) And click next
10) There u will get another window
11) With 6 options
12) Tab, semicolon, comma, space, other
13) There u select space
14) Click next
15) Then it ask for existing work sheet or new sheet
16) After selecting that just click OK.

Report message to a moderator

Previous Topic:	Invalid Syntax error in Forms 9i
Next Topic:	passing data parameters to reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:26:36 CST 2024