= $P{startDate} AND acts.activity_start_time <= date_add($P{endDate}, INTERVAL "23:59:59" HOUR_SECOND) AND (Status = "POSTED") AND (participations.arch_short_name = "participation.customer") AND ((acts.arch_short_name = "act.customerAccountPayment") OR (acts.arch_short_name = "act.customerAccountRefund") ) ORDER BY acts.activity_start_time ASC]]> <band splitType="Stretch"/>