Lubos…will there be some guidance/tutorial on using this feature?

Dear Sir, How to we get a customer wise inventory sold report. I mean what query can we put in custom reports to get this report ? Best Regards, Taher Nomani

Any change on the status of custom reports ? I would like a report of Production oders and the associated cost. Any way I can get the database schema.

[image] BaldeSeca: Any change on the status of custom reports ? Sorry, I haven’t noticed any update on this (have done a few searches myself). [image] BaldeSeca: Any way I can get the database schema. There are some posts further up in this topic that explain parts of the schema (cert…

Thank You. I don’t understand the mystery as the custom Reports is available, why not give the information. Users could create reports and share this will greatly enhance the program. By the way I think it is among the best of the best.

[image] lubos: SELECT SalesInvoice.Customer.Name FROM SalesInvoiceLines WHERE SalesInvoice.Date > DateTime.Today.AddMonths(-6) AND InventoryItem.Code = “ABC0001” DEAR SIR, Kindly do share structure of database to utilized custom report facility.

there is no documentation for custom reports. it is still a work in progress.

dear sir, i am not able to call SELECT SalesInvoice.Customer.Name FROM SalesInvoiceLines WHERE SalesInvoice.Date > DateTime.Today.AddMonths(-6) AND InventoryItem.Code = “ABC0001” and simple way. SELECT * FROM SalesInvoiceLines pulling error of said query. kindy advice me for it.

As @sharpdrivetek already told you, there is no support for custom reports.

SELECT * FROM customers or suppliers Keeps running! not able to get my report. Any help?

[image] arvindbalan05: Any help? No. As written above (and in many other posts on the forum) there is no support for custom reports and no documentation.

Custom Reports

Davide May 17, 2018, 5:35am 77

Please look at Data connection ODBC using VB.net OR Ms acess or excel - #12 by lubos

Topic		Replies	Views
[18.9.60] Improved custom reports (added visual query builder)	90	6032	November 11, 2018
SQL schema for creating custom reports	61	11765	March 5, 2018
Custom Reports (a work in progress)	13	1581	September 7, 2018
Custom reporting tools for simple and complex reporting	13	2018	March 1, 2018
SQL Table Connection w/ LibreOffice Base For Custom Reports	16	2311	March 19, 2018

Custom Reports

Related topics