Magento 2 Custom Report grid is not working












2














Is anyone has created custom Report grid in Magento 2 Admin panel?



We have started to create a report but we are facing an issue with display data and while we click on "Refresh" button entire page is messed up.



<?xml version="1.0"?>

<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">

<update handle="reports_report_grid"/>

<body>

    <referenceBlock name="adminhtml.report.grid">

        <arguments>

            <argument name="id" xsi:type="string">gridMaterialReport</argument>

            <argument name="dataSource" xsi:type="object">CommercepunditCoreAdminOrderModelResourceModelMaterialCollectionInitial</argument>

        </arguments>

    </referenceBlock>

    <referenceBlock name="adminhtml.report.grid.export">

        <arguments>

            <argument name="exportTypes" xsi:type="array">

                <item name="csv" xsi:type="array">

                    <item name="urlPath" xsi:type="string">*/*/exportOrdersCsv</item>

                </item>

                <item name="excel" xsi:type="array">

                    <item name="urlPath" xsi:type="string">*/*/exportOrdersExcel</item>

                </item>

            </argument>

        </arguments>

    </referenceBlock>

    <referenceBlock name="adminhtml.report.grid.columnSet">

        <arguments>

            <argument name="count_totals" xsi:type="string">1</argument>

        </arguments>

        <block class="MagentoBackendBlockWidgetGridColumn" name="adminhtml.report.grid.columnSet.order_id" as="order_id">

            <arguments>

                <argument name="header" xsi:type="string" translate="true">Order Id</argument>

                <argument name="sortable" xsi:type="string">0</argument>

                <argument name="type" xsi:type="string">text</argument>

                <argument name="index" xsi:type="string">order_id</argument>

                <argument name="id" xsi:type="string">order_id</argument>

                <argument name="column_css_class" xsi:type="string">col-name</argument>

                <argument name="header_css_class" xsi:type="string">col-name</argument>

            </arguments>

        </block>

        <block class="MagentoBackendBlockWidgetGridColumn" name="adminhtml.report.grid.columnSet.sqft" as="sqft">

            <arguments>

                <argument name="header" xsi:type="string" translate="true">Sqft</argument>

                <argument name="sortable" xsi:type="string">0</argument>

                <argument name="type" xsi:type="string">number</argument>

                <argument name="index" xsi:type="string">sqft</argument>

                <argument name="total" xsi:type="string">sum</argument>

                <argument name="id" xsi:type="string">sqft</argument>

                <argument name="column_css_class" xsi:type="string">col-qty</argument>

                <argument name="header_css_class" xsi:type="string">col-qty</argument>

            </arguments>

        </block>

    </referenceBlock>

</body>




+++++++++++++++++



enter image description here



While we can click on Refresh entire page is look like below.



enter image description here



Can anyone help me on this??



Thanks,






magento2 magento2.2







share|improve this question
























  • can you remove <arguments> <argument name="count_totals" xsi:type="string">1</argument> </arguments>
    – Pritam Info 24
    Dec 7 '18 at 13:14










  • @PritamInfo24: I have resolved that issue, there was a collection issue in the Resource model I have added _joinFields and setDateRange function. now, i am getting "ReportJsObject is not defined". Please find link for more information: prnt.sc/lrz56b Do you have any idea??
    – Ketan Panchal
    Dec 7 '18 at 13:36












  • Did you use $this->getSelect() in your collection class to check the select query is ok or not.
    – Pritam Info 24
    Dec 7 '18 at 13:50










  • Yes it's working fine. $this->getSelect()->addFieldToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
    – Ketan Panchal
    Dec 7 '18 at 13:51












  • Can you try this $this->getSelect(); $this->addAttributeToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
    – Pritam Info 24
    Dec 7 '18 at 14:08
















2














Is anyone has created custom Report grid in Magento 2 Admin panel?



We have started to create a report but we are facing an issue with display data and while we click on "Refresh" button entire page is messed up.



<?xml version="1.0"?>

<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">

<update handle="reports_report_grid"/>

<body>

    <referenceBlock name="adminhtml.report.grid">

        <arguments>

            <argument name="id" xsi:type="string">gridMaterialReport</argument>

            <argument name="dataSource" xsi:type="object">CommercepunditCoreAdminOrderModelResourceModelMaterialCollectionInitial</argument>

        </arguments>

    </referenceBlock>

    <referenceBlock name="adminhtml.report.grid.export">

        <arguments>

            <argument name="exportTypes" xsi:type="array">

                <item name="csv" xsi:type="array">

                    <item name="urlPath" xsi:type="string">*/*/exportOrdersCsv</item>

                </item>

                <item name="excel" xsi:type="array">

                    <item name="urlPath" xsi:type="string">*/*/exportOrdersExcel</item>

                </item>

            </argument>

        </arguments>

    </referenceBlock>

    <referenceBlock name="adminhtml.report.grid.columnSet">

        <arguments>

            <argument name="count_totals" xsi:type="string">1</argument>

        </arguments>

        <block class="MagentoBackendBlockWidgetGridColumn" name="adminhtml.report.grid.columnSet.order_id" as="order_id">

            <arguments>

                <argument name="header" xsi:type="string" translate="true">Order Id</argument>

                <argument name="sortable" xsi:type="string">0</argument>

                <argument name="type" xsi:type="string">text</argument>

                <argument name="index" xsi:type="string">order_id</argument>

                <argument name="id" xsi:type="string">order_id</argument>

                <argument name="column_css_class" xsi:type="string">col-name</argument>

                <argument name="header_css_class" xsi:type="string">col-name</argument>

            </arguments>

        </block>

        <block class="MagentoBackendBlockWidgetGridColumn" name="adminhtml.report.grid.columnSet.sqft" as="sqft">

            <arguments>

                <argument name="header" xsi:type="string" translate="true">Sqft</argument>

                <argument name="sortable" xsi:type="string">0</argument>

                <argument name="type" xsi:type="string">number</argument>

                <argument name="index" xsi:type="string">sqft</argument>

                <argument name="total" xsi:type="string">sum</argument>

                <argument name="id" xsi:type="string">sqft</argument>

                <argument name="column_css_class" xsi:type="string">col-qty</argument>

                <argument name="header_css_class" xsi:type="string">col-qty</argument>

            </arguments>

        </block>

    </referenceBlock>

</body>




+++++++++++++++++



enter image description here



While we can click on Refresh entire page is look like below.



enter image description here



Can anyone help me on this??



Thanks,






magento2 magento2.2







share|improve this question
























  • can you remove <arguments> <argument name="count_totals" xsi:type="string">1</argument> </arguments>
    – Pritam Info 24
    Dec 7 '18 at 13:14










  • @PritamInfo24: I have resolved that issue, there was a collection issue in the Resource model I have added _joinFields and setDateRange function. now, i am getting "ReportJsObject is not defined". Please find link for more information: prnt.sc/lrz56b Do you have any idea??
    – Ketan Panchal
    Dec 7 '18 at 13:36












  • Did you use $this->getSelect() in your collection class to check the select query is ok or not.
    – Pritam Info 24
    Dec 7 '18 at 13:50










  • Yes it's working fine. $this->getSelect()->addFieldToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
    – Ketan Panchal
    Dec 7 '18 at 13:51












  • Can you try this $this->getSelect(); $this->addAttributeToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
    – Pritam Info 24
    Dec 7 '18 at 14:08














2












2








2







Is anyone has created custom Report grid in Magento 2 Admin panel?



We have started to create a report but we are facing an issue with display data and while we click on "Refresh" button entire page is messed up.



<?xml version="1.0"?>

<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">

<update handle="reports_report_grid"/>

<body>

    <referenceBlock name="adminhtml.report.grid">

        <arguments>

            <argument name="id" xsi:type="string">gridMaterialReport</argument>

            <argument name="dataSource" xsi:type="object">CommercepunditCoreAdminOrderModelResourceModelMaterialCollectionInitial</argument>

        </arguments>

    </referenceBlock>

    <referenceBlock name="adminhtml.report.grid.export">

        <arguments>

            <argument name="exportTypes" xsi:type="array">

                <item name="csv" xsi:type="array">

                    <item name="urlPath" xsi:type="string">*/*/exportOrdersCsv</item>

                </item>

                <item name="excel" xsi:type="array">

                    <item name="urlPath" xsi:type="string">*/*/exportOrdersExcel</item>

                </item>

            </argument>

        </arguments>

    </referenceBlock>

    <referenceBlock name="adminhtml.report.grid.columnSet">

        <arguments>

            <argument name="count_totals" xsi:type="string">1</argument>

        </arguments>

        <block class="MagentoBackendBlockWidgetGridColumn" name="adminhtml.report.grid.columnSet.order_id" as="order_id">

            <arguments>

                <argument name="header" xsi:type="string" translate="true">Order Id</argument>

                <argument name="sortable" xsi:type="string">0</argument>

                <argument name="type" xsi:type="string">text</argument>

                <argument name="index" xsi:type="string">order_id</argument>

                <argument name="id" xsi:type="string">order_id</argument>

                <argument name="column_css_class" xsi:type="string">col-name</argument>

                <argument name="header_css_class" xsi:type="string">col-name</argument>

            </arguments>

        </block>

        <block class="MagentoBackendBlockWidgetGridColumn" name="adminhtml.report.grid.columnSet.sqft" as="sqft">

            <arguments>

                <argument name="header" xsi:type="string" translate="true">Sqft</argument>

                <argument name="sortable" xsi:type="string">0</argument>

                <argument name="type" xsi:type="string">number</argument>

                <argument name="index" xsi:type="string">sqft</argument>

                <argument name="total" xsi:type="string">sum</argument>

                <argument name="id" xsi:type="string">sqft</argument>

                <argument name="column_css_class" xsi:type="string">col-qty</argument>

                <argument name="header_css_class" xsi:type="string">col-qty</argument>

            </arguments>

        </block>

    </referenceBlock>

</body>




+++++++++++++++++



enter image description here



While we can click on Refresh entire page is look like below.



enter image description here



Can anyone help me on this??



Thanks,






magento2 magento2.2







share|improve this question















Is anyone has created custom Report grid in Magento 2 Admin panel?



We have started to create a report but we are facing an issue with display data and while we click on "Refresh" button entire page is messed up.



<?xml version="1.0"?>

<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">

<update handle="reports_report_grid"/>

<body>

    <referenceBlock name="adminhtml.report.grid">

        <arguments>

            <argument name="id" xsi:type="string">gridMaterialReport</argument>

            <argument name="dataSource" xsi:type="object">CommercepunditCoreAdminOrderModelResourceModelMaterialCollectionInitial</argument>

        </arguments>

    </referenceBlock>

    <referenceBlock name="adminhtml.report.grid.export">

        <arguments>

            <argument name="exportTypes" xsi:type="array">

                <item name="csv" xsi:type="array">

                    <item name="urlPath" xsi:type="string">*/*/exportOrdersCsv</item>

                </item>

                <item name="excel" xsi:type="array">

                    <item name="urlPath" xsi:type="string">*/*/exportOrdersExcel</item>

                </item>

            </argument>

        </arguments>

    </referenceBlock>

    <referenceBlock name="adminhtml.report.grid.columnSet">

        <arguments>

            <argument name="count_totals" xsi:type="string">1</argument>

        </arguments>

        <block class="MagentoBackendBlockWidgetGridColumn" name="adminhtml.report.grid.columnSet.order_id" as="order_id">

            <arguments>

                <argument name="header" xsi:type="string" translate="true">Order Id</argument>

                <argument name="sortable" xsi:type="string">0</argument>

                <argument name="type" xsi:type="string">text</argument>

                <argument name="index" xsi:type="string">order_id</argument>

                <argument name="id" xsi:type="string">order_id</argument>

                <argument name="column_css_class" xsi:type="string">col-name</argument>

                <argument name="header_css_class" xsi:type="string">col-name</argument>

            </arguments>

        </block>

        <block class="MagentoBackendBlockWidgetGridColumn" name="adminhtml.report.grid.columnSet.sqft" as="sqft">

            <arguments>

                <argument name="header" xsi:type="string" translate="true">Sqft</argument>

                <argument name="sortable" xsi:type="string">0</argument>

                <argument name="type" xsi:type="string">number</argument>

                <argument name="index" xsi:type="string">sqft</argument>

                <argument name="total" xsi:type="string">sum</argument>

                <argument name="id" xsi:type="string">sqft</argument>

                <argument name="column_css_class" xsi:type="string">col-qty</argument>

                <argument name="header_css_class" xsi:type="string">col-qty</argument>

            </arguments>

        </block>

    </referenceBlock>

</body>




+++++++++++++++++



enter image description here



While we can click on Refresh entire page is look like below.



enter image description here



Can anyone help me on this??



Thanks,






magento2 magento2.2




magento2 magento2.2






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited yesterday









Himanshu

704419




704419










asked Dec 7 '18 at 12:10









Ketan Panchal

380111




380111












  • can you remove <arguments> <argument name="count_totals" xsi:type="string">1</argument> </arguments>
    – Pritam Info 24
    Dec 7 '18 at 13:14










  • @PritamInfo24: I have resolved that issue, there was a collection issue in the Resource model I have added _joinFields and setDateRange function. now, i am getting "ReportJsObject is not defined". Please find link for more information: prnt.sc/lrz56b Do you have any idea??
    – Ketan Panchal
    Dec 7 '18 at 13:36












  • Did you use $this->getSelect() in your collection class to check the select query is ok or not.
    – Pritam Info 24
    Dec 7 '18 at 13:50










  • Yes it's working fine. $this->getSelect()->addFieldToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
    – Ketan Panchal
    Dec 7 '18 at 13:51












  • Can you try this $this->getSelect(); $this->addAttributeToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
    – Pritam Info 24
    Dec 7 '18 at 14:08


















  • can you remove <arguments> <argument name="count_totals" xsi:type="string">1</argument> </arguments>
    – Pritam Info 24
    Dec 7 '18 at 13:14










  • @PritamInfo24: I have resolved that issue, there was a collection issue in the Resource model I have added _joinFields and setDateRange function. now, i am getting "ReportJsObject is not defined". Please find link for more information: prnt.sc/lrz56b Do you have any idea??
    – Ketan Panchal
    Dec 7 '18 at 13:36












  • Did you use $this->getSelect() in your collection class to check the select query is ok or not.
    – Pritam Info 24
    Dec 7 '18 at 13:50










  • Yes it's working fine. $this->getSelect()->addFieldToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
    – Ketan Panchal
    Dec 7 '18 at 13:51












  • Can you try this $this->getSelect(); $this->addAttributeToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
    – Pritam Info 24
    Dec 7 '18 at 14:08
















can you remove <arguments> <argument name="count_totals" xsi:type="string">1</argument> </arguments>
– Pritam Info 24
Dec 7 '18 at 13:14




can you remove <arguments> <argument name="count_totals" xsi:type="string">1</argument> </arguments>
– Pritam Info 24
Dec 7 '18 at 13:14












@PritamInfo24: I have resolved that issue, there was a collection issue in the Resource model I have added _joinFields and setDateRange function. now, i am getting "ReportJsObject is not defined". Please find link for more information: prnt.sc/lrz56b Do you have any idea??
– Ketan Panchal
Dec 7 '18 at 13:36






@PritamInfo24: I have resolved that issue, there was a collection issue in the Resource model I have added _joinFields and setDateRange function. now, i am getting "ReportJsObject is not defined". Please find link for more information: prnt.sc/lrz56b Do you have any idea??
– Ketan Panchal
Dec 7 '18 at 13:36














Did you use $this->getSelect() in your collection class to check the select query is ok or not.
– Pritam Info 24
Dec 7 '18 at 13:50




Did you use $this->getSelect() in your collection class to check the select query is ok or not.
– Pritam Info 24
Dec 7 '18 at 13:50












Yes it's working fine. $this->getSelect()->addFieldToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
– Ketan Panchal
Dec 7 '18 at 13:51






Yes it's working fine. $this->getSelect()->addFieldToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
– Ketan Panchal
Dec 7 '18 at 13:51














Can you try this $this->getSelect(); $this->addAttributeToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
– Pritam Info 24
Dec 7 '18 at 14:08




Can you try this $this->getSelect(); $this->addAttributeToFilter( 'created_at', ['from' => $fromDate, 'to' => $toDate, 'datetime' => true] );
– Pritam Info 24
Dec 7 '18 at 14:08










1 Answer
1






active

oldest

votes


















2














I have resolved an issue for Report Grid.



I have added below function in the Resource model



/**

 * Join fields

 *

 * @param string $fromDate

 * @param string $toDate

 * @return $this

 */

protected function _joinFields($fromDate = '', $toDate = '')

{

    $this->addFieldToFilter(

        'created_at',

        ['from' => $fromDate, 'to' => $toDate, 'datetime' => true]

    );

    //echo $this->getSelect()->__toString();

    return $this;

}



/**

 * Set date range

 *

 * @param string $fromDate

 * @param string $toDate

 * @return $this

 */

public function setDateRange($fromDate, $toDate)

{

    $this->_reset()->_joinFields($fromDate, $toDate);

    return $this;

}



/**

 * Set store filter to collection

 *

 * @param array $storeIds

 * @return $this

 */

public function setStoreIds($storeIds)

{

    if ($storeIds) {

        $this->addFieldToFilter('store_id', ['in' => (array)$storeIds]);

    } 

    return $this;

}


now its working fine :)






share|improve this answer





















    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "479"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f252808%2fmagento-2-custom-report-grid-is-not-working%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    2














    I have resolved an issue for Report Grid.



    I have added below function in the Resource model



    /**
    
 * Join fields
    
 *
    
 * @param string $fromDate
    
 * @param string $toDate
    
 * @return $this
    
 */
    
protected function _joinFields($fromDate = '', $toDate = '')
    
{
    
    $this->addFieldToFilter(
    
        'created_at',
    
        ['from' => $fromDate, 'to' => $toDate, 'datetime' => true]
    
    );
    
    //echo $this->getSelect()->__toString();
    
    return $this;
    
}
    

    
/**
    
 * Set date range
    
 *
    
 * @param string $fromDate
    
 * @param string $toDate
    
 * @return $this
    
 */
    
public function setDateRange($fromDate, $toDate)
    
{
    
    $this->_reset()->_joinFields($fromDate, $toDate);
    
    return $this;
    
}
    

    
/**
    
 * Set store filter to collection
    
 *
    
 * @param array $storeIds
    
 * @return $this
    
 */
    
public function setStoreIds($storeIds)
    
{
    
    if ($storeIds) {
    
        $this->addFieldToFilter('store_id', ['in' => (array)$storeIds]);
    
    } 
    
    return $this;
    
}


    now its working fine :)






    share|improve this answer


























      2














      I have resolved an issue for Report Grid.



      I have added below function in the Resource model



      /**
      
 * Join fields
      
 *
      
 * @param string $fromDate
      
 * @param string $toDate
      
 * @return $this
      
 */
      
protected function _joinFields($fromDate = '', $toDate = '')
      
{
      
    $this->addFieldToFilter(
      
        'created_at',
      
        ['from' => $fromDate, 'to' => $toDate, 'datetime' => true]
      
    );
      
    //echo $this->getSelect()->__toString();
      
    return $this;
      
}
      

      
/**
      
 * Set date range
      
 *
      
 * @param string $fromDate
      
 * @param string $toDate
      
 * @return $this
      
 */
      
public function setDateRange($fromDate, $toDate)
      
{
      
    $this->_reset()->_joinFields($fromDate, $toDate);
      
    return $this;
      
}
      

      
/**
      
 * Set store filter to collection
      
 *
      
 * @param array $storeIds
      
 * @return $this
      
 */
      
public function setStoreIds($storeIds)
      
{
      
    if ($storeIds) {
      
        $this->addFieldToFilter('store_id', ['in' => (array)$storeIds]);
      
    } 
      
    return $this;
      
}


      now its working fine :)






      share|improve this answer
























        2












        2








        2






        I have resolved an issue for Report Grid.



        I have added below function in the Resource model



        /**
        
 * Join fields
        
 *
        
 * @param string $fromDate
        
 * @param string $toDate
        
 * @return $this
        
 */
        
protected function _joinFields($fromDate = '', $toDate = '')
        
{
        
    $this->addFieldToFilter(
        
        'created_at',
        
        ['from' => $fromDate, 'to' => $toDate, 'datetime' => true]
        
    );
        
    //echo $this->getSelect()->__toString();
        
    return $this;
        
}
        

        
/**
        
 * Set date range
        
 *
        
 * @param string $fromDate
        
 * @param string $toDate
        
 * @return $this
        
 */
        
public function setDateRange($fromDate, $toDate)
        
{
        
    $this->_reset()->_joinFields($fromDate, $toDate);
        
    return $this;
        
}
        

        
/**
        
 * Set store filter to collection
        
 *
        
 * @param array $storeIds
        
 * @return $this
        
 */
        
public function setStoreIds($storeIds)
        
{
        
    if ($storeIds) {
        
        $this->addFieldToFilter('store_id', ['in' => (array)$storeIds]);
        
    } 
        
    return $this;
        
}


        now its working fine :)






        share|improve this answer












        I have resolved an issue for Report Grid.



        I have added below function in the Resource model



        /**
        
 * Join fields
        
 *
        
 * @param string $fromDate
        
 * @param string $toDate
        
 * @return $this
        
 */
        
protected function _joinFields($fromDate = '', $toDate = '')
        
{
        
    $this->addFieldToFilter(
        
        'created_at',
        
        ['from' => $fromDate, 'to' => $toDate, 'datetime' => true]
        
    );
        
    //echo $this->getSelect()->__toString();
        
    return $this;
        
}
        

        
/**
        
 * Set date range
        
 *
        
 * @param string $fromDate
        
 * @param string $toDate
        
 * @return $this
        
 */
        
public function setDateRange($fromDate, $toDate)
        
{
        
    $this->_reset()->_joinFields($fromDate, $toDate);
        
    return $this;
        
}
        

        
/**
        
 * Set store filter to collection
        
 *
        
 * @param array $storeIds
        
 * @return $this
        
 */
        
public function setStoreIds($storeIds)
        
{
        
    if ($storeIds) {
        
        $this->addFieldToFilter('store_id', ['in' => (array)$storeIds]);
        
    } 
        
    return $this;
        
}


        now its working fine :)







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Dec 8 '18 at 3:56









        Ketan Panchal

        380111




        380111






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Magento Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f252808%2fmagento-2-custom-report-grid-is-not-working%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            An IMO inspired problem

            Image
            14 4 This problem from IMO 1988 is said to be one of the most elegant ones in functional equations. Problem : The function $f$ is defined on the set of all positive integers as follows: begin{align} f(1) = 1, f(3) &= 3, f(2n) = f(n), \ f(4n+1) &= 2f(2n+1) - f(n), \ f(4n+3) &= 3 f(2n+1) - 2f(n) end{align} Find the number of $n$ with $f(n) = n, 1 leq n leq 1988$. The main idea towards the solution is realizing that these conditions stand for the fact that $f(n)$ just reverses the digits in the binary representation of the number $n$. So, essentially the solution is finding the number of binary pallindromes $leq 1988_{10}$. My question is the following : How to reformulate the problem so that $f(n)$ reverses the digits of $n$ in its ternary representation. Or even better, can we reformulate it for a
            Read more

            Management

            Image
            Management From Wikipedia, the free encyclopedia Jump to navigation Jump to search "Manager" redirects here. For other uses, see Management (disambiguation) and Manager (disambiguation). An organization chart for the United States Coast Guard shows the hierarchy of managerial roles in that organization. Business administration Management of a business Accounting Management accounting Financial accounting Financial audit Business entities Cooperative Corporation Limited liability company Partnership Sole proprietorship State-owned enterprise Corporate governance Annual general meeting Board of directors Supervisory board Advisory board Audit committee Corporate law Commercial law Constitutional documents Contract Corporate crime Corporate liability Insolvency law International trade law Mergers and acquisitions Economics Commodity Pu
            Read more

            Investment

            Image
            Investment From Wikipedia, the free encyclopedia Jump to navigation Jump to search This article is about investment in finance. For investment in macroeconomics, see Investment (macroeconomics). For other uses, see Investment (disambiguation). "Invest" redirects here. For the term in meteorology, see Invest (meteorology). This article needs additional citations for verification . Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. ( February 2017 ) (Learn how and when to remove this template message) In general, to invest is to distribute money in the expectation of some benefit in the future – for example, investment in durable goods, in real estate by the service industry, in factories for manufacturing, in product development, and in research and development. However, this article focuses specifically on investment in financial
            Read more