= $P{Start Date} AND a.activity_start_time <= date_add($P{End Date}, INTERVAL "23:59:59" HOUR_SECOND) AND (a.arch_short_name LIKE "act.customerAccount%item") GROUP BY date_format(a.activity_start_time, '%m%Y') ORDER BY a.activity_start_time ASC]]> <band height="0" isSplitAllowed="true" > </band>