What would prevent a field from showing as a Group By on a report?

e_wilber
Tera Guru

I'm doing a very basic report for the Incident table on a custom field u_department that pulls from the Department table.

On my list report under Group By, I cannot select Department. It's there as an available column in the report but it doesn't let me set the report to group by it. I know reports can group on reference fields (such as Assignment Group) so what might be causing this field to not display in the condition builder?

12 REPLIES 12

Oh thank you so much! That helps a lot! this has been driving us crazy!


Nice find thanks 

Perfect.  Thanks!