Page 1 of 1
reports in text
Posted: Sun Oct 07, 2007 8:22 am
by AIMAM
Hello,
What are the steps required to create a report for oracle apps that has an excel or text output?
Please help...
Posted: Mon Oct 08, 2007 1:11 pm
by karthick_jk
hi,
after creating the report, in the concurrent program definition, change the type of output to either text/excel.
regards
karthick
Posted: Tue Oct 09, 2007 1:31 am
by katepalli.mohan
Hi,
As far as my Knowledge is concern there is no output format as excel for this u have to concatinate each field with single pipe put the format as text then run u r concurrent program which gives text output save into u r local machine then open this text file using excel.It asks delimetor...........
Regards & Thanks
Katepalli.Mohan
Posted: Fri Oct 26, 2007 9:51 am
by amitm_66
After the concurrent program completes normal, do the following:
Click on View output button
Do Tools -> Copy. THis will copy the output to IE.
Then save as .txt. This will give you text file. You can open this in excel if the output is comma delimited
Posted: Tue Oct 30, 2007 6:20 am
by sankarch
Hi,
We can Create the Concurrent Program and format type is Text,
then run the Concurrent Program , open the output i save it and
then again open the Output in Excel.
Thanks,
Sankar
Posted: Mon Mar 03, 2008 6:37 am
by kishorebhupati
Hi,
In order to create a report for oracle apps that has an excel or text output you have to use Application Desktop Integrator which i have been using as it gives flexiblity of spread sheets and converting Report in to Excel format though Data text to columns will not give desired result in neat look or format.