v 1.0.0 Eclipse BIRT Designer Version 4.6.0.v201606072122

Version string

1.0.0 in /templates/blank_report.gif ltr 120

static string true

simple text-box Unformatted

static string true

simple text-box Unformatted

static string true

simple text-box Unformatted

static boolean true

False

simple check-box

static true string true

1620189824

simple false text-box Unformatted

static true string true

1620247424

simple false text-box Unformatted

static false string true

dd MMM y HH:mm:ss

simple text-box Unformatted

static string true

simple text-box Unformatted

metadataBidiFormatStr ILYNN

disabledMetadataBidiFormatStr

contentBidiFormatStr ILYNN

disabledContentBidiFormatStr

com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/sog gis

Z2lz

usr_id dimension

keyholder_id

fullname dimension

fullname

param_1 start_date string -1 1 true false param_2 end_date string -1 2 true false

1 usr_id string 2 fullname string

Glam

1 usr_id keyholder_id string 12 2 fullname fullname string 12

? AND glam_access_point_log.key_log_time < ?)]]>

2.0 user_id 1 12 36 0 NotNullable user_id user_id 36 fullname 2 12 193 0 Nullable fullname fullname 193 ]]>

nulls lowest

param_1 start_date string -1 1 true false param_2 end_date string -1 2 true false param_3 string -1 3 0 true false

1 log_date date-time 2 log_notification_id integer 3 key_log_time integer 4 notification_desc string 5 point_desc string 6 access_point_description string 7 access_point_id string 8 is_deleted integer 9 transaction_job_card string 10 key_box_no string 11 ap_asset_serial string 12 reason_text string 13 logged_on date-time

false Glam

1 log_date log_date date-time 2 log_notification_id log_notification_id integer 3 key_log_time key_log_time integer 4 notification_desc notification_desc string 5 point_desc point_desc string 6 access_point_description access_point_description string 7 access_point_id access_point_id string 8 is_deleted is_deleted integer 9 transaction_job_card transaction_job_card string 10 key_box_no key_box_no string 11 ap_asset_serial ap_asset_serial string 12 reason_text reason_text string 13 logged_on logged_on date-time

? AND glam_access_point_log.key_log_time < ?) AND glam_access_point_log.keyholder_id = ? ]]>

a4 landscape

14pt

Keyholder Activity Report

html

new Date()]]>

auto auto auto FilteredKeyholders

user_id

dataSetRow["usr_id"] string true fullname

fullname

dataSetRow["fullname"] string

40 5pt5pt20pt5ptalways10.78125inkeyholderLogs

param_3

row["user_id"]

key_log_time

new Date(dataSetRow["key_log_time"]*1000) time true access_point_description

access_point_description

dataSetRow["access_point_description"] string key_box_no

key_box_no

dataSetRow["key_box_no"] string notification_desc

notification_desc

dataSetRow["notification_desc"] string MyRowCount integer COUNT

Expression dataSetRow["key_log_time"]

true log_date

log_date

var temp =dataSetRow["log_date"] var format = params["date_format"].value; Formatter.format(temp,format) string true test

test

dataSetRow["log_date"] date-time true Column Binding row._outer["fullname"] string true point_desc

point_desc

dataSetRow["point_desc"] string access_point_id

access_point_id

dataSetRow["access_point_id"] string true is_deleted

is_deleted

dataSetRow["is_deleted"] string true transaction_job_card

transaction_job_card

var transaction_details = dataSetRow["transaction_job_card"] if (dataSetRow["transaction_job_card"] != null && dataSetRow["reason_text"] != null) { transaction_details = dataSetRow["transaction_job_card"] + " : " + dataSetRow["reason_text"] } else if (dataSetRow["reason_text"] != null) { transaction_details = dataSetRow["reason_text"] } transaction_details string true ap_asset_serial

ap_asset_serial

dataSetRow["ap_asset_serial"] string Column Binding_1 row._outer["fullname"] string true keyholder_fullname

keyholder_fullname

row._outer["fullname"] string true transaction_reason

transaction_reason

dataSetRow["reason_text"] string true logged_on

logged_on

var temp = dataSetRow["logged_on"]; if (temp == null) { "" } else { var format = params["date_format"].value; Formatter.format(temp,format) } string true

row._outer["fullname"] 38mm 40mm 40mm 20mm 40mm 40mm 0.5833333333333334in 30mm 45mm

0.3in

all row["MyRowCount"] <1

1 1 #000000 solid 1px #000000 solid 1px #000000 solid 1px #000000 solid 1px medium bold 5pt left

Date