How to report output like below
supplier name date amount
abc software jan/11 10000 /* jan month total transactions*/
abc software feb/12 30000 /* feb month total transactions*/
dell computers jan/13 45000 /* jan month total transactions*/
Answers were Sorted based on User's Feedback
Answer / sovan
select supplier_name "supplier name" ,to_char
(trx_date,'mon/yy') "date",amount "amount"||'/*'||to_char(trx_date,'mon')||'
month total transactions */' from <Table_NAME>;
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / aditya
Hi,
Just write a report function which takes the date and finds
the month then concatenate it with the text /* (<Month>)
month total transactions*/
Regards,
Aditya
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ram
select supplier_name ,to_char
(sysdate,'mon/yy'),amount||'/*'||to_char(sysdate,'mon')||'
month total transactions */' from <Table_NAME>;
Is This Answer Correct ? | 1 Yes | 1 No |
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
In which directory your flatfile is given?if u connected different instance where it is find?
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
what are the different calculation columns available in reports?
Hi Experts How to Create a purchase order without a requisition ?
6 Answers Amdocs, KPMG, Oracle,
what is meant by Drill Down in Discoverer report? why it will be use?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
What is multi org?
In interface how u find errors and how to solve. How to fix it?
testing tools?
0 Answers BirlaSoft, Convergys,
In support project one ticket alloted which steps follows manualy tell me ?
i have 100 pages output. i want to print 10 records per page in Template?