We need to calculate the final payroll Journal, unfortunately the figures for PAYE has to come from the extensive and complicate cumulative basis calculations. Now all I want here is to find out the following:
(1) How to put the Salary journal report consolidating all the PAYE by staff in the report footer
(2) Hide the detail part which shows calculation by staff, so that when printing only the staff on the report footer should show.
(3) The details part of the report will have all the calculations for the staff to supply the footer report or act as the recordset but must be hidden so that only the report footer shows only.