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 | Subtype |
| TempCustomer | Record | Customer |
| TempCustomerPayment | Record | Customer Payment |
| StartingDate | Date | |
| EndingDate | Date | |
| EntryNo | ...
