View Single Post
  #1 (permalink)  
Old September 9th, 2003, 06:53 AM
Sanjay Bajpai Sanjay Bajpai is offline
Registered User
 
Join Date: Sep 2003
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to make subtotal of a column

I am writing a report on asp i selected the data
from oracle table
"select challan date challan no, Order no, amount from table x
where challan date = (date input)"

the data are as follow :
challan no. Order no. amount(rs)
10 2 2000
11 3 1000
12 2 4000
13 5 3500
14 3 5000


Now my requirment is like this

challan no. order no. amount
10 2 2000
12 2 4000
subtotal (amount) 6000

11 3 1000
14 3 5000
subtotal (amount) 6000

13 5 3500
subtotal (amount 3500

Pl. write me how to program in asp to get desired output
input is only date