Creating a simple RDP report

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.

Getting ready

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.

How to do it…

1. 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.
2. For the present scenario, we will create a temporary table called PKTInterestCalcTmp with the fields Amount, Interest, Total, and Year.
3. In the table, set the property TableType as InMemory to make it temporary.

   Note

   There are three types of TableType properties: Regular, InMemory, and TempDB. Regular tables are standard physical tables, while InMemory and TempDB are...