Reports from global

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

Open Exchange - is a place for developers and where they share and find useful tools for development process. If your product is made for developers needs you may also publish it on Open Exchange.

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