[Skip to main content](#vessel-content) # Table report I made won't export ## - **[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")** - [![vmrayner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12065-vmrayner "View vmrayner's Profile") Topic Author - [ Offline](/forum/user/12065-vmrayner) Less More - Posts: 38 - Thank you received: 0 - - 13 years 10 months ago [\#81175](#81175) by [vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile") *[Table report I made won't export](/forum/4-how-to/76585-table-report-i-made-wont-export#81175 "The reporting is good but I am having trouble with the a new report I have made. It is a table and itemises a number of products and the total number of units sold for each. error mess Two problems I have. 1. Although there is an edit and delete icon next to each line in the table, they don't seem to work so I can't correct my mistakes 2. The table won't export - I get CANNOT_EXPORT_THIS_FILE information message. Why is this? thanks Viv")* was created by *[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")* The reporting is good but I am having trouble with the a new report I have made. It is a table and itemises a number of products and the total number of units sold for each. error mess Two problems I have. 1. Although there is an edit and delete icon next to each line in the table, they don't seem to work so I can't correct my mistakes 2. The table won't export - I get CANNOT_EXPORT_THIS_FILE information message. Why is this? thanks Viv Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NTg1LXRhYmxlLXJlcG9ydC1pLW1hZGUtd29uLXQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 13 years 10 months ago [\#81712](#81712) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Table report I made won't export](/forum/4-how-to/76585-table-report-i-made-wont-export#81712 "The reporting is good but I am having trouble with the a new report I have made. It is a table and itemises a number of products and the total number of units sold for each. error mess Two problems I have. 1. Although there is an edit and delete icon next to each line in the table, they don't seem to work so I can't correct my mistakes 2. The table won't export - I get CANNOT_EXPORT_THIS_FILE information message. Why is this? thanks Viv")* Hi, 1. They work fine on our end. It's maybe something else on your website which results on that problem. Or maybe you don't have the latest version ? I remember a similar issue in previous versions of HikaShop. In that case you should update. Note that you can always create a new report in order to start afresh. 2. There is nothing to export in a table report. You could simply copy/paste the text of the table if you want to export it... So that why you get an error message. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NTg1LXRhYmxlLXJlcG9ydC1pLW1hZGUtd29uLXQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")** - [![vmrayner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12065-vmrayner "View vmrayner's Profile") Topic Author - [ Offline](/forum/user/12065-vmrayner) Less More - Posts: 38 - Thank you received: 0 - - 13 years 10 months ago [\#82196](#82196) by [vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile") Replied by *[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")* on topic *[Table report I made won't export](/forum/4-how-to/76585-table-report-i-made-wont-export#82196 "The reporting is good but I am having trouble with the a new report I have made. It is a table and itemises a number of products and the total number of units sold for each. error mess Two problems I have. 1. Although there is an edit and delete icon next to each line in the table, they don't seem to work so I can't correct my mistakes 2. The table won't export - I get CANNOT_EXPORT_THIS_FILE information message. Why is this? thanks Viv")* Regarding 1: I checked another browser to see if that was the cause but whenever I click either the bin or edit icon, it brings up a fresh lightbox to create a new row, it does not allow me to delete or edit the existing row. I will start a new table and try not to make any mistakes. Where is this new custom report information stored? Can I edit it in a database somewhere? On second issue: I was hoping that the rows and totals generated in the table could be exported. I used to get something similar in Virtuemart. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NTg1LXRhYmxlLXJlcG9ydC1pLW1hZGUtd29uLXQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 13 years 10 months ago [\#82980](#82980) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Table report I made won't export](/forum/4-how-to/76585-table-report-i-made-wont-export#82980 "The reporting is good but I am having trouble with the a new report I have made. It is a table and itemises a number of products and the total number of units sold for each. error mess Two problems I have. 1. Although there is an edit and delete icon next to each line in the table, they don't seem to work so I can't correct my mistakes 2. The table won't export - I get CANNOT_EXPORT_THIS_FILE information message. Why is this? thanks Viv")* Hi, 1. The reports can be created via the menu Orders->Reports. They are stored in the hikashop_widget table in the database. 2. You can simply create a new report listing the data you want and export that one. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NTg1LXRhYmxlLXJlcG9ydC1pLW1hZGUtd29uLXQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")** - [![vmrayner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12065-vmrayner "View vmrayner's Profile") Topic Author - [ Offline](/forum/user/12065-vmrayner) Less More - Posts: 38 - Thank you received: 0 - - 13 years 10 months ago [\#83050](#83050) by [vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile") Replied by *[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")* on topic *[Table report I made won't export](/forum/4-how-to/76585-table-report-i-made-wont-export#83050 "The reporting is good but I am having trouble with the a new report I have made. It is a table and itemises a number of products and the total number of units sold for each. error mess Two problems I have. 1. Although there is an edit and delete icon next to each line in the table, they don't seem to work so I can't correct my mistakes 2. The table won't export - I get CANNOT_EXPORT_THIS_FILE information message. Why is this? thanks Viv")* The orders reports that are exported only contain the email address of the customer. I would like to add the customers first name and last name and a custom field I created to the report. This is so I can sort the list alphabetically in Excel for when customers collect their orders. I'm not sure how to do this as this data comes from a different table. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NTg1LXRhYmxlLXJlcG9ydC1pLW1hZGUtd29uLXQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 13 years 10 months ago [\#83234](#83234) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Table report I made won't export](/forum/4-how-to/76585-table-report-i-made-wont-export#83234 "The reporting is good but I am having trouble with the a new report I have made. It is a table and itemises a number of products and the total number of units sold for each. error mess Two problems I have. 1. Although there is an edit and delete icon next to each line in the table, they don't seem to work so I can't correct my mistakes 2. The table won't export - I get CANNOT_EXPORT_THIS_FILE information message. Why is this? thanks Viv")* That's indeed quite complex to do as you need to add a left join to the listing query of the widget. That can't be done in an override easily so you'll have to modify the code around line 900 of the file administrator/components/com_hikashop/classes/widget.php Maybe with something like that: $leftjoin[] = ' LEFT JOIN '.hikashop_table('address').' AS b ON a.'.$address.'=b.address_id'; $select.='b.*,'; before the line: $select.='a.*'; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzc2NTg1LXRhYmxlLXJlcG9ydC1pLW1hZGUtd29uLXQtZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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.246 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)