I have a slight variation on this. We have created a report for all cash transactions against our bank account for a time period. As part of this report, there is a "split" column, which shows which account the transaction affected. However, the report only shows the last part of that field.

For example if we have expenses for general labor used in the manufacturing process, under our Expenses, we have a COA entry of MANUFACTURING, and under that, an account for LABOR.

The report only shows LABOR, under the Split heading. Unfortunately, since we have multiple different accounts that use LABOR, just showing that last part of the account name is confusing. 

We would like to expand what gets put into the "split" column to include the full name of an account, in this case MANUFACTURING:LABOR

how can we do that?