Working with Report Builder 3.0 - Learning SQL Server Reporting Services 2012 - page 302

2. Click on Edit as Text . The page opens with a top and bottom pane and a link

for importing as well as an icon ( ! ) to execute the query.

3. Paste the following SQL statement in the top box:

SELECT top 10 Person.Address.SpatialLocation, Person.Address.City,
Sales.SalesTerritory.SalesYTD,Sales.SalesTerritory.CostYTD
FROM Sales.SalesTerritory INNER JOIN
Person.StateProvince ON Sales.
SalesTerritory.TerritoryID= Person.StateProvince.TerritoryID INNER
JOIN
Person.Address ON Person.StateProvince.
StateProvinceID = Person.Address.StateProvinceID AND
Person.StateProvince.StateProvinceID =
Person.Address.StateProvinceID
where Person.Address.city ='Los Angeles'

4. Click on the execute icon ( ! ).

5. The bottom pane should show some 10 rows of data like the portion shown

in the following screenshot:

6. Click on Next . You will be back in the report design page. It is showing the

whole of California with a little filled circle in Los Angeles.