I'm creating some reports with some SQLite data. One report groups data by one column and subtotals each group.
It's working well but it really doesn't look right when the last item in a group is at the bottom of the page and the subtotal is then orphaned on the start of the next page. I really need some way to determine if the next row starts a new group, and then take steps to keep the current row on the same page as my subtotals if it is. Is there any way to peak at the next row without losing the current row? Or does anyone have any other suggestions for orphan control? Thanks. -- View this message in context: http://www.nabble.com/Any-Way-to-Peak-at-Next-Row--tp22448225p22448225.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
