The "You are currently missing a single quote. Please revise your formula and try again" error is generated when running a user report that contains at least a Custom SQL field where there is an odd number of single quotes used within the field.
Example of a report which reports the Effective Date for the specified Line Item Names where one of the names uses a single quote as an apostrophe (Children's Education).
To remove the error, replace the apostrophe with '+char(39+'. So that 'Children's Education' becomes 'Children'+char(39)+'s education'
The above fix can also be applied when encountering an "incorrect syntax near" error when running a user report similar to the screenshot below.
