How to customize AR statements .rdf to group by customer not statement
Hi,
I am creating a custom .rdf based on the standard ARXSGPO.rdf report. I have included the customer email address in the SQL query and this is visible in the xml output. I have included a call to a custom package in the after report trigger to burst the output to email using a bursting control file.
It all works for one customer at a time, because the ARXSGP template groups do not have a customer group but process all statements in one block.
This means all statements get emailed as a single file to the first email in the group. Has anyone been able to alter this behavior?