Multiple reports in one request MX

There is a special Query for reporting, it takes one cell of Excel. Example :

?$$omQuery 113^oPeat | Country   Country:Province   Date   Product:Date   Date:Product:-zr   | tn EURO | zrzr| | if Date'<%XD81,Date'>%XD82 |  set zrzr=zr,EURO=summa

The omQuery sets the structure and content of the required documents as well as filters and data processing procedures.

In one request, up to 9 reports are created, with subtotals by group. (5 here , 3 with:subtotals )

All issued documents retain the interactivity property - any manipulations with cells are displayed in excel and in virtual m-excel synchronously.

Each cell can be a field for entering information into the database or a button or drop-down list.

Up to a million rows and 16,000 columns.

For experiments with omQuery, upgrade or install  MX, start mx.xlsb, connect to server.

The panel with buttons will expand.

Set the date (icon ‘31’ at the top of the screen MX) January or February 2020, or week number, or period. Press button ‘reports’. Click icon ‘design’ for open formulas and omQuery.

You can test without m-server installation - start mx.xlsb and click [test-CACHE-32 bit-internet]

You can edit the global ^oPeat in any way and see how the reports change.

Any questions  sia.enters@inbox.lv  or here.

Best wishes

Alex