Reports from global

Downloads5
Subscribe
0
Bookmark
1
This application is not supported by InterSystems Corporation. Please be notified that you use it at your own responsibility.
Details
Releases
Reviews
Issues
Articles

What's new in this version

Initial Release

Installation:

  • 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)

Call example:

  • 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.

Demo:

USER> set x=##class(Reports.Term).TreeDemo()

Result:

  • __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

Rating
3 (1)
Category
Solutions
Works with
CachéInterSystems IRIS
Tags
Info
Version
1.0.0
Last updated
2020-03-22
Repository
Open
Documentation
Open
License
Link