title: Pentaho 'org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query:
body: <p>I have recently installed Pentaho according to the manual. I have set up a simple database <code>survey</code> and run a simple query, Query1 <code>SELECT * FROM 'surveys'</code> from JDBC (MySQL). When I preview it from JDBC Data Source, the query runs fine and shows the desired result.</p>
  
  <p>But when I open the Pentaho Report Designer page and click on the Query1, it throws the following exception;</p>
  
  <p><code>ERROR: The query 'Query 1' did not execute successfully. The reason given was: 'org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT * FROM 'surveys'</code></p>