Questions tagged [custom-reports]

Questions related to reports that is developed using any custom module

Filter by
Sorted by
Tagged with
1
vote
1answer
143 views

How to create custom report for category data in Magento 2?

I am trying to create a report for categories. Vendor/Module/registration.php <?php \Magento\Framework\Component\ComponentRegistrar::register( \Magento\Framework\Component\ComponentRegistrar::...
1
vote
1answer
57 views

Magento 2 Remove Total from report table

I have overridden the Sales report in my custom report file but I want to remove footer which is automatically added that I don't need how to remove that footer My layout xml file is <?xml ...
0
votes
0answers
18 views

Magento 2 - how to print MySQL query for Mirasvit Report module?

To print out the all SQL query for the reports which were generated by the Mirasvit Reports? Currently using the DB logger which generates lots of data while debugging. <preference for="Magento\...
0
votes
2answers
48 views

Magento 2 require to create SQL query for the custom report

I would like to generate Magento native report as follows: Can anybody provide the SQL query for above table ? Column Name CustomerGender = customer attribute Column Name Group = Customer Group ...
2
votes
2answers
629 views

Data showing in Grid but not in export file Magento2

I have created a custom report, Used below code in my ui_component listing file. <column name="custom_tax_code" class="Vendor\Module\Ui\Component\Listing\Column\Quantity"> <argument name="...
1
vote
1answer
48 views

Show shipping amount for entire order in custom report Magento2

I have created the custom sales report, used below code in my listing.xml file, <column name="shipping_amount"> <argument name="data" xsi:type="array"> <item name="...
2
votes
1answer
259 views

Magento 2: Display Payment Method in Custom Sales report grid

I have created the custom sales report to show required fields on the grid, Used below code to show payment method, Vendor/Module/view/adminhtml/ui_component/salesfinacereport_manage_listing.xml &...
1
vote
0answers
32 views

magento 2 Customer Report unable to set Interval(Period like 2019), Customer Group, Numbers of Orders, Average Order Amount, Total Order Amount

I am trying to create custom report and want to display admin grid with columns as below: Interval(Period),Customer Group,Numbers of Orders,Average Order Amount,Total Order Amount I have run the ...
1
vote
0answers
42 views

Magento 2 help validate function to count bundle product child items of an order

I'm trying to write a function that takes an order object, and returns an array of sku => qty (key-value) showing how many of each sku was sold/shipped. The tricky part is, magento formats line items ...
0
votes
0answers
34 views

Get the list of most seller combined products with its orders

I want to get the most frequently sold product combinations, along with number of orders ( and Orders if possible). I have customized the Magento tables for my warehouse activities and the sample ...
1
vote
0answers
34 views

Display record count in custom report on the basis of row count. Magento 1.9 custom report

In my Custom Report. I have created a collection which count is 25. But After this I have applied some joins on that by another collection. but on which I have made join is returning 25 records. ...
1
vote
2answers
1k views

Create Custom report in admin using Magento 2.1.9

I want to create a custom report using the custom table section in the admin under the reports menu. COuld you please help me out.
1
vote
1answer
44 views

Custom report without using collection

I have a request which to make custom report, and data for the report need to calculate by helper function and will generate a data array with row and columns. Is there any solution to let data array ...
2
votes
2answers
382 views

Custom report from SQL query

I want to get order total of the month January 2019 for complete orders I need to know tables related to this query, or if someone can share query that would be great.
3
votes
1answer
231 views

How to add sales order table custom value to magento 2 report from a custom module

I created a custom module to check the ad code (measure the marketing traffic) value from the url and add to the order. I added a column to the sales order table and save the ad value when user place ...
1
vote
0answers
34 views

How to customize 'Order Total Report' (REPORTS > Customers > Order Total) in magento 2.2.6

I need to achieve this: In 'Order Total Report' (REPORTS > Customers > Order Total) add new columns, 'ID', 'Affiliate ID', 'Total BVP Purchase'. 'ID' ==> will display Customer ID 'Affiliate ID' ...
1
vote
0answers
570 views

How to create custom reports in custom menu in admin magento 2? [closed]

Actually i want create custom report based on sales ,product and custom data from custom module in admin side with graph
8
votes
2answers
11k views

Magento 2 - I need to create simple custom report with date range and other column filter (filter should be outside of grid)

I need to create custom report which is just like magento default reports. I go through the Internet I found this https://github.com/degdigital/magento2-customreports but In this report data is ...
0
votes
1answer
23 views

Is it possible to track the quantity of clicks I have on my store?

I need to develop a report module on my store and I need to track the quantity of clicks the site have. is it possible : to get the quantity of clicks And/or the quantity of clicks on a given time
1
vote
1answer
2k views

How to create custom reports in Magento2?

Now the real question I need to create custom reports based on conditions. Sales Report Marketing Report Customer Report Product Report . Example: Conditions: How many products or list of ...