Most reports require some embedded logic to process user selected options, calculate values, or access data in related tables. To illustrate some possibilities, we will extend our WDTU application to add a new report.
To support promotions giving away posters, concert tickets, and so on, we must further enhance the Radio Show Fan table and create a new report to generate mailing information from it. Our first step is to create a new dataset in the Visual Studio Code IDE. We should define the data fields we want to include for mailings (including a global variable of CountryName), then save and compile the result as a report called 50102 "Fan Promotion List", as shown in the following screenshot:
