OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Report 2 exl (oracle 9i)

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

Report 2 exl [message #598443]

Tue, 15 October 2013 00:14

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

I have a report which i export into excel file,now i want -->
if i export my report into excel file then it (excel file) should automatically saved to my c drive.Please entertain.

Regards
viplove..

Report message to a moderator

Re: Report 2 exl [message #598513 is a reply to message #598443]

Tue, 15 October 2013 09:04

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

When you select the option SAVE AS, don't you see the location to copy in your local machine?

Report message to a moderator

Re: Report 2 exl [message #598549 is a reply to message #598513]

Tue, 15 October 2013 13:24

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

That is an option in excel file,but i don't have to operate excel file. Simply i want to download or export that report in excel format in my c drive.
hope you understand what i wants.
Thanks.
Regards
viplove..

Report message to a moderator

Re: Report 2 exl [message #598558 is a reply to message #598549]

Tue, 15 October 2013 13:43

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

I don't work much with reports, however, as far as I know, there are parameters to achieve the task.

I hope I am correct with this information, give it a try -

DESFORMAT=<filetype> DESTYPE=<FILE> DESNAME=<C:\file_name.file_type>

For CSV or excel, DESFORMAT should be DELIMITED.

Let me know if it works for you(I don't have reports to validate right now).

[Updated on: Tue, 15 October 2013 13:45]

Report message to a moderator

Re: Report 2 exl [message #598836 is a reply to message #598558]

Thu, 17 October 2013 23:47

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

Thanks for your opinion...
This will generate whole report into excel but i simply want some columns (its tabular report) to be there into excel file,there is no option for restrict some data from report to be converted into excel.

Report message to a moderator