[Skip to main content](#vessel-content) # Custom Reports from Custom Fields ## - **[BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile")** - [![BounceHouseOwner's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32544.jpg)](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile") Topic Author - [ Offline](/forum/user/32544-bouncehouseowner) Less More - Posts: 90 - Thank you received: 2 - - 10 years 3 months ago [\#247160](#247160) by [BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile") *[Custom Reports from Custom Fields](/forum/36-reports-statistics/885913-custom-reports-from-custom-fields#247160 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.3.1 Because we rent out items, we cannot run reports by "order date". I created a custom field with a calendar for the customer to advise the event date. 1. I need to create a report that shows me, based on the event date, what is being rented. How do I do this? 2. I also need to run a report that shows me, based on the date I choose, a list of what is being rented, how many, and how many I have left. If I can have the customer's name that would be good too.")* was created by *[BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile")* -- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.3.1 Because we rent out items, we cannot run reports by "order date". I created a custom field with a calendar for the customer to advise the event date. 1. I need to create a report that shows me, based on the event date, what is being rented. How do I do this? 2. I also need to run a report that shows me, based on the date I choose, a list of what is being rented, how many, and how many I have left. If I can have the customer's name that would be good too. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODU5MTMtY3VzdG9tLXJlcG9ydHMtZnJvbS1jdXN0b20tZmllbGRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86360 - Thank you received: 14296 - - 10 years 3 months ago [\#247164](#247164) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom Reports from Custom Fields](/forum/36-reports-statistics/885913-custom-reports-from-custom-fields#247164 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.3.1 Because we rent out items, we cannot run reports by "order date". I created a custom field with a calendar for the customer to advise the event date. 1. I need to create a report that shows me, based on the event date, what is being rented. How do I do this? 2. I also need to run a report that shows me, based on the date I choose, a list of what is being rented, how many, and how many I have left. If I can have the customer's name that would be good too.")* Hi, Go in the menu System>Mass actions and create a new mass action on the "order" data. You can add a filter on the custom field product column name with the value of the date you want (check in the database table hikashop_order_product table for the format of the dates in your custom field column so that you can have filters the way you want), and then add an action "display the results" or "CSV export" to either display the listing of the products or export the products data with the selected columns you want when you click on the "process" button there. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODU5MTMtY3VzdG9tLXJlcG9ydHMtZnJvbS1jdXN0b20tZmllbGRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile")** - [![BounceHouseOwner's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32544.jpg)](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile") Topic Author - [ Offline](/forum/user/32544-bouncehouseowner) Less More - Posts: 90 - Thank you received: 2 - - 10 years 3 months ago [\#247196](#247196) by [BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile") Replied by *[BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile")* on topic *[Custom Reports from Custom Fields](/forum/36-reports-statistics/885913-custom-reports-from-custom-fields#247196 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.3.1 Because we rent out items, we cannot run reports by "order date". I created a custom field with a calendar for the customer to advise the event date. 1. I need to create a report that shows me, based on the event date, what is being rented. How do I do this? 2. I also need to run a report that shows me, based on the date I choose, a list of what is being rented, how many, and how many I have left. If I can have the customer's name that would be good too.")* I will be utilizing the results display as I will be referencing this when I have a customer on the phone and they want to make a reservation. I am still not getting what I want. Getting closer though. I have attached a file, Capture that shows what I am looking for and a Mass Action file that shows what my current set up has. When I receive a call, I need to be able to look at the date the customer is looking to reserve the equipment. I want to be able to see how many of an item is rented and how many I have available. I want to see if a particular item is negative as this would be my way of knowing I will be looking at my fellow businesses to sub rent from them. I hope this adds additional clarification as to what I am looking to do or if maybe I have settings that could be better set up. - [ ![Capture_2016-08-08.png](/forum/attachment/32949) ](/forum/attachment/32949 "...2016-08-08.png") [ ](/forum/attachment/32949?download=1 "...2016-08-08.png") - [ ![Mass_Action.png](/forum/attachment/32950) ](/forum/attachment/32950 "Mass_Action.png") [ ](/forum/attachment/32950?download=1 "Mass_Action.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODU5MTMtY3VzdG9tLXJlcG9ydHMtZnJvbS1jdXN0b20tZmllbGRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86360 - Thank you received: 14296 - - 10 years 3 months ago [\#247211](#247211) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom Reports from Custom Fields](/forum/36-reports-statistics/885913-custom-reports-from-custom-fields#247211 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.3.1 Because we rent out items, we cannot run reports by "order date". I created a custom field with a calendar for the customer to advise the event date. 1. I need to create a report that shows me, based on the event date, what is being rented. How do I do this? 2. I also need to run a report that shows me, based on the date I choose, a list of what is being rented, how many, and how many I have left. If I can have the customer's name that would be good too.")* Hi, So how did you configure your custom field ? Could you do a screenshot of that ? And could you also do a screenshot of the mass action settings you have for the result you provided so that we can get a better grasp of what's missing ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODU5MTMtY3VzdG9tLXJlcG9ydHMtZnJvbS1jdXN0b20tZmllbGRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile")** - [![BounceHouseOwner's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar32544.jpg)](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile") Topic Author - [ Offline](/forum/user/32544-bouncehouseowner) Less More - Posts: 90 - Thank you received: 2 - - 10 years 3 months ago [\#247304](#247304) by [BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile") Replied by *[BounceHouseOwner](/forum/user/32544-bouncehouseowner "View BounceHouseOwner's Profile")* on topic *[Custom Reports from Custom Fields](/forum/36-reports-statistics/885913-custom-reports-from-custom-fields#247304 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.3.1 Because we rent out items, we cannot run reports by "order date". I created a custom field with a calendar for the customer to advise the event date. 1. I need to create a report that shows me, based on the event date, what is being rented. How do I do this? 2. I also need to run a report that shows me, based on the date I choose, a list of what is being rented, how many, and how many I have left. If I can have the customer's name that would be good too.")* I have all of the custom fields under "order". Is there a particular field you are interested in looking at? I don't know which screen shot to send you. Attached is the Mass Action settings. I hope pdf is okay. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODU5MTMtY3VzdG9tLXJlcG9ydHMtZnJvbS1jdXN0b20tZmllbGRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86360 - Thank you received: 14296 - - 10 years 3 months ago [\#247311](#247311) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom Reports from Custom Fields](/forum/36-reports-statistics/885913-custom-reports-from-custom-fields#247311 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.3.1 Because we rent out items, we cannot run reports by "order date". I created a custom field with a calendar for the customer to advise the event date. 1. I need to create a report that shows me, based on the event date, what is being rented. How do I do this? 2. I also need to run a report that shows me, based on the date I choose, a list of what is being rented, how many, and how many I have left. If I can have the customer's name that would be good too.")* Hi, Reading your other thread [ www.hikashop.com/forum/product-category-...r-date-of-event.html](https://www.hikashop.com/forum/product-category-display/885942-reduction-of-inventory-for-date-of-event.html) I now understand what you want and why you want it. But I don't see how you'll be able to have what you want with what is already available. What you can do with mass actions is to create several mass actions, one for each date of event, with something like that: [ take.ms/OFPrF](http://take.ms/OFPrF) And that will give you a listing of the products bought for a specific day with the quantities purchased, and you would have to manually sum the quantities to know the amount ordered for each product. So it's not really practical for what you want to do with it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODU5MTMtY3VzdG9tLXJlcG9ydHMtZnJvbS1jdXN0b20tZmllbGRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.088 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)