Created a new report but can’t see it after generation

Hi,

This is probably more a how-to-use question as I only installed your plugin this morning.

I have written my sql query and it works against the live database when I run it directly from MySQL Workbench but I can’t get any output when used through the plugin on a test installation.

Example Posts report – they don’t have any posts!
Example Pages report –

• I generated it by using the following link: https://test.essa.org.uk/wp-content/plugins/exports-and-reports/api.php?report=1&exports_and_reports_download=1&export_type=csv&action=json&token=9601fcad8ad4766723d14f59b3d0336b&debug=1
• In the Reports option, after pressing Search, I can see it
• I changed the query to look for a specific id, regenerated the report, and the new version showed in the Reports page.

New Daily Participants report –

• created new report with my desired query and generated it using the same link as above (changed the report id to 3)
• in the Reports option I cannot see the report
• There’s no data in the test database for my where clause, so widened the search criteria; still nothing after I’d regenerated
• simplified the query down to “select ans_id, reg_id, qst_id, ans_value
  from wpsq_esp_answer” and regenerated, but still cannot see in the Reports option. There are over 71,000 records in this table

The page I need help with: [log in to see the link]