Report building – phase 1
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:
The easy way to create the preceding report data structure definition is simply type the letter D in the Data Type column, tab to the Data Source column, enter the target table number (in this case 50001
, then 50000
, and 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 that we've got some test data in our tables. To enter data, we can either use the pages that we built earlier or, if those aren't done yet, we can just Run the tables and enter some sample data. The specifics of our test data aren't critical.
We simply need a reasonable distribution of data so that our report test will...