Created a SC “group by” based on a text Field of varchar(30) in a table with only 1,000 records. I made no modification to the basic SQL for the grid (e.g. did not add any special “order by” clause) and it remained the basic syntax generated by SC. Many records in the table have the same data in the text field (and why it was useful to “group”).
SC will generate multiple groups of the same text - IN SOME CASES NOT ALL - as if misinterpreting the field characters???
– checked to ensure I had used a good field collation – same results
– checked to ensure there wasn’t some unnoticeable difference in the field data, leading/trailer space, etc - same results
– created an index in the MySQL table on the text field – still multiple group headers of the same text
– the number of records in each duplicate group was not consistent as if the Group Label had not correctly reset.
The multiple groups generated did not appear to repeat the RecID fields; it almost appeared as if the generated Group Label actually replaced the text field in the grid record where the text field also appeared. :mad:
Interesting: When clicking on SUMMARY, the Group Names were not repeated and the summary appeared to have counted the number of records in each Group correctly.
Does page Navigation create a problem in Grouping. Must I generate a single page of ALL records to get correct grouping?
Is there a trick to ensuring the GROUP BY actually will GROUP (once) based on the data in the field - ONLY ONCE? 
