= $P{startDate}
AND a.activity_start_time <= date_add($P{endDate}, INTERVAL "23:59:59" HOUR_SECOND)
AND (a.arch_short_name LIKE "act.customerAccountCharges%")
GROUP BY
location_name, clinician_name,customer_id) as b
GROUP BY
location_name, clinician_name]]>
<band splitType="Stretch"/>