AnsweredAssumed Answered

Report With Group By Claus ( as in SQL)

Question asked by Dees on Jun 6, 2013
Latest reply on Jun 7, 2013 by philmodjunk

Title

Report With Group By Claus ( as in SQL)

Post

     I have a table that has the following fields:

     RecordId

     EmployeeId

     EmployeeName

     InvoiceId

     CommissionAmount

     Date

      

     Lets say it has the following data:-

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
                    RecordId                     EmployeeId                     EmployeeName                     InvoiceId                     CommissionAmount                     Date
                    1                     1                     Ant                     1000                     4.21                     06/01/2013
                    2                     1                     Ant                     1000                     -4.21                     06/02/2013
                    3                     4                     Den                     1001                     36.25                     06/02/2013
                    4                     3                     Bil                     1002                     6.75                     06/02/2013
                
               Preferences
                
               Preferences

     I want to create a report :-

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                    Ant
                                          $4.21
                                          -$4.21
                    Total                     $ 0.00
                    Den
                                          $36.25
                    Total                     $36.25
                    Bill
                                          $6.75
                    Total                     $6.75
                     
                    Grand Total                     $43.00

      

     I created a report using Sub-summary by EmployeeName(Leading) but it does not group by employee:- 

     Here's how it looks like:-

      

      

                
               Preferences
                

      

                                                                                                                                                                                                                                                                                     
                    Ant
                                          $4.21
                                          -$4.21
                                          $36.25
                                          $6.75

      

     How do make it group by employee name and how do I do the subtotals an the grand total? 

     Your help will be very much appreciated.

      

      

     P.s - if you see "Ant" with the background green color that is not what I want - dont know why the rows have that green color .

     Thanks

     Dee

      

                
               Preferences
                
               Preferences

      

                
               Preferences
§
1
2
3
4
5
6
7
8
9
0
-
=
Backspace
                     
Tab
q
w
e
r
t
y
u
i
o
p
[
]
                          
Return
                          
                     
capslock
a
s
d
f
g
h
j
k
l
;
'
\
                     
shift
`
z
x
c
v
b
n
m
,
.
/
shift
                     
                          
                         English
                               
                               
alt
alt
                     
                
               Preferences

      

Outcomes