Hello, I was wondering if it was possible to set the print whole report page to break after each group. Im using phprunner 4.1(303) AND I am grouping by employee id and date. my select statement is set to only show records that match this week number "WHERE WEEK(`time card`.`Date`,7) = WEEK(CURRENT_DATE,7)"
So what i need is the print whole report page too do is page break after each employee id like this.
oh and there can be multiple records for each day so i cant just limit the number of records per page to seven sadly.
//page 1
employee id - 0001
monday total hrs worked
day sub total
tuesday total hrs worked
day sub total
wensday total hrs worked
day sub total
thursday total hrs worked
day sub total
friday total hrs worked
day sub total
saterday total hrs worked
day sub total
sunday total hrs worked
week sub total
page break
//page 2
employee id - 0002
monday total hrs worked
day sub total
tuesday total hrs worked
day sub total
wensday total hrs worked
day sub total
thursday total hrs worked
day sub total
friday total hrs worked
day sub total
saterday total hrs worked
day sub total
sunday total hrs worked
week sub total
page break
//page 3
employee id - 0003
monday total hrs worked
day sub total
tuesday total hrs worked
day sub total
wensday total hrs worked
day sub total
thursday total hrs worked
day sub total
friday total hrs worked
day sub total
saterday total hrs worked
day sub total
sunday total hrs worked
week sub total
thank you for any help or idea's any one might have to come up with a solution to this.
thank you Travis Wilson
