nuBuilder Forum

I'm trying to create a report. I've got the forms put together and created an SQL query that works. However, when I try to run the report, I get the following:

SELECT ``.* FROM `` WHERE = '150d680184d5bf'

The SQL query looks like this:

$s = "CREATE TABLE #dataTable# SELECT * ";
$s .= "FROM result ";
$s .= "LEFT JOIN team ON res_team_id = team_id ";
$s .= "LEFT JOIN wl ON res_winloss_wl_id = wl_id ";
$s .= "LEFT JOIN location ON res_homeVist = loc_id ";
$s .= "ORDER BY res_date ASC , res_gameNumber ASC ";

nuRunQuery ($s);

Any help would be great. (Also, if there is a more indepth tutorial on the report, I'd love that.)

Sorry to double post. I'm new at PHP, but love the possibilities of this app. Revised my SQL query to make it only select * from one table. Now I get this error:

Fatal error: Class 'Reporting' not found in /Applications/AMPPS/www/nubuilder/productionnu2/runreport.php on line 33

.

chrisb,

Have you designed the look for the report?

It sounds like there is some field in the report builder it doesn't like.

I suggest cloning the report and removing a field at at time until works.

Let us know if you find the answer so I can stop it happening in future versions.

Steven