i am getting result from the query is sum of amount which is against usercodes and also i have the column numlevel which is also against the usercodes.

here column numlevel contains the values 1 to 5.

now i want here the sum of amount whos usercodes which is under numlevel2.

i.e, the usercode of numlevel 5 is under usercode of numlevel4,the usercode of numlevel 4 is under usercode of numlevel3 and the usercode of numlevel 3 is under usercode of numlevel2 ,

Now i want the sum of amount , usercodes whos numlevel is 3,4 and 5 which is under the usercode, having numlevel value is 2

 

Please help me

 

thanks in advance

Sv

 i want this report in asp.net,

what should i group,already it was grouped by other field name main users,in that the userlevels are included,

please explain detailly.

actually the report is as follows

MainUser(GroupHeader)

  Usercode(userlevel2)                        

      Usercode(userlevel3)                        Amount                  A

      Usercode(userlevel3)                        Amount                  A

              Usercode(userlevel4)                        Amount          B

  Usercode(userlevel2)                        

 Group footer-------------------------------------     Total--(A+A+B+A1+A1+B1)

 

Now i want the report in the following format