count of first column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » count of first column

count of first column

Rate Topic

Display Mode

Topic Options

Author

Message

naveendk.55

Posted Wednesday, March 20, 2013 3:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 9:08 AM
Points: 2, Visits: 4

Hi, 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.

Post #1433106

mikehunsaker

Posted Wednesday, March 20, 2013 6:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:32 AM
Points: 26, Visits: 178

Do 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:

http://msdn.microsoft.com/en-us/library/ms170712.aspx

HTH.

Mike

Post #1433160

naveendk.55

Posted Wednesday, March 20, 2013 9:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 9:08 AM
Points: 2, Visits: 4

I resolved it by using CountDistinct ().. Thank you.

Post #1433292

mikehunsaker

Posted Thursday, March 21, 2013 5:52 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:32 AM
Points: 26, Visits: 178

Glad you figured it out. Thanks for letting us know!

Mike

Post #1433741

« Prev Topic | Next Topic »

Permissions