A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [custom-reports]

Questions related to reports that is developed using any custom module

Filter by
Sorted by
Tagged with
0
votes
0answers
14 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
30 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 ...
1
vote
2answers
237 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
39 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
183 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
28 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 ...
0
votes
0answers
27 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
24 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
31 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
759 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
39 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
338 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
183 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
33 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
483 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
10k 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
21 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
1k 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 ...