If you run reports and or layouts and get the message “Error 42S22 Column Not Found”, there are probably issues with the variables or section filters in the reports.

This issue is quite easily rectified, please follow the instructions below:

1. Attempt to edit the report / View Menu / Preview / then click OK when the error message appears.
2. Error List pane / select the first error, then:
If the cause of the error is a variable, that variable is selected on the design window. Click the variable / click on Delete / then replace the variable if required.
If the cause is a section filter, nothing is selected in the design window. Double click the error to open up the Expression Editor window, amend or remove the filter as required then click OK
3. Make sure that you save the document with a new description and file name.
4. Run the report again, you should find that it will run without any problems.

Bookmark It