Lookup Related table data
Once we have a successful test of the report (heading only), we'll move on to laying out the body of the report. As we think through the data we want to include in a mailing address (Name, Address, Address 2, City, County (State), Country Name, Post Code), we realize that our table data includes Country Code, not Country Name. So we will look up the Country Name from the Country/Region table (Table 9). Let's take care of that now.
First we'll add a couple of Global Variables to our report. One of them will allow us to access the Country/Region table and the other will act as a holding place for the Country Name data we get from that table.
Each time we read a Radio Show Fan record, we'll look up the country name for that fan and store it in CountryName.
Now we can add the CountryName variable to the list of data elements attached to DataItem Radio Show Fan so it will be included in the data passed to the Report Builder and, when the report...
