This may occur if you have customer records in Access PaySuite DDCMS that don't have an associated Direct Debit contract.
To return a report excluding Customers without a Contract, add a NOTNULL filter to the Contracts.DirectDebitRef field before running the report.
Custom report for contracts showing empty record
Explanation of why a custom report may be returning more records than expected, including blank or null rows.
O
Written by Ollie Denning