Add Custom Log Report - Advanced Topic - Report Design - Table Control (Tablix) Grouping And Totals

1. With the table control selected, navigate to the 'Row Groups' section shown at the bottom and click the down arrow in the (Details) row.
   
   
   
   
2. Click 'Add Group | Parent Group' in the menu.
   
   
   
   
3. In the popup form, select the grouping field which is usually a record ID such as ProjectId and check 'Add Header' and/or 'Add Footer' depending on the scenario.
   
   
   
   
4. Grouping field is added automatically but should be deleted by selecting the column and right clicking the mouse.
   
   
   
   
5. Click the 'Delete Column' option in the menu.
   
   
   
   
   
   
6. Merge the grouping header cells by holding down the CTRL button on the keyboard and selecting all cells then right click the mouse and choose 'Merge Cells' in the menu.
   
   
   
   
7. Select the merged cell and click the small square icon next to the Content field in the Properties section then choose Expression (not shown).
   
   
   
   
8. Enter an expression that will be used for the group heading.
   
   
   
   
9. Adjust the group styling as needed.
   
   
   
   

Add Group Totals

1. Select the data cell that needs to be totaled for the group then right click the mouse and choose 'Add Total' in the menu.
   
   
   
   
2. Adjust style, format and alignment (ex. right aligned) as needed.
   
   
   
   

Adjust Report Body Height and Width

1. Adjust the report body height and width by dragging the edges as needed.
   
   
   
   
   
   

Save Report Changes

1. Click the 'Save Report' link at the top to save these changes.