Displaying sum of result in column based on filter/grouping used

Hello All

Hopefully this is an quick & easy one and I should try to play around a bit before posting here probably but kinda on a deadline and very new with SSRS so posting the question here.

We have a table with following attributes:

• User Name


• User Email Address


• Count of Emails sent by user


• Size of emails sent by user


• Data upload time.

For each user & day, we've row with above values. i.e. for 1 week period, we'll have 7 rows for a given user with above data.

Basically our management access this report and filter based on data upload time range like from 1st January to 1st February 2014. Now what they want is, instead of having 7 rows as explained above, they want only single row with sum of 7 rows displayed in same.

I've played some with reporting grouping in SSRS builder 3.0, but not able to get exactly what they want.

Any pointers for me please? Will be really appreciated !

Thanks in advance !

---

AKL