Why dbBee does not always sort my report when I click the column header (some columns work, and some don't)?

dbBee does not allow sorting upon fields (columns) that contain non-ascii characters (i.e. accented characters, Arabic, Hebrew, Asian, Greek alphabets, Cyrillic, Affricates, etc.). Due to way dbBee handles embedding the projects and passing the request variables to the script, it is not possible to pass sort parameter if the field name contains above-mentioned (non-ascii) characters.

You can solve this issue by renaming your fields using English alphabet only A-z0-9. You should change only the field names, while your labels still can contain non-ascii characters.
Renaming the fields will require rebuilding all the projects that use the same database table.