[image] [image] pls as per the above report form, what is a format code to use to write custom report, example SALES PER MONTH. Thank you.

There is no documentation for custom reports. This feature is a work in progress.

The language is SQL , but you’ll have to guess at what the table names are as Tut mentioned there is no documentation yet. I discovered a few by experimenting: SELECT * FROM Customers SELECT * FROM Suppliers SELECT * FROM PurchaseInvoices SELECT * FROM SalesInvoices We’ll have to wait for offic…

Will this work? SELECT * FROM INFORMATION_SCHEMA.TABLES or SELECT * FROM Sys.Tables

I’m going to assume you never thought to try it yourself? :slight_smile: Have just entered into mine - they do not work. I’m pretty sure the custom reports go through a wrapper before they reach the database, so only tables that have been whitelisted would work. If you look at the list of objects …

Great work @Patrick_Mensah . Thankx for your Screenshots.

You are correct, I haven’t tried it… yet. I’m not at the office and I was reading this thread. I remembered the SQL commands from days long gone.

How to write CUSTOM REPORTS

Topic		Replies	Views
Custom Reports (a work in progress)	13	1582	September 7, 2018
SQL schema for creating custom reports	61	11772	March 5, 2018
Custom Reports	72	17150	May 17, 2018
Custom report	6	1334	December 7, 2017
Request: How to create reports	21	927	April 27, 2023

How to write CUSTOM REPORTS

Related topics