Data items based on temporary tables

In all reports created in this chapter, we took data directly from a table and mapped table fields to report UI elements. But this is not always possible; complicated analysis reports often require aggregated data that cannot be simply extracted from a table, but requires preprocessing.

In the next example, we will create a report presenting a list of customers with quarterly payment amounts calculated for each customer. This information is not stored anywhere in the database; amounts have to be calculated and stored in a temporary table.

Create a report, 50502 Quarterly Payments. The following table lists the global variables required in the report. Declare these variables in C/AL Globals:

Name DataType ...

Get Microsoft Dynamics NAV Development Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.