Prepare a query that returns only customers approved for the statement run. Include a stable customer identifier, the parameter value used by the report, the destination and the output format. Keep a missing address visible for correction rather than silently routing it to a default customer.
Map the returned customer value into the report parameter and the address into the Email destination. CRD can also use driver values for the message, filename and delivery type. That allows an agreed folder or printer workflow where email is not appropriate, provided the required destination is configured.
Run the two sample customers to controlled destinations. Check that each statement contains only its own transactions and that the reporting period is correct. Then change one approved delivery instruction in the source and verify the next test uses it.
