CREATE VIEW jobsheet_report_closed AS
SELECT * FROM jobsheet_report_last_entry

WHERE jr_jobcomp=-1;