Exporting data from report 6i to excel
Hi pleaze any body tell me how i export data from report 61 to excel. pleaze send code.my email id is r.yasirarfat@yahoo.com
Software/Hardware used:
Software/Hardware used:
ASKED:
April 15, 2010 10:43 AM
UPDATED:
April 18, 2011 8:23 PM
Answer Wiki:
One way to create a CSV file that can be opened with Excel would be setting this parameters when calling the report, to generate its output to a delimited file
MODE= Character
DESTYPE= File
DESFORMAT= Delimited
DESNAME= 'YourFile.csv '
DELIMITER= ','
You could also use some third party tool to make the export.
And other option would be to create the excel file from Forms. How to do this has been asked before. Here's a question about this:
<a href="http://itknowledgeexchange.techtarget.com/itanswers/how-to-call-excel-from-oracle-reportforms-6i/">How to call Microsoft Excel from Oracle Reports/Forms 6i</a>
----------
To see all answers submitted to the Answer Wiki: View Answer History.
This is more generic than what you are asking for but you may find it useful just the same:
Beyond Excel