The Payments Report brings together sales revenue, payments made to contributors and any added costs. This is currently just a view that is automatically created when you add information to your Royalties module. It does not offer functionality to drill into the row.
If you want to see payments only, you should just use the payments / advances menu item instead of this option. This is a detailed drilling into payments, but the search on the normal screen will generally find what you require as it searches both title and payee.
Path: Sales / Royalties > Royalties Reports > Payments
When you select Payments from the main Royalties Reports, you will be taken to the screen where you can see the list of all your payments:
You can filter your payments by Book Title, Contributor, or for a particular period if you select dates in From, To boxes, or by Type if you check correct boxes Return, Sale, Adjustment.
To download the report click on Download XSL