Our goal is to create a report for our WDTU data that will give us a list of all the scheduled radio show instances organized within Radio Show organized by Radio Show Type, as shown in the following screenshot:
An easy way to recreate the preceding screenshot is to simply type the letter D in the Data Type column, enter the target table number (in this case 50001, then 50000, then 50002) in the Data Source column, drop to the next line, and do it again. Then, save the new report skeleton as Report 50001, Shows by Type.
Before we go any further, let's make sure we've got some test data in our tables. To enter data, ...
