In this recipe, we will help you to understand the concept of the RDP class. We will create a simple SSRS report using the RDP class and write a simple business logic in the RDP class to calculate the compounded interest and print it in the report.
To be able to do this recipe and the others involving RDP in this chapter, you need a basic understanding of X++, data contracts, and data attributes.
An RDP uses a temporary table to store data. So the first step in RDP development is to identify the fields involved in the report and create them as part of a temporary table.
For the present scenario, we will create a temporary table called PKTInterestCalcTmp with the fields Amount, Interest, Total, and Year.
In the table, set the property TableType as InMemory to make it temporary.