Designing Data Access - Professional SQL Server 2005 Reporting Services - page 141

ON Sales.Customer.CustomerID = Sales.Store.CustomerID
INNER JOIN Person.Address
ON Sales.CustomerAddress.AddressID = Person.Address.AddressID
INNER JOIN Person.StateProvince
ON Person.Address.StateProvinceID = Person.StateProvince.StateProvinceID
INNER JOIN Person.CountryRegion
ON Person.StateProvince.CountryRegionCode
= Person.CountryRegion.CountryRegionCode
WHERE (Person.Address.City = @City)
AND (Person.StateProvince.StateProvinceID = @StateProvinceID)
Let's now look into configuring parameters.
Switch to the Layout tab and select the Report item from the Properties window drop-down list. Click
the ellipsis button next to the ReportParameters property. This opens the Report Parameters dialog, as
seen in Figure 5-18.
Figure 5-18
The CountryCode parameter will get its values from the Country_List data set. Like most typical lookup
tables, the key value is not intended to be a user-readable value but is used to indicate the selected coun-
try for related tables through a foreign key relationship.
Select this parameter in the Parameters list box and then enter Country for the prompt. This is the cap-
tion the user will see next to the parameter drop-down list when they view the report. Ensure that all of
the check boxes are unchecked to indicate that the user must select a value from the drop-down list.
The parameter drop-down list will display values in the Name column and return the corresponding
value in the CountryRegionCode column. Set the Label field and Value field properties accord-
ingly. Finally, indicate that there is no default value by selecting the last radio button, and click OK when
you're done.