Thean S
asked on
SSRS expression - SQL Server Reporting Services
ASKER
--
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Right click on the grouping that you want to total - in your case the details group. (You can find a list of groups in the Row Groups pane of the designer window.
Select "Add Total -> Before" (or after)
You should now have a row where to add the total and SSRS will try to figure out what total to insert. If that looks ok leave it and if not you will need to edit the expression of a cell.
In the cell you want your total, right click and select Expression. In the Expression window enter =SUM(Fields!Count.Value)