Transaction Error in Report builder

Transaction Error in Report builder

Postby chrisb » Sun Dec 23, 2012 11:36 pm

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.)
chrisb
 
Posts: 12
Joined: Mon Oct 29, 2012 1:48 pm

Re: Transaction Error in Report builder

Postby chrisb » Mon Dec 24, 2012 6:20 am

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
 
Posts: 12
Joined: Mon Oct 29, 2012 1:48 pm

Re: Transaction Error in Report builder

Postby admin » Thu Dec 27, 2012 8:33 am

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
admin
Site Admin
 
Posts: 3077
Joined: Mon Jun 15, 2009 9:53 am


Return to Report Writer