[Skip to main content](#vessel-content) # Need to create a custom SQL report ## - **[reeses007](/forum/user/8958-reeses007 "View reeses007's Profile")** - [![reeses007's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8958-reeses007 "View reeses007's Profile") Topic Author - [ Offline](/forum/user/8958-reeses007) Less More - Posts: 25 - Thank you received: 1 - - 12 years 7 months ago [\#150975](#150975) by [reeses007](/forum/user/8958-reeses007 "View reeses007's Profile") *[Need to create a custom SQL report](/forum/31-development/867198-need-to-create-a-custom-sql-report#150975 "Hi, I have to create a SQL reports for my customer and it involves tables outside of Hikashop. Could you point me to a place where could get a head start and see the select statements for most of your reports? For instance, list all the customers with their purchase totals for a period of time. That way I could just merge the tables outside of hikashop in the select statements. Thanks!")* was created by *[reeses007](/forum/user/8958-reeses007 "View reeses007's Profile")* Hi, I have to create a SQL reports for my customer and it involves tables outside of Hikashop. Could you point me to a place where could get a head start and see the select statements for most of your reports? For instance, list all the customers with their purchase totals for a period of time. That way I could just merge the tables outside of hikashop in the select statements. Thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg2NzE5OC1uZWVkLXRvLWNyZWF0ZS1hLWN1c3RvbS1zcWwtcmVwb3J0P3RtcGw9bWFya2Rvd24=) 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: 86359 - Thank you received: 14295 - - 12 years 7 months ago [\#150995](#150995) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Need to create a custom SQL report](/forum/31-development/867198-need-to-create-a-custom-sql-report#150995 "Hi, I have to create a SQL reports for my customer and it involves tables outside of Hikashop. Could you point me to a place where could get a head start and see the select statements for most of your reports? For instance, list all the customers with their purchase totals for a period of time. That way I could just merge the tables outside of hikashop in the select statements. Thanks!")* Hi, The simplest is to turn on the "debug system" option of the joomla configuration and display the report for which you want the SQL query. Then, look at the debug data at the bottom of the page and you'll get the SQL queries run on the page. The one from your report should probably be the most complex one of the whole page. The following user(s) said Thank You: [reeses007](/forum/user/8958-reeses007 "View reeses007's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg2NzE5OC1uZWVkLXRvLWNyZWF0ZS1hLWN1c3RvbS1zcWwtcmVwb3J0P3RtcGw9bWFya2Rvd24=) 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.047 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)