How to group by a calculated column in a Content Query Web Part

Question

I'm trying to build a Custom Query Web Part that pulls data from multiple lists (or I'd just do this with a List View) and I want to group the data by first letter, A-Z. Right now I have a calculated column that is using =LEFT(Title,1) to determine the first letter of each data entry. Even if I modify the .webpart file's GroupBy property for the CQWP to force it to group by my calculated column ("Letter"), though, the query comes up empty because it can't group by a calculated column. Does anyone know of another way I can do this, or a way to make Sharepoint have a static column of the calculated value?

I'm using a Workflow to copy the calculated data into a static field every time an item is changed or created right now, but that's not a very portable solution to other lists because I made it in Sharepoint Designer. — Jeff

Per Jakobsen Per Jakobsen · Accepted Answer · 2010-06-30T04:45:30

Unfortunately you'll have to make this using a combination of a field and a SPItemEventReceiver, so you generate a readonly field and make a EventReceiver, which updates it in ItemAdding and ItemUpdating

How to group by a calculated column in a Content Query Web Part

1 Answers