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

  • September 19, 2017 at 6:49 am

    #1959929

    davidhyder - Monday, September 18, 2017 4:24 PM

    Thanks y'all... That got me there!

    Month() gave me the number of the month but Datename(m,...) gave me the name of the month so I went with that one.

    Greatly appreciated!!!

    Just keep in mind that you won't be able to have this report span years that way.   Only a combination of month and year can do that.
    For example:GROUP BY CONVERT(char(4), YEAR(CONVERT(date, a.appt_date))) + '_' + DATENAME(MONTH(CONVERT(date, a.appt_date))), l.location_name

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)