Calculating Subtotal in Oracle reports [message #408507] |
Tue, 16 June 2009 08:09 |
Nshan
Messages: 62 Registered: February 2009
|
Member |
|
|
Hi All...
I want to calculate subtotal and report total based on supplier in my oracle reports.
My output file type is MSEXCEL..
My format should be
Supp_Name Grs_amt_paid
----------------------------
A 1000
A 1000
Total of A 2000
B 3200
B 2000
Total of B 5200
Total of report 7200 (Total of A+ Total of B)
I am using XML data definition.
I unable to figure out how to get the data for RTF.
I have attached my XML query file.
For sample i hav mentioned two columns. Actual columns are mentioned in the query file.
Any answers on this would be more helpful...
thanks in advance...
|
|
|