Preview
Please note, that in long description you should mention:
• App's goals and functions
• How to use the app
• If it is open source app - please, provide the installation instructions
Previous value: `https://github.com/mx-alex/MX`
Previous value: `Reports from global`
Previous value: `Download`
Previous value: `Solutions`
Previous value: `Caché, InterSystems IRIS`
Previous value: ``
Previous value: `Not checked`
Previous value: `Based on the information from a global, using one query, we can create several reports at once.`
Previous value: `<b>Installation: </b>
- Unzip MX to any folder /path/to/mymx, then :
- $ docker run --name myiris -p 52773:52773 -v /path/to/mymx:/mx -d store/intersystems/iris-community:2020.1.0.202.0
- $ docker exec -it myiris iris session iris
- USER> do $System.OBJ.ImportDir(“/mx”,”vmx.ro”,”ck”,,1)
- USER> do $System.OBJ.ImportDir("/mx","reports.cls","ck",,1)
<b>Call example: </b>
- USER> set p="^oPeat | Country Country:Date | tn cost | d8 Province Product | | if Date'<20200101,Date'>20200222 | set cost=summa,d8=$$gmd^MXD(Date)"
- USER> set p1="Country | tn | cost | d8 " ; line to print for report 1
- USER> set p2="Country | Date | tn | cost " ; line to print for report 2
- USER> set x=##class(Reports.Term).Tree(p,p1,p2)
The parameter ‘p’ consists of the following |fields|:
- global name -- ^oPeat
- reports structure -- Country Country:Date
- a list of variable names to summarize in reports -- tn cost
- a list of names for easy movement from global to reports -- d8 Province Product
- reserved field
- field for the condition (filter)-- if Date'<20200101,Date'>20200222
- field for additional commands -- set cost=summa,d8=$$gmd^MXD(Date)
Reporting globals ^om, ^oTQMo will be generated for future reference.
<b>Demo: </b>
USER> set x=##class(Reports.Term).TreeDemo()
<b>Result: </b>
- __Country_____tn___________cost_______d8
- --------------------------------------------------------------------
- _France______390___________5160.00___2020.02.16꘎2020.02.17꘎2020.02.18
- _Germany_____659.752_______6598.02___2020.01.02꘎2020.01.06꘎2020.02.05
- _Italy_______435.754_______5621.76___2020.01.02꘎2020.01.05
- _꘎TOTAL꘎_____1485.506_____17379.78
-
-
- _Country_____Date________tn__________cost
- --------------------------------------------------------------------
- _France______2020.02.16__130___________1980.00
- _France______2020.02.17__130___________1980.00
- _France______2020.02.18__130___________1200.00
- _France______꘎TOTAL꘎_____390___________5160.00
- _Germany_____2020.01.02__329.752_______3332.02
- _Germany_____2020.01.06__260___________2866.00
- _Germany_____2020.02.05__70_____________400.00
- _Germany_____꘎TOTAL꘎_____659.752_______6598.02
-
- _Italy_______2020.01.02__235.754_______3321.76
- _Italy_______2020.01.05__200___________2300.00
- _Italy_______꘎TOTAL꘎_____435.754_______5621.76
-
- _꘎TOTAL꘎_____꘎TOTAL꘎_____1485.506_____17379.78
USER>
Limitations for the global.
- The length of all branches is the same.
- The last level index names are in accordance with the MUMPS standard for simple variables.
- The % sign is not used in last level index names.
Global example:
- ^oPeat(1,"Date")=20200102
- ^oPeat(1,"Product")="frezkudra"
- ^oPeat(1,"Province")=22
- ^oPeat(1,"n")=1
- ^oPeat(1,"summa")=700
- ^oPeat(1,"tn")=67.877
- ^oPeat(2,"Country")="Italy"
- ^oPeat(2,"Date")=20200102
- ^oPeat(2,"Product")="gabalkudra"
- ^oPeat(2,"Province")=22
- ^oPeat(2,"n")=2
`
Previous value: `https://github.com/mx-alex/mx/blob/master/LICENSE`
Previous value: `https://community.intersystems.com/post/multiple-reports-one-request-mx`
Previous value: `https://github.com/mx-alex/mx/blob/master/README.md`
Previous image: Not set