Need help with my code to have expected output. [message #312846] |
Wed, 09 April 2008 22:19  |
senaubi_me
Messages: 24 Registered: February 2008
|
Junior Member |
|
|
Hello Experts,
Attached is a txt files containing my recent sql code and below is the sample output. I need help on how i can make Total number of records label and its value to be positioned below the Total Amount label and value.
I hope someone can help me. I really appreciate it!
God Bless and Thank you!
P.S Please see the attachment.
A Code SR# Sales ID Cash Amount CPF Amount Cust Name Branch
101 1-12345 1-A111 0 100,000 Allan North
101 1-12346 1-A112 50,000 50,000 Cora South
101 1-12347 1-A113 99,000 0 Brian West
Total # of records 3
Total Amount $149,000 $150,000
A Code SR# Sales ID Cash Amount CPF Amount Cust Name Branch
201 1-12222 1-A155 0 100,000 Allan North
201 1-12223 1-A156 50,000 50,000 Cora South
201 1-12224 1-A157 99,000 0 Brian West
201 1-12225 1-A158 100,000 50,000 Sarah East
Total # of records 4
Total Amount $249,000 $200,000
Grand Total Amount $398,000 $350,000
Grand total # of records 7
-
Attachment: CODE2.txt
(Size: 6.88KB, Downloaded 561 times)
|
|
|
|
|
|
|
|
Re: Need help with my code to have expected output. [message #313263 is a reply to message #312846] |
Fri, 11 April 2008 04:59   |
senaubi_me
Messages: 24 Registered: February 2008
|
Junior Member |
|
|
Hi experts,
This the result i am getting. I want to put the total amount under the total # of records. Thank you.
Code SR# ID AMT1 AMt2
101 1A2 1-2 0.00 100.00
Total # records 3
Total Amount 0.00 100.00
150 1A3 1-2 0 100.00
150 1A4 1-1 10.00 150.00
Total # records 2
Total Amount 10.00 250.00
Grand Amount 10.00 350.00
Grand total # records 5
|
|
|
|