Home » Developer & Programmer » Reports & Discoverer » Calculating Subtotal in Oracle reports
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...
Previous Topic: report error 1800
Next Topic: Default sysdate for parameter
Goto Forum:
  


Current Time: Thu Dec 05 15:40:31 CST 2024