Saturday, November 2, 2013

Grouping in SSRS report

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