Home Forums Reporting Services Reporting Services 2008 Development Can you count rows based on the group level instead of detail level RE: Can you count rows based on the group level instead of detail level

  • January 16, 2015 at 10:15 am

    #1770822

    I agree about doing as much code as possible in the SQL directly

    Much like we call a histogram

    ex.

    SELECT COUNT(*)

    ,[BusRoute]

    ,[BusRouteDescription]

    FROM [ICES].[dbo].[CardAFCTransactionDetails]

    where BusRoute is not null and BusRoute > ' ' and RecordType <> 6

    group by [BusRoute]

    ,[BusRouteDescription]

    order by [BusRoute]

    ,[BusRouteDescription]