OraFAQ Forum: Reports & Discoverer » Convert report to Excel File

Home » Developer & Programmer » Reports & Discoverer » Convert report to Excel File (

) 1 Vote

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

Convert report to Excel File [message #194629]

Sat, 23 September 2006 02:09

simple_ora
Messages: 50
Registered: September 2006
Location: UAE

Member

Hi Guys how can i convert reports to excel file,in DELIMITED Format ,the report headings also coming in rows,..how can i handle it..

Report message to a moderator

Re: Convert report to Excel File [message #194641 is a reply to message #194629]

Sat, 23 September 2006 05:30

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi

i hope u are fine.

i had solve this problem by writing a package and then
applied that package into report
i applied that package in the format triggers
i have not that package in my office pc i shall send you that package via email soon

that package transfers our report data into Excel Work book
and it worked well.

i have applied in several organizations

Regards.

Muhammad Shahid Mughal
Database Programmer
Faisalabad.
PAKISTAN

[Updated on: Sat, 23 September 2006 05:32]

Report message to a moderator

Re: Convert report to Excel File [message #195001 is a reply to message #194641]

Tue, 26 September 2006 08:17

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi Shahid,

How are you, send that package to me also I also face the same type of problem.

Bye
Ashu

Report message to a moderator

Re: Convert report to Excel File [message #195067 is a reply to message #194641]

Tue, 26 September 2006 16:52

tllocke
Messages: 22
Registered: March 2006

Junior Member

I'd also love for you to send this to me as well. I've had this issue for a while now since I do not have any access to the url or command line.

Thanks!

Report message to a moderator

Re: Convert report to Excel File [message #195076 is a reply to message #194629]

Tue, 26 September 2006 20:24

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Can you please post it here so that everyone in need will just download a copy. Although I'm not in need of it right now, I'm interested.

Thanks,

Wency

Report message to a moderator

Re: I have Attached The File For All Users [message #195096 is a reply to message #195076]

Wed, 27 September 2006 01:26

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi all,

i am sending this file to whole forum
anyone can download this file.

regards.

Muhammad Shahid Mughal

Attachment: MATRIX_DEMO.rdf
(Size: 144.00KB, Downloaded 4782 times)

Report message to a moderator

Re: Convert report to Excel File [message #195150 is a reply to message #194629]

Wed, 27 September 2006 03:55

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Thanks a lot!

Report message to a moderator

Re: Convert report to Excel File [message #198237 is a reply to message #194629]

Mon, 16 October 2006 04:30

voralux
Messages: 72
Registered: January 2006

Member

Dear shahidmughal,

Thank you for the sample report,
I have a question, I create a new report and copy concept but i can not convert report(REP-1430 Can not Create REP file for report 'c:\test.rdf' Compilation error found.

Please help me,

Thank you.

Report message to a moderator

Re: Convert report to Excel File [message #198260 is a reply to message #198237]

Mon, 16 October 2006 05:34

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi

please tell us what kind of messages you are seeing

regards

Muhammad shahid Mughal

Report message to a moderator

Re: Convert report to Excel File [message #198370 is a reply to message #194629]

Mon, 16 October 2006 20:47

voralux
Messages: 72
Registered: January 2006

Member

REP-1430 Can not Create REP file for report 'c:\test.rdf' Compilation error found.

Report message to a moderator

Re: Convert report to Excel File [message #198387 is a reply to message #198370]

Mon, 16 October 2006 23:50

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi

if you don't mind please send me the schema and the rdf file i shall work for you on it. and then i shall tell you what you have done wrong. because the above error i m seeing first time by you.

i hope you will do so because i cannot understand without example this sort of error.

regards

Muhammad Shahid Mughal

Report message to a moderator

Re: Convert report from english to arabic [message #198687 is a reply to message #194629]

Wed, 18 October 2006 04:32

zaghloul
Messages: 9
Registered: October 2006

Junior Member

we can't read the reports in arabic on running any report as a web layout. can u help it's really urgent.
and please where do u place the excel package

Report message to a moderator

Re: Convert report to Excel File [message #199448 is a reply to message #194641]

Tue, 24 October 2006 07:00

nileshmalpani
Messages: 2
Registered: October 2006
Location: INDIA

Junior Member

Hi

I am also faceing the same problem please send me the same package to enable me to overcome from this problem.

Thanks & Regards

Nilesh Malpani
India

Report message to a moderator

Re: Convert report to Excel File [message #200726 is a reply to message #194629]

Wed, 01 November 2006 01:57

lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD

Senior Member

hi ,

I had seen the package and not able to get the excel output.
after the report is run and click the export to excel button,the console is not transferred to excel.Pls help me out in this.

regards,
surya

Report message to a moderator

Re: Convert report to Excel File [message #209406 is a reply to message #200726]

Thu, 14 December 2006 11:57

Murugsamu
Messages: 1
Registered: December 2006

Junior Member

Hi,

I am also facing the same issue. Pls. send me that package.

thx
Murugan.

Report message to a moderator

Re: I have Attached The File For All Users [message #211213 is a reply to message #195096]

Wed, 27 December 2006 04:27

aseesandhu
Messages: 1
Registered: December 2006
Location: Faisalabad-Pakistan

Junior Member

Dear M.Shahid,

Thanks for sending report for converting reports into excell, It is working well but when i use to call this report through forms menu then it doesn't work.

Please help me....

Regards,
Asim Ikram

Report message to a moderator

Re: I have Attached The File For All Users [message #245600 is a reply to message #211213]

Mon, 18 June 2007 03:42

cutsmartprem
Messages: 62
Registered: November 2006

Member

Hi Mohammed,
Im using the rdf which you have sent as an example, but i couldnt get the output in excel. Can you tel the steps to get the output.

Report message to a moderator

Re: I have Attached The File For All Users [message #245639 is a reply to message #245600]

Mon, 18 June 2007 04:50

cutsmartprem
Messages: 62
Registered: November 2006

Member

Hi Mohammed,
In the rdf which you have sent, the 'export to excel' is a text field. What should i do. Is there any problem in the version im using.
Kindly help me out as it is urgent for me.

Report message to a moderator

Re: I have Attached The File For All Users [message #354175 is a reply to message #195096]

Thu, 16 October 2008 16:30

ddivyal
Messages: 2
Registered: October 2008
Location: Hyderabad

Junior Member

Hi Shahid,

i am new to this forum and came here looking for a solution to convert oracle standard reports in oracle apps to give an excel output.

basically i have oracle standard purchasing reports and user want the output in excel instead of in html against standard concurrent request output.

if i use your format trigger in my report and run it in apps will it work?? otherwise please advise of a feasable solution.

Thanks,
Divya

Report message to a moderator

Re: Convert report to Excel File [message #380883 is a reply to message #194629]

Tue, 13 January 2009 15:36

oraclefaqs1
Messages: 23
Registered: October 2008
Location: SC

Junior Member

hi Shahid,

I am new to oracle reports.
We would really appreciate if you follow us through the steps.
I am working on GL account detail summary report, i get a good TEXT output, but the client needs EXCEL output.
I don't know where and how to apply your package's logic

really in need.

thanks,
puran

Report message to a moderator

Re: Convert report to Excel File [message #380904 is a reply to message #380883]

Tue, 13 January 2009 22:38

cutsmartprem
Messages: 62
Registered: November 2006

Member

You can convert reports to excel using the spreadsheet option. The report output will have a good feel.

Report message to a moderator

Re: Convert report to Excel File and call from oracle form [message #402078 is a reply to message #209406]

Thu, 07 May 2009 09:05

okcbrwn
Messages: 1
Registered: May 2009
Location: dallas

Junior Member

Hi all,

I created excel file from report 6i. This part worked fine.
But my end users have access to only oracle forms ->reports.
So i have to create a button -> when_button_press_trigger->

run_product(report_name, etc).
But this part is not working.
I used run_product for run other report it all worked fine.
Do you know how i can call this report excel output from a form button.

appreciate any help.

Report message to a moderator

Re: I have Attached The File For All Users [message #402341 is a reply to message #195096]

Fri, 08 May 2009 22:37

danish_fsd@yahoo.com
Messages: 38
Registered: February 2008
Location: Pakistan

Member

Assalam o Alikum,

You are really great. Smile

Regards.
Danish

Report message to a moderator

Re: I have Attached The File For All Users [message #440430 is a reply to message #402341]

Sun, 24 January 2010 14:44

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

Dear Friend i have come back after a long time of absence and i am really very sorry for this.
Thank you all who appreciated my effort and helped me to improve myself.
There are some other ways to convert the report into excel format.

One of them is to download the following application and use it as directed in read me files.you can download it here.. http://www.lv2000.com/rx/rep2excel.htm

when the trial expires you can download it again delete older folder and paste newer one.

Your's sincerely,

Muhammad Shahid Mughal
Oracle Developer / Managing Director
Professional's Corner (Software Development Department)
Faisalabad Pakistan

Report message to a moderator

Re: I have Attached The File For All Users [message #515355 is a reply to message #440430]

Mon, 11 July 2011 01:35

shantysaggu007
Messages: 6
Registered: July 2011
Location: ludhiana

Junior Member

Hi Guys how can i convert reports to excel file,
i m sufering for repation row's in excels,
the single row can be repeat after 20,25 page

Please help me,

Thank you.

Report message to a moderator

Re: Convert report to Excel File [message #574529 is a reply to message #515355]

Fri, 11 January 2013 13:27

user888
Messages: 3
Registered: February 2012
Location: Chicago

Junior Member

Does anybody solved this..I am facing same problem..unable to export to EXCEL. DESFORMAT=SPREADSHEET..Worked,but not as expected. The excel output has many blank spaces, alignment was highly disturbed and report looks ugly.. How can we achieve this...anybody please help.
Thanks in advance.

Report message to a moderator

Re: Convert report to Excel File [message #601794 is a reply to message #574529]

Mon, 25 November 2013 22:18

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

hello sir,
i am working on oracle d2k reports,i want to save my report in excel just on button click,the file automatically save in excel,is it possible?

[Updated on: Tue, 26 November 2013 01:06]

Report message to a moderator

Previous Topic:	Using Instr and substr
Next Topic:	report expire

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 06 19:04:22 CST 2025