I am new to CR4E. I am trying to group on a particular field from a simple table. When I tried to group on a particular field by right clicking on the field, the "Group on field" option is not showing up. This option is listed only for one field in my table (id field - which I am not using in my table - it is created just for primary key). I want to group on different field. I even tried for all the other fields in the table. Only field for which this option is showing is the ID field. I don't understand why.
Is this behavior dependant on how the fields are created in database or anything to do with the CR4E? Can anyone please assist me in this.
Thanks in advance.