Transaction report pass through accounts payable

[Nate Dudenhoeffer]

I use gnucash for business accounting, and am trying to create a report
from my main checking account, which shows the "other account" for each
transaction.  Of course, showing splits.  The problem is the majority of my
transactions have "Accounts Payable" as the "other account."  How can I
generate a report which will show the splits defined on the bills for each
transaction in my checking account?