Link to home
Start Free TrialLog in
Avatar of Thean S
Thean S

asked on

SSRS expression - SQL Server Reporting Services

I want sum of Count column, can you please share expression for this or how to do this? the number of rows of date and count column is not fixed, it will vary every day.User generated image
Avatar of lcohan
lcohan
Flag of Canada image

I think that could be done as per steps listed below:

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)
Avatar of Thean S
Thean S

ASKER

--
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members 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.