custom-reports
custom-reports copied to clipboard
kalenjordan
Custom Magento reports using SQL
I want to add date filter(to_date and from_date) in all reports. I have tried this using grid configuration section. but this solution not working. anybody has solution on this? Thank...
When running a GeoChart report, I'm now receiving the following error.
I have created a custom SQL special report trough Reports -> Special Reports -> Add Report. After creating "Orders overview" and i go to Reports -> Special Reports -> Orders...
I added a field to filter to my report, and used the `select` type of filter. I am not seeing values in the `select` field, so I am guessing there...
https://github.com/kalenjordan/custom-reports/blob/4192e89744175c1d5ede85ec7de5b6478187784d/app/code/community/Clean/SqlReports/Block/Adminhtml/Customreport/View/Grid.php#L78 Thanks for the fantastic extension, I'm having to extend it slightly in order to access attributes in a serialised field (sales_flat_order_items.product_options) and was having difficulties with pagination so had...
I have a custom DATE field called 'target_ship_date' In the order grid, I use the adminhtml/widget_grid_column_filter_date and if I use the range 10/3/2017 to 10/4/2017 it returns all records that...
Google Charts has a locale parameter when loading the library. Is there a way of setting this parameter through the Custom Reports, module? Currently I've added this parameter manually updating...
Is it possible to set a specific date range filter? For example, the SQL query is: `select count(mg_sales_flat_shipment.order_id) as 'NumeroOrdiniSpediti', sum(mg_sales_flat_order.base_grand_total) as 'TotaleSpedito', concat(DAY(mg_sales_flat_shipment.created_at), '-',MONTH(mg_sales_flat_shipment.created_at)) as 'Data' FROM mg_sales_flat_shipment left...
Hello, I have just found a small bug when using column name with spaces. Since I am not an expert on PHP, I would suggest any of you a little...
Allow export to Excel file, using the Magento core export mechanism. This patch is overwritten by #80. In case #80 is accepted, this patch can be dismissed.
