For customers in the m-Power community running Apache Tomcat 10 with m-Power, a common question mrc gets is how to update their Tomcat 10. For instance, clients running Tomcat 10.1.40 can update to the latest version (at the time of writing this, 10.1.52) in order to meet security compliance or…
The article addresses the challenge of working with non-standard date formats (e.g., yyyymmdd, mmddyyyy, cyymmdd) in databases. To facilitate date arithmetic, filtering, and conversions, this will show you how to create and use a Date Calendar Table that maps various date representations to a standard ISO format (yyyy-mm-dd).
Excel output is a very popular choice among users for exporting report data from m-Power. When an Excel output is made from an m-Power report, the total line values in the generated output are raw values from the query rather than an Excel formula. For developers who want their total…
All of m-Power’s Bootstrap themed templates incorporate the idea of responsive design. When working with grid based templates (like the Multiple Row Data List retrieval or the Grid Update maintainer), out of the box the presentation tries to fit as many columns on the screen as possible, meaning the spacing…
Learn how to use Freemarker to handle subtotaling in your report output. This example will walkthrough a report with a one-to-many join, and show how to specifically count duplicate detail records only one time.