Ticket #30558
Question
Column not sorting correctly. I added a new field 'PO#' to my report and whenever I click on the column heading, the data doesn't sort correctly.
Answer
Customer's HTML was encoding the '#' symbol in his column name as 'FIELDNAMEP_'. For the column sort feature to work on that field, the field needs to be referenced as 'FIELDNAME#'. Once he made this change, the column sort on this field worked correctly. New m-Power reports or recompiled ones (I have just tested this) are correctly generating the code as 'FIELDNAME#'.
Asked on September 4, 2020