How to add Group by in report with sum in RDLC report
How to add Group by in report with sum in RDLC report in visual studio
- Right click on the middle of the row of the port table
-Right click and choose add group
-on Icon- choose the column on which you want to group and choose option show footer
-merge the column - Right click and choose sum of coumn
- show sum - right click on the cell - Select common function > Agreegate functions > choose sum
- To add Grand Total, Click on table row and
- Select 'Insert row" and choose "OutSide the Group Row
