SQL 2012 ORDER BY list of RANGE window frame cannot contain expressions of LOB type

I ran into this error when preparing some data for a report in SQL Server Reporting Services 2012. I was trying to partition data showing construction progress for work areas by week number using the updated ORDER BY clause for…