Report only displays first row of results

[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

[admin]

need2know,

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

Steven

[need2know]

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

thanks

[admin]

ok.