v 1.0.0 Eclipse BIRT Designer Version 4.6.0.v201606072122 queryText 584 queryTimeOut 584 rowFetchSize 584 odaDriverClass 8 odaURL 8 odaUser 8 odaAutoCommit 8 odaIsolationMode 8 odaPassword 8 odaJndiName 8 OdaConnProfileName 8 OdaConnProfileStorePath 8 in /templates/blank_report.gif ltr 96 static false string true dd MMM y HH:mm:ss simple text-box Unformatted static true string true 2023-01-01 00:00:00 simple false text-box Unformatted static true string true 2023-12-01 23:59:59 simple false text-box Unformatted static boolean true False simple check-box static false string true % simple text-box Unformatted metadataBidiFormatStr ILYNN disabledMetadataBidiFormatStr contentBidiFormatStr ILYNN disabledContentBidiFormatStr com.mysql.jdbc.Driver jdbc:mysql://127.0.0.1:3306/sog gis Z2lz nulls lowest gsil_outcome dimension gsil_outcome gsil_outcome gsil_reason dimension gsil_reason gsil_reason gsil_comment dimension gsil_comment gsil_comment gsil_created_on dimension gsil_created_on gsil_created_on site_name dimension site_name site_name created_firstname dimension created_firstname created_firstname created_lastname dimension created_lastname created_lastname lock_name dimension lock_name lock_name key_box_no dimension key_box_no key_box_no keyholder_firstname dimension keyholder_firstname keyholder_firstname keyholder_lastname dimension keyholder_lastname keyholder_lastname start_date start_date string -1 1 true false end_date end_date string -1 2 true false 1 gsil_outcome string 2 gsil_reason string 3 gsil_comment string 4 gsil_created_on date-time 5 site_name string 6 created_firstname string 7 created_lastname string 8 lock_name string 9 key_box_no string 10 keyholder_firstname string 11 keyholder_lastname string glam 1 gsil_outcome gsil_outcome string 12 2 gsil_reason gsil_reason string 12 3 gsil_comment gsil_comment string 12 4 gsil_created_on created_on date-time 93 5 site_name point_desc string 12 6 created_firstname usr_firstname string 12 7 created_lastname usr_lastname string 12 8 lock_name access_point_description string 12 9 key_box_no key_box_no string 12 10 keyholder_firstname usr_firstname string 12 11 keyholder_lastname usr_lastname string 12 2.0 gsil_outcome 1 12 9 0 NotNullable gsil_outcome gsil_outcome 9 gsil_reason 2 12 30 0 NotNullable gsil_reason gsil_reason 30 gsil_comment 3 12 128 0 Nullable gsil_comment gsil_comment 128 created_on 4 93 19 0 NotNullable gsil_created_on gsil_created_on 19 point_desc 5 12 255 0 Nullable site_name site_name 255 usr_firstname 6 12 64 0 Nullable created_firstname created_firstname 64 usr_lastname 7 12 128 0 Nullable created_lastname created_lastname 128 access_point_description 8 12 256 0 Nullable lock_name lock_name 256 key_box_no 9 12 64 0 Nullable key_box_no key_box_no 64 usr_firstname 10 12 64 0 Nullable keyholder_firstname keyholder_firstname 64 usr_lastname 11 12 128 0 Nullable keyholder_lastname keyholder_lastname 128 ]]> landscape 14pt Site Inspection Report html new Date()]]> SiteInspectionLog gsil_outcome gsil_outcome if (dataSetRow["gsil_outcome"] == 'SUCCEEDED') { "Succeeded" } else { "Failed" } string true gsil_reason gsil_reason if (dataSetRow["gsil_reason"] == 'EVERYTHING_LOCKED') { "Everything locked" } else if (dataSetRow["gsil_reason"] == 'KEYS_REQUIRED_DOCKED') { "Key needs to be docked" } else if (dataSetRow["gsil_reason"] == 'EXCEPTION_FOR_UNLOCKED') { "Exception made for open locks" } else if (dataSetRow["gsil_reason"] == 'UNLOCKED_NO_EXCEPTION') { "No exception made for open locks" } else if (dataSetRow["gsil_reason"] == 'NO_INSPECTION_MADE') { "No site inspection made" } else { dataSetRow["gsil_reason"] } string true gsil_comment gsil_comment dataSetRow["gsil_comment"] string gsil_created_on gsil_created_on var temp = dataSetRow["gsil_created_on"] var format = params["date_format"].value; Formatter.format(temp,format) string true site_name site_name dataSetRow["site_name"] string created_firstname created_firstname dataSetRow["created_firstname"] string created_lastname created_lastname dataSetRow["created_lastname"] string lock_name lock_name dataSetRow["lock_name"] string key_box_no key_box_no dataSetRow["key_box_no"] string keyholder_firstname keyholder_firstname dataSetRow["keyholder_firstname"] string keyholder_lastname keyholder_lastname dataSetRow["keyholder_lastname"] string created_by created_by dataSetRow["created_firstname"] + " " + dataSetRow["created_lastname"] string true keyholder_fullname keyholder_fullname if (dataSetRow["keyholder_firstname"]==null && dataSetRow["keyholder_lastname"]==null) { "" } else { dataSetRow["keyholder_firstname"] + " " + dataSetRow["keyholder_lastname"] } string true

solid thin solid thin solid thin solid thin none none none none Site solid thin solid thin solid thin solid thin none none none none Outcome solid thin solid thin solid thin solid thin none none none none Reason solid thin solid thin solid thin solid thin none none none none 1pt 1pt 1pt 1pt Comment solid thin solid thin solid thin solid thin none none none none 1pt 1pt 1pt 1pt Created On solid thin solid thin solid thin solid thin none none none none Created by solid thin solid thin solid thin solid thin none none none none Lock solid thin solid thin solid thin solid thin none none none none Box No solid thin solid thin solid thin solid thin none none none none Keyholder

none none none none solid thin solid thin solid thin solid thin site_name solid thin solid thin solid thin solid thin gsil_outcome solid thin solid thin solid thin solid thin gsil_reason solid thin solid thin solid thin solid thin gsil_comment solid thin solid thin solid thin solid thin gsil_created_on solid thin solid thin solid thin solid thin created_by solid thin solid thin solid thin solid thin lock_name solid thin solid thin solid thin solid thin key_box_no solid thin solid thin solid thin solid thin keyholder_fullname new Object() report null report