-
Create a new query, and then drag the required fields from the published model into the facts.
-
If the report requires grouping, drag those group fields from fact to dimension.
-
Add data items for labels required in the report.
-
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
-
-
Add filter conditions for all the parameters created specifically for the report.
-
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.