# Proper Reports in Dolibarr **URL:** \ **Category:** Using my Dolibarr\ **Created:** [July 10, 2017, 4:29pm UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831 "2017-07-10T16:29:34Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ariffidaali](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ariffidaali/32/462_2.png) [@ariffidaali](https://www.dolibarr.org/forum/u/ariffidaali)\ **Post date:** [July 10, 2017, 4:29pm UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831/1 "2017-07-10T16:29:34Z")
When I say reports I imagine something like the linked images show, a separate menu item for reports and also easy customizable reports. Reports should be easily exportable to pdf, csv, Excel, Word right from the report and not go through tools-\> export like in Dolibarr or through various addons which do not fully work ( i have tried). See the attached file inventory details it’s nicely formatted with options to save as pdf, excel etc. Something like this would be very beneficial. [http://imgur.com/a/foI8o](http://imgur.com/a/foI8o) > Pièces jointes : > > - [ReportsScreenShot1.png](https://www.dolibarr.org/forum/uploads/short-url/v7OyhxGPL7kpIK14mBrjaTGeXnT.png) (43.5 KB) > - [ReportsScreenShot.png](https://www.dolibarr.org/forum/uploads/short-url/mhtEv4E8XXMM0Vrx0lQsb3OLxbz.png) (82.6 KB) > - [InventoryDetailsReport-examplereport.png](https://www.dolibarr.org/forum/uploads/short-url/qnTnJX2dEEOibH8Pm2RGwonK0GZ.png) (29.8 KB) ---
**Author:** ![kslom](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/k/51bf81/32.png) [@kslom](https://www.dolibarr.org/forum/u/kslom)\ **Post date:** [July 26, 2017, 7:01am UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831/2 "2017-07-26T07:01:01Z")
A full reporting app would be nice. Ability to customize filters, columns, etc. The Statistics feature on each menu is a start, but full reporting would be ideal. I did look at Dolireport, but it seems limited in what you can search for, and creating a query does not look very end-user friendly unless you are a developer (which, unfortunately, I am not). ---
**Author:** ![ariffidaali](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ariffidaali/32/462_2.png) [@ariffidaali](https://www.dolibarr.org/forum/u/ariffidaali)\ **Post date:** [July 26, 2017, 6:57pm UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831/3 "2017-07-26T18:57:24Z")
Hi kslom, I feel what you are saying the modules like Dolireport require developer knowledge like SQL and Dolibarr database structure. I have purchased a module called myList from Dolistore which works and has filters for each field but requires SQL and database knowledge. The only other downside of myList is the pdf export has formatting issues when you have multiple pages. I have been talking to the developers patas-monkey but they have not been able to solve the issue. I have SQL knowledge and I have thoroughly studied the Dolibarr MySQL database. Dolireport is also a bit expensive at 150 Euros. I was wondering whether we can make a deal: you buy the Dolireport module then share it with me as in send me the files in return I will develop reports that you want. I already have a number of SQL queries already that can retrieve data from the database. What do you say a deal? :happy: ---
**Author:** ![kslom](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/k/51bf81/32.png) [@kslom](https://www.dolibarr.org/forum/u/kslom)\ **Post date:** [July 27, 2017, 7:22am UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831/4 "2017-07-27T07:22:02Z")
ariffidaali, that is an interesting proposition but at this time I will have to pass. I am still just evaluating Dolibarr to see if it will even work for my company, so investing in modules is not in my immediate plans. And after looking at Dolireport, I’m not sure it would do all I wanted, anyway. ---
**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\ **Post date:** [July 27, 2017, 8:13pm UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831/5 "2017-07-27T20:13:28Z")
> [@ariffidaali](#): > > Hi kslom, > I feel what you are saying the modules like Dolireport require developer knowledge like SQL and Dolibarr database structure. I have purchased a module called myList from Dolistore which works and has filters for each field but requires SQL and database knowledge. The only other downside of myList is the pdf export has formatting issues when you have multiple pages. I have been talking to the developers patas-monkey but they have not been able to solve the issue. I have SQL knowledge and I have thoroughly studied the Dolibarr MySQL database. Dolireport is also a bit expensive at 150 Euros. > I was wondering whether we can make a deal: you buy the Dolireport module then share it with me as in send me the files in return I will develop reports that you want. I already have a number of SQL queries already that can retrieve data from the database. What do you say a deal? :happy: I use MySQL Workbench to pull up data from Dolibarr, what kind of queries do you have to share? ---
**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\ **Post date:** [July 28, 2017, 12:10am UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831/6 "2017-07-28T00:10:11Z")
I’m trying to find a way of: Pulling up all products without categories Products which are in stock over 3 months old Cant think of any other but the above two would prove useful ---
**Author:** ![ariffidaali](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ariffidaali/32/462_2.png) [@ariffidaali](https://www.dolibarr.org/forum/u/ariffidaali)\ **Post date:** [July 28, 2017, 12:42pm UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831/7 "2017-07-28T12:42:21Z")
Hi Aljawaid, Since this is community where people contribute I will help you with your SQL queries. Hoping to make this beneficial for both of us, we mutually share stuff with each other. See below SQL queries. Hope it’s useful :happy: LIST OF PRODUCTS WITHout TAGS AND CATEGORIES * * * # SELECT DISTINCT u.rowid AS Category\_ID, u.label AS Category\_Label, u.description AS Category\_description, p.rowid AS Product\_ID, p.ref AS Product\_Code, p.label as Product\_Label FROM llx\_categorie AS u JOIN llx\_categorie\_product AS cp ON cp.fk\_categorie = u.rowid RIGHT JOIN llx\_product AS p ON p.rowid = cp.fk\_product WHERE u.label is null GROUP BY p.rowid ORDER BY p.ref ITEMS THAT HAVE BEEN IN STOCK FOR THE LAST 3 MONTHS -------------------------------------------- SELECT DISTINCT `rowid`, `ref`, `label`, MONTHNAME(datec) as Month\_Created, Monthname(tms) As Month\_Modified, MONTHNAME(CONVERT(import\_key, DATETIME)) as Month\_Imported FROM `llx_product` WHERE tms \>= (NOW()-INTERVAL 3 MONTH) ORDER BY tms desc ---
**Author:** ![HubZ](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/h/e79b87/32.png) [@HubZ](https://www.dolibarr.org/forum/u/HubZ)\ **Post date:** [July 28, 2017, 4:09pm UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831/8 "2017-07-28T16:09:37Z")
:happy: Do you know there is a module made by ATM called QUERY where you can save these values :wink: Thanks for these useful reports, but : on which version does it work ? (5.0.4 ?) ---
**Author:** ![ariffidaali](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ariffidaali/32/462_2.png) [@ariffidaali](https://www.dolibarr.org/forum/u/ariffidaali)\ **Post date:** [July 29, 2017, 9:47am UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831/9 "2017-07-29T09:47:53Z")
Hubz, I have seen that module called Query by ATM on the Dolistore but as I have stated earlier in the post reports should be built in and also the cost 216 Euros is on the higher side. There are also other modules such as Dolireport which is similar to Query. This just means that now Dolibarr doesn’t become free of cost there are costs attached to it. Another problem is that the average user cannot use these modules because it requires SQL and database knowledge. :confused: Yes these queries can work with almost any Dolibarr version as they pull data from standard Dolibarr tables. :happy: ---
**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\ **Post date:** [July 29, 2017, 11:12am UTC](https://www.dolibarr.org/forum/t/proper-reports-in-dolibarr/15831/10 "2017-07-29T11:12:20Z")
Products with Country of Origin (Manufacturing Country) (highest first, ignoring blanks) ```auto SELECT llx_product.fk_country AS 'Country Code', llx_c_country.label AS 'Country', COUNT(*) AS 'Number of Products' FROM llx_product INNER JOIN llx_c_country ON llx_product.fk_country = llx_c_country.rowid GROUP BY fk_country ORDER BY COUNT(*) DESC; ```