InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 14:55:16 GMT20http://www.sqlservercentral.com/Forums/Topic1433106-1633-1.aspxGlad you figured it out. Thanks for letting us know!MikeThu, 21 Mar 2013 05:52:10 GMTmikehunsakerhttp://www.sqlservercentral.com/Forums/Topic1433106-1633-1.aspxI resolved it by using CountDistinct ().. Thank you.Wed, 20 Mar 2013 09:08:25 GMTnaveendk.55http://www.sqlservercentral.com/Forums/Topic1433106-1633-1.aspxDo you have grouping on the report itself? If you have Row Grouping on the field, this will show the SUM (or whatever aggregate you want) at the bottom of the report.See this page from Microsoft on Grouping/Totals:[url]http://msdn.microsoft.com/en-us/library/ms170712.aspx[/url]HTH.MikeWed, 20 Mar 2013 06:11:42 GMTmikehunsakerhttp://www.sqlservercentral.com/Forums/Topic1433106-1633-1.aspxHi, I have a column with name ID. The ID value is repeated in query and I grouped it using group by. It is showing correct way in report. At the end of the report I want the count of the ID. But it is showing total number of IDs in query and not the count displayed in the report. How to get the count displayed in the report. Note: the second and third column have more than one row for single ID in report.Wed, 20 Mar 2013 03:55:40 GMTnaveendk.55