= $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.customerAccountChargesCounter") OR (acts.arch_short_name = "act.customerAccountChargesCounter") OR (acts.arch_short_name = "act.customerAccountChargesCredit") OR (acts.arch_short_name = "act.customerAccountChargesInvoice") OR (acts.arch_short_name = "act.customerAccountBadDebt") OR (acts.arch_short_name = "act.customerAccountCreditAdjust") OR (acts.arch_short_name = "act.customerAccountDebitAdjust") OR (acts.arch_short_name = "act.customerAccountInitialBalance")) GROUP BY formatted_date ORDER BY acts.activity_start_time ASC]]>