Multiple reports in one request MX

Primary tabs

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

 


Also, check the previous part: Show globals in Excel.