• Date Calendar Table

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

  • m-Power Reports: Adding auto sum capabilities to the Excel output

    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…

  • Adjusting column widths in grid based templates

    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…

  • Working with Duplicate Data in Reports

    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.

  • Validating via Microsoft Entra

    Overview This tech blog post will discuss how m-Power customers using a SQL Server datasource may authenticate to said via Microsoft Entra, formally known as Azure Active Directory (AAD). Traditionally, the datasource connection is made via SQL Authentication, however if wanting to use Microsoft Entra instead when connecting to SQL…