Report using MySQL Rollup seems to create random results

[anorman]

Hello,

I am creating a report, and am pulling together a couple tables within the SQL select statement to make the report table. In that sql statement, I use sum and rollup functions. The table itself is giving the proper answers (I manually issued the SQL statement to mysql and verified that it creates all the proper data, including the NULL rows at the end of each group for "summary" data and then an overall NULL (I have 2 group by columns, so it does a group for each client and then an overall at the end of the report). The problem is, when the report itself is created, it appears that it randomly prints out the NULL row, instead of always having the NULL row as the last row in each group, and hence isn't always displaying the proper summary data..?? Also, it seems to actually print out a "NULL" Row instead of just realizing that it is the "summary" rows and printing out the final data..

I assume I am either doing something wrong, or misunderstanding what can/cannot be done with reports..

Thanks,
- Andre

[admin]

Andre,

The report writer creates its own "Rollup" by using header and footer sections.

It also uses these sections to "Order By".

The report writer will just gets confused if you do this for it.


Steven