Printing Contractors on Building Ticket

You can now include the first 5 contractors entered for Building permits when printing the "Building Ticket" report from the Inspection Reports Screen. The field values are "contractor1", "contractor2", etc. Note that if there are no contractors listed for a permit these field value result in a NULL value. You can use the function NVL() to eliminate the printing of the word "null" on your reports. So for example the field expression for the first contractor would be: NVL(contractor1,"").