AnsweredAssumed Answered

Is it possible to group by textarea field in 6.5 reports?

Question asked by Francesca Shiekh on Aug 20, 2014
Text area and varchar fields are normally not available to be used for grouping in Reports, for obvious reasons.
Is there a way to force a field to be selectable for grouping?

We have a custom Survey module which records inputs from our web pages, the module has a Question and an Answer field. To keep it flexible these are varchar & textarea respectively but often the Answers correspond to dropdowns or radio buttons so are standard answers.

We'd like to report on these dropdown Q&A and group by "Answers" which is a textarea.