Beside the pension assessment - is there a pension report that shows the current pension contribution percentage that was used on a particular pay run?

Ideally we would like to be able to run a report that shows the pension contributions and percentages for a historical pay run - we have tried the Pension Payments report and editing this to add in the percentages but finding that it duplicates lines for any employee who has had more than one pension scheme when running the report to Excel but when printing the report it isn't duplicating but is pulling the old percentage rates for any employees who have had more than one pension scheme. It feels like it could be just a setting in the report that we can easily change to only pull current rates?