Page 1 of 1

Report only displays first row of results

PostPosted: Tue Feb 18, 2014 5:40 am
by need2know
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

Re: Report only displays first row of results

PostPosted: Tue Feb 18, 2014 11:51 am
by admin
need2know,

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

Steven

Re: Report only displays first row of results

PostPosted: Wed Feb 19, 2014 3:57 am
by need2know
I deleted that report and recreated it and it worked this time. Must have done something wrong

thanks

Re: Report only displays first row of results

PostPosted: Fri Feb 21, 2014 10:56 am
by admin
ok.