# Custom Reports **URL:** \ **Category:** Uncategorized\ **Created:** [August 11, 2015, 4:56pm UTC](https://forum.manager.io/t/custom-reports/3530 "2015-08-11T16:56:05Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![esenicki](https://avatars.discourse-cdn.com/v4/letter/e/5f9b8f/32.png) [@esenicki](https://forum.manager.io/u/esenicki)\ **Post date:** [August 11, 2015, 4:56pm UTC](https://forum.manager.io/t/custom-reports/3530/1 "2015-08-11T16:56:05Z")
Lubos…will there be some guidance/tutorial on using this feature? ---
**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\ **Post date:** [August 12, 2015, 1:11pm UTC](https://forum.manager.io/t/custom-reports/3530/2 "2015-08-12T13:11:16Z")
I guess this is also another feature that requires the user to be a computer programming Savvy. Just like the HTML thing. Lol ---
**Author:** ![esenicki](https://avatars.discourse-cdn.com/v4/letter/e/5f9b8f/32.png) [@esenicki](https://forum.manager.io/u/esenicki)\ **Post date:** [August 12, 2015, 1:42pm UTC](https://forum.manager.io/t/custom-reports/3530/3 "2015-08-12T13:42:12Z")
The description of this update says “SQL-like language” which needs to be defined. ---
**Author:** ![esenicki](https://avatars.discourse-cdn.com/v4/letter/e/5f9b8f/32.png) [@esenicki](https://forum.manager.io/u/esenicki)\ **Post date:** [August 12, 2015, 5:49pm UTC](https://forum.manager.io/t/custom-reports/3530/4 "2015-08-12T17:49:29Z")
Sorry, there is an operator in SQL called “SQL LIKE”. My apologies. An example or two might be helpful to me as a starting point. Thanks. ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [August 13, 2015, 3:59am UTC](https://forum.manager.io/t/custom-reports/3530/5 "2015-08-13T03:59:09Z")
There will be soon documentation which will describe data structure for SQL queries. The feature is being used by limited amount of users for now, I’m still trying to figure out a few details. Oh, and why SQL? It’s the most common query language for relational data. Everybody will be able to create simple queries. For more complicated ones, you would need some help if you are not comfortable with SQL. The idea behind custom reports is to close the gap when people complain Manager doesn’t have a report they need. With SQL queries, you will be able to create any report you like. ---
**Author:** ![alim](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@alim](https://forum.manager.io/u/alim)\ **Post date:** [August 13, 2015, 5:19am UTC](https://forum.manager.io/t/custom-reports/3530/6 "2015-08-13T05:19:23Z")
Is this the feature that will be used for making country specific tax return reports? > [@Similar report as VAT Return (UK) for Maldives](http://forum.manager.io/t/similar-report-as-vat-return-uk-for-maldives/3372/2): > > I do want to implement country-specific reports (that’s the reason why I did in-built tax codes in the first place) but it does take considerable time to implement each such a report and keep up with changes. I will be adding ability to create custom tax reports so you will be able to implement it yourself. And if you like you will be then able to share it with me so I can add it to the program for everyone. ---
**Author:** ![copiousfreetime](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/copiousfreetime/32/380_2.png) [@copiousfreetime](https://forum.manager.io/u/copiousfreetime)\ **Post date:** [August 13, 2015, 3:13pm UTC](https://forum.manager.io/t/custom-reports/3530/7 "2015-08-13T15:13:55Z")
@lubos Thanks for this, and if you want another beta tester for the existing documentation, let me know. I’m plenty familiar with SQL :-). ---
**Author:** ![martro](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@martro](https://forum.manager.io/u/martro)\ **Post date:** [August 19, 2015, 1:37am UTC](https://forum.manager.io/t/custom-reports/3530/8 "2015-08-19T01:37:07Z")
Hi @lubos I can help to test custom reports, as I have many to create. Could you please share the database structure? ---
**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\ **Post date:** [August 19, 2015, 5:19pm UTC](https://forum.manager.io/t/custom-reports/3530/9 "2015-08-19T17:19:15Z")
Any update guys? ---
**Author:** ![ahmadsetioaji](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ahmadsetioaji/32/663_2.png) [@ahmadsetioaji](https://forum.manager.io/u/ahmadsetioaji)\ **Post date:** [August 20, 2015, 9:31am UTC](https://forum.manager.io/t/custom-reports/3530/10 "2015-08-20T09:31:11Z")
> [@lubos](#): > > There will be soon documentation which will describe data structure for SQL queries. The feature is being used by limited amount of users for now, I’m still trying to figure out a few details. > > Oh, and why SQL? It’s the most common query language for relational data. > > Everybody will be able to create simple queries. For more complicated ones, you would need some help if you are not comfortable with SQL. > > The idea behind custom reports is to close the gap when people complain Manager doesn’t have a report they need. With SQL queries, you will be able to create any report you like. ill be waiting fo it. thanks @lubos ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [August 20, 2015, 10:22am UTC](https://forum.manager.io/t/custom-reports/3530/11 "2015-08-20T10:22:04Z")
Documentation for data structures and examples of SQL queries will be available next week. ---
**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\ **Post date:** [August 20, 2015, 10:42am UTC](https://forum.manager.io/t/custom-reports/3530/12 "2015-08-20T10:42:49Z")
yayyyyyyy!!! ---
**Author:** ![ahmadsetioaji](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ahmadsetioaji/32/663_2.png) [@ahmadsetioaji](https://forum.manager.io/u/ahmadsetioaji)\ **Post date:** [September 7, 2015, 11:33am UTC](https://forum.manager.io/t/custom-reports/3530/13 "2015-09-07T11:33:17Z")
Where the guide, i have been wait for it. took so long… 😄 ---
**Author:** ![compuit](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/compuit/32/66_2.png) [@compuit](https://forum.manager.io/u/compuit)\ **Post date:** [September 9, 2015, 10:16pm UTC](https://forum.manager.io/t/custom-reports/3530/14 "2015-09-09T22:16:00Z")
This may be the answer to my query regarding the “ **Statement of Financial Performance** ”? Is there some documentation somewhere? ---
**Author:** ![martro](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@martro](https://forum.manager.io/u/martro)\ **Post date:** [September 19, 2015, 5:33am UTC](https://forum.manager.io/t/custom-reports/3530/15 "2015-09-19T05:33:05Z")
Hi Lubos, Have you already published this documentation (data structures and examples of SQL queries)? If yes, where is it available? ---
**Author:** ![Uatec](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/uatec/32/1459_2.png) [@Uatec](https://forum.manager.io/u/Uatec)\ **Post date:** [September 19, 2015, 8:38pm UTC](https://forum.manager.io/t/custom-reports/3530/16 "2015-09-19T20:38:04Z")
Is this available now. ---
**Author:** ![martro](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@martro](https://forum.manager.io/u/martro)\ **Post date:** [September 24, 2015, 11:24pm UTC](https://forum.manager.io/t/custom-reports/3530/17 "2015-09-24T23:24:14Z")
I began to play with Custom Reports, trying to discover some of the database structure and I could go through very basic queries like: SELECT \* FROM Customers SELECT \* FROM Employees SELECT \* FROM Suppliers If this will give us access to all the data in Manager that will be great! I have some suggestions: 1. Currently, you have to paste your SELECT query each time in the text field (there is no way to store the query under a report name for later use) 2. Please add the Print and Export to .TSV buttons, currently you can only see the results on screen. 3. Please make each custom report capable of having multiple query sections (to implement for example header data, body data, footer data) 4. if possible, allow queries to have JOINs, ORDER BY, etc. Thanks for your great work Lubos! And please share the database structure ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [September 24, 2015, 11:36pm UTC](https://forum.manager.io/t/custom-reports/3530/18 "2015-09-24T23:36:45Z")
@martro, `Export` button was actually just added a few minutes ago. `ORDER BY` should be already working too. As for JOINs, I’m going to do a little spin on this one. Manager will automatically do joins for you. For example, if you want to know list of customers who have bought particular inventory item within last 6 months, you will be able to do something like this: ```sql SELECT SalesInvoice.Customer.Name FROM SalesInvoiceLines WHERE SalesInvoice.Date > DateTime.Today.AddMonths(-6) AND InventoryItem.Code = "ABC0001" ``` Basically when selecting from `SalesInvoiceLines` table, you will be able to go deep into fields such as `SalesInvoice.Customer.Name` without using any JOIN expression. This is because unlike generic SQL, Manager knows relationships between your data so there is no need to tell Manager what it already knows. ---
**Author:** ![alasdair](https://avatars.discourse-cdn.com/v4/letter/a/fbc32d/32.png) [@alasdair](https://forum.manager.io/u/alasdair)\ **Post date:** [September 25, 2015, 11:34pm UTC](https://forum.manager.io/t/custom-reports/3530/19 "2015-09-25T23:34:06Z")
Good stuff. Anything by way of a schema available or even just list of tables? Thanks. ---
**Author:** ![J\_Squared](https://avatars.discourse-cdn.com/v4/letter/j/e9bcb4/32.png) [@J\_Squared](https://forum.manager.io/u/J_Squared)\ **Post date:** [September 27, 2015, 1:54am UTC](https://forum.manager.io/t/custom-reports/3530/20 "2015-09-27T01:54:06Z")
Hi there, can someone provide the link of this documentation? I can’t find it. Many thanks [Next page](https://forum.manager.io/t/custom-reports/3530.md?page=2)