Home Forums Reporting Services SSRS 2012 Group by Month RE: Group by Month

  • September 18, 2017 at 11:10 am

    #1959842

    davidhyder - Monday, September 18, 2017 10:48 AM

    Thank you for your suggestion.

    I'd tried that, and it does in fact count for each day, but what I'm looking for is a count by month not day.

    It looks to me like you may need to do the grouping by DATENAME(month(convert (date, a.appt_date))), l.location_name

    Sue