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.
|
2019.year 30.December-2020.year 05.January |
||||||||
|
1 |
Country |
|
|
tn |
summa |
|
||
|
|
Germany |
|
|
164.876 |
1 666.01 |
|
||
|
|
Italy |
|
|
217.877 |
2 810.88 |
|
||
|
|
• |
|
|
382.753 |
4 476.89 |
|
||
|
|
|
|
|
|
|
|
||
|
2 |
Country |
Province |
|
tn |
summa |
|
||
|
|
Germany |
2 |
|
164.876 |
1 666.01 |
|
||
|
|
|
Germany |
• |
|
164.876 |
1 666.01 |
|
|
|
|
Italy |
3 |
|
100 |
1 150.00 |
|
||
|
|
Italy |
22 |
|
117.877 |
1 660.88 |
|
||
|
|
|
Italy |
• |
|
217.877 |
2 810.88 |
|
|
|
|
|
• |
• |
|
382.753 |
4 476.89 |
|
|
|
|
|
|
|
|
|
|
||
|
3 |
|
Date |
|
tn |
summa |
|
||
|
|
|
|
2020.01.02 |
|
282.753 |
3 326.89 |
|
|
|
|
|
2020.01.05 |
|
100 |
1 150.00 |
|
||
|
|
|
• |
|
382.753 |
4 476.89 |
|
||
|
|
|
|
|
|
|
|
||
|
4 |
Product |
Date |
|
tn |
summa |
$zr... |
||
|
|
frezkudra |
2020.01.02 |
|
212.753 |
1 900.01 |
^oPeat(1)•^oPeat(3) |
||
|
|
frezkudra |
2020.01.05 |
|
60 |
550.00 |
^oPeat(5) |
||
|
|
frezkudra |
• |
|
272.753 |
2 450.01 |
|
||
|
|
gabalkudra |
2020.01.02 |
|
70 |
1 426.88 |
^oPeat(2)•^oPeat(4) |
||
|
|
gabalkudra |
2020.01.05 |
|
40 |
600.00 |
^oPeat(6) |
||
|
|
gabalkudra |
• |
|
110 |
2 026.88 |
|
||
|
|
• |
• |
|
382.753 |
4 476.89 |
|
||
|
|
|
|
|
|
|
|
||
|
5 |
Product |
Date |
|
tn |
summa |
$zr |
||
|
|
frezkudra |
2020.01.02 |
67.877 |
700.00 |
^oPeat(1) |
|||
|
|
frezkudra |
2020.01.02 |
144.876 |
1 200.01 |
^oPeat(3) |
|||
|
|
gabalkudra |
2020.01.02 |
50 |
960.88 |
^oPeat(2) |
|||
|
|
gabalkudra |
2020.01.02 |
20 |
466.00 |
^oPeat(4) |
|||
|
|
• |
2020.01.02 |
|
282.753 |
3 326.89 |
• |
||
|
|
frezkudra |
2020.01.05 |
60 |
550.00 |
^oPeat(5) |
|||
|
|
gabalkudra |
2020.01.05 |
40 |
600.00 |
^oPeat(6) |
|||
|
|
• |
2020.01.05 |
|
100 |
1 150.00 |
• |
||
|
|
• |
• |
|
382.753 |
4 476.89 |
• |
||
|
|
|
|
|
|
|
|
||
|
mx |
||||||||
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