Report only displays first row of results

Report only displays first row of results

Postby need2know » Tue Feb 18, 2014 5:40 am

I haven't been using NuBuilder for long and have just started experimenting with reports.

Created a very simple table with 4 columns (id, red, blue, yellow) and 4 rows of numbers

Here is the PHP Data Code from the Report tab


$s = "CREATE TABLE #dataTable# SELECT * from test ";
nuRunQuery($s);

When I run the SQL in PhpMyAdmin it returns 4 rows as expected but the report returns the first row only.

Any help appreciated

thanks
need2know
 
Posts: 2
Joined: Fri Dec 06, 2013 5:38 am

Re: Report only displays first row of results

Postby admin » Tue Feb 18, 2014 11:51 am

need2know,

Could it be that your fields are in a group section?

Steven
admin
Site Admin
 
Posts: 1886
Joined: Mon Jun 15, 2009 9:53 am

Re: Report only displays first row of results

Postby need2know » Wed Feb 19, 2014 3:57 am

I deleted that report and recreated it and it worked this time. Must have done something wrong

thanks
need2know
 
Posts: 2
Joined: Fri Dec 06, 2013 5:38 am

Re: Report only displays first row of results

Postby admin » Fri Feb 21, 2014 10:56 am

ok.
admin
Site Admin
 
Posts: 1886
Joined: Mon Jun 15, 2009 9:53 am


Return to Report Writer