Designing the Main Page Query - HxGN EAM - Version 11.07.01 - Help

HxGN EAM Advanced Reporting Author Guide

Language
English
Product
HxGN EAM
Search by Category
Help
HxGN EAM Version
11.7.1
  1. Create a new query, and then drag the required fields from the published model into the facts.

  2. If the report requires grouping, drag those group fields from fact to dimension.

  3. Add data items for labels required in the report.

  4. To get the description, use the REPGETDESC function from the Functions\AdvRepData\Physical\ReportFunctions.

    The following are some standard functions that can be used in the report

    • REPFMTNUM: Format number field as per user local

    • REPFMTMONNUM: Format monetary number field as per user local

    • REPFMTWHOLENUM: Format Whole number field as per user local

    • REPGETFMTDATE: Format Date field as per user local

    • REPGETFMTDATI: Format Date time field as per user local

  5. Add filter conditions for all the parameters created specifically for the report.

  6. Add a list in the detail page and use the new query created for this report, and then insert the desired columns and groups in the report’s details page.