AOR_Reports - main group sql query sanitizing

[jellydonuts]

Noticed that if you create a report where you reference a field as the main group and that field contains certain control characters (like a single quote), the character makes it through all the way to the sql query and results in funky behaviour.

Eg main group set to name of account, one of the account names is "Mary's". This group will show in the results but all of the results will be missing because the sql select where clause is "where name is 'Mary's'... "

[jellydonuts]

Still not 100% fixed... the functionality works, but now the main group's name is escaped... see attached picture.