We help IT Professionals succeed at work.

Show Parent is total below the Child.

emi_sastra
emi_sastra asked
on
Medium Priority
190 Views
Last Modified: 2012-05-07
Hi,

I have query into below result.

AccNo      Name                                                   Debit                    Credit                 Parent Account

32               PENDAPATAN/BIAYA NON OPERASI      0.0000                      1448947.0000          3                
6103             BIAYA KARYAWAN                                6433000.0000       0.0000                  61               
6104             ADMINISTRASI KANTOR                       1831500.0000       0.0000                  61               
6108             BIAYA PEMELIHARAAN                         250000.0000       0.0000                  61               
7103             Main Nursery                                       229250000.0000       0.0000                  71               

How could I show it into :

32               PENDAPATAN/BIAYA NON OPERASI      0.0000                      1448947.0000          3          
                TOTAL                                                  

6103             BIAYA KARYAWAN                                6433000.0000       0.0000                  61               
6104             ADMINISTRASI KANTOR                       1831500.0000       0.0000                  61               
6108             BIAYA PEMELIHARAAN                         250000.0000       0.0000                  61        
                TOTAL                                                  
      
7103             Main Nursery                                       229250000.0000       0.0000                  71    
               TOTAL          

Thank you.           


Comment
Watch Question

Database Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Hi aneeshattingal,

The link helps a lot.

Thank you very much for your help.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.