How to write CUSTOM REPORTS

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.

A post was split to a new topic: Mobile version of Manager

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 official documentation before doing much more than this.

1 Like

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 accessible via the API, you might get some ideas for other tables that are accessible. But it’s not a 1:1 match, most of the ones listed in the API are not accessible via Custom Reports.

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.