Get all taxes in the orders grid

Question

I have a list of taxes in Magento 1.9 and I need to display all this available taxes in the admin Order Grid. I found all this taxes in database in the sales_order_tax. Is there any way to display all this taxes?

My database table is look like this:

So the idea is: each tax must have their own column in the order grid

columns:

• HST-ON;
• HST-NS;
• GST;
• PST-BC;

I try something like this but is not work:

$collection->getSelect()->joinLeft(
    array('sf' => $resource->getTableName('sales_order_tax')),
    'sf.entity_id=main_table.order_id',
    array(
        'sf.code'

    )
);

Answer 1

Copy the file from path: app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php to app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php

Please use the below join,

$collection->getSelect()->joinLeft(array('sf' => 'sales_order_tax'),'sf.order_id=main_table.entity_id',array('sf.amount'));

Add the tax column under _prepareColumns(),

 $this->addColumn('tax_amount', array(
            'header' => Mage::helper('sales')->__('Tax Amount'),
            'index' => 'amount',
            'type'  => 'currency',
            'currency' => 'order_currency_code',
        ));

Hope this will help you.

Thank you!