Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Report only displays first row of results

Locked
need2know
Posts: 2
Joined: Thu Dec 05, 2013 9:08 pm

Report only displays first row of results

Unread post 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
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Report only displays first row of results

Unread post by admin »

need2know,

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

Steven
need2know
Posts: 2
Joined: Thu Dec 05, 2013 9:08 pm

Re: Report only displays first row of results

Unread post by need2know »

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

thanks
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Report only displays first row of results

Unread post by admin »

ok.
Locked