Hi Robert,

Thanks for the reply again.

I know how to write SUM() and group by queries in T-SQL however, I want to know how to write this query and show the result in that particular column.

If i right click on a column on the report, where do I write the query in it so that we can display the result of the query in that column.

I am new to SSRS and need guidance.

Thanks