Report is listing jobs by employee to do for week and has columns across the page with the days of the week for employees to fill in hours against each job. Each text box has a solid border so a grid is printed. At the bottom of the page there is a footer with spaces to total the hours for each day.
The report is usually 2-3 pages for each employee. They get one off jobs which they manually enter on the sheet and it would be good to extend the grid so they use the rest of the page.
Report works fine but finishes depending on the number of jobs on the last page for each employee.
I am trying to get the footer to print at the bottom of the page and for the gap between the end of the detail line and the top of the footer to be filled with a grid so additional jobs can be entered. This could be repeating a line of blank text boxes or drawing lines on the report.
I can draw the lines etc just need to know how to work out the gap and which event to use to draw the lines.
I have been thinking of adding an additional footer and setting the hieght of this based on the bottom of the detail section and top of the footer section. I think I need to set a report variable for the top of these when each is formated?. but not sure which events to use.