How To Create A Report in Magento

How To Create A Report in Magento

July 2, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How To Create A Report in Magento

Creating Reports in Magento: A Comprehensive Guide

Reports are an essential part of any e-commerce platform, providing valuable insights into sales trends, customer behavior, and business performance. In this post, we’ll walk you through the process of creating custom reports in Magento, leveraging the powerful grid widget system used throughout the admin panel.

Getting Started with Magento Admin Controllers

Before diving into report creation, it’s crucial to have a solid understanding of how to work with Magento’s admin controllers. Alan Storm provides an excellent tutorial on this topic: https://alanstorm.com/magento_admin_controllers. This guide will help you get familiar with the basics of working in the admin panel and setting up your first controller.

Understanding Magento Grid Widgets

The grid widgets used throughout the Magento admin panel form the foundation for building reports. These widgets allow you to display complex data sets in a user-friendly, tabular format. To create a report that behaves like these grid widgets:

  1. Create a Block: Start by creating a new block file under your custom module’s Block/Adminhtml directory. This block will serve as the container for your grid.
// app/code/Vendor/Module/Block/Adminhtml/Report.php

namespace Vendor\Module\Block\Adminhtml;

class Report extends \Magento\Backend\Block\Widget\Grid\Container
{
    protected $_blockGroup = 'Vendor_Module';
    protected $_controller = 'adminhtml_report';

    public function __construct(\Magento\Framework\View\Element\Context $context, array $data = [])
    {
        parent::__construct($context, $data);
    }
}
  1. Create a Controller: Next, create the controller that will handle the request for your report.
// app/code/Vendor/Module/Controller/Adminhtml/Report.php

namespace Vendor\Module\Controller\Adminhtml;

class Report extends \Magento\Backend\App\Action
{
    public function execute()
    {
        $this->_view->loadLayout();
        $this->_setActiveMenu('Vendor_Module::report');
        $this->_addBreadcrumb(__('Reports'), __('Reports'));
        $this->_addContent($this->_view->getLayout()->createBlock('Vendor\Module\Block\Adminhtml\Report'));
        $this->_renderLayout();
    }
}

Building the Grid

The magic happens in your grid block, where you define the data source and layout of your report.

  1. Create a Grid Block: Extend Magento’s AbstractGrid class to create your custom grid block.
// app/code/Vendor/Module/Block/Adminhtml/Report/Grid.php

namespace Vendor\Module\Block\Adminhtml\Report;

class Grid extends \Magento\Backend\Block\Widget\Grid\AbstractGrid
{
    protected $collection;
    protected $_backendSession = null;

    public function __construct(\Magento\Framework\View\Element\Context $context, array $data = [], \Magento\Backend\Model\Session $session, \Magento\Sales\Model\ResourceModel\Report\CollectionFactory $collection)
    {
        parent::__construct($context, $data);
        $this->_backendSession = $session;
        $this->collection = $collection;
    }

    protected function _prepareCollection()
    {
        $collection = $this->collection->create();
        // Add your collection setup here

        $this->setCollection($collection);
    }

    public function getRowUrl($row)
    {
        return $this->getUrl('vendor_module/adminhtml_report/view', ['id' => $row->getId()]);
    }
}
  1. Configure the Grid: In your grid block, you’ll need to configure columns and set up any filters or actions required for your report.
// app/code/Vendor/Module/Block/Adminhtml/Report/Grid.php

protected function _prepareColumns()
{
    $this->addColumn(
        'column_id',
        [
            'header' => __('Column Header'),
            'index'  => 'column_index', // Index of the column in your collection
            'type'   => 'text'
        ]
    );
}

Bringing It All Together

With these steps, you now have a solid foundation for creating custom reports in Magento. Remember to:

  • Create the necessary layout XML files to define where your report appears in the admin menu.
  • Ensure your module is properly configured and enabled in app/etc/config.php.
  • Test your report thoroughly before deploying it to a production environment.

Creating reports in Magento requires a good understanding of the platform’s architecture, but with this guide, you’re well on your way to building powerful analytical tools for your store. For more advanced techniques or specific use-cases, don’t hesitate to explore the Magento Developer Resource Center and the community forums.

Happy coding!

Performance Extensions Admin Configuration

Our network