you have to add rowgroup to your report,once you add it then you should group by person and month.
Col 1- Fields!Employee_Name.value
Col 2 -MAX(Fields!Organization.value)
Col 3- Fields!Month.value
Col 5- MAX(Fields!Date_Earned.value)
Col 6- MAX(Fields!Requested_Date.value)
Col 7- SUM(Fields!Normal_Day_Count.value)
For the Others.it should be Sum(Fields!...?)
No comments:
Post a Comment