SQL Server R2 map report creation (2)

SQL Server R2 map report creation (2)

The map Preview pane also displays the following items:

A title, whose text is the map title.

A map shows all towns and towns in Washington, each of which is in a different color, and the township name appears at the top of the area.

A legend that contains the title and the list of items 1 to 5.

A color level with 0 to 160 values but no color.

One distance width indicates the kilometer (km) and kilometer (mi ).

Click Finish ". The design view is displayed and displays the map on the report design surface.

Click map to select it and the map layer area is displayed. As shown in:

Server R2 map report creation (2) "name = image_operate_73503851215756700 alt =" SQL Server R2 map report creation (2) "src =" http://s10.sinaimg.cn/middle/66ff669et8429d4ef6449&690&690 "action-type =" show-slide "action-data =" http % 3A % 2F % 2Fs10.sinaimg.cn % 2 Fmiddle % 2F66ff669et8429d4ef6449% 26690% "real_src =" http://s10.sinaimg.cn/middle/66ff669et8429d4ef6449&690&690 ">

 

The map layer area displays a polygon layer with the layer type "embedded. Each township is an embedded map element on this layer.

Right-click the map title and click "title attributes ".

Server R2 map report production (2) "alt =" SQL Server R2 map report production (2) "src =" http://s5.sinaimg.cn/middle/66ff669et8429d4dd33c4&690&690 "action-type =" show-slide "action-data =" http % 3A % 2F % 2Fs5.sinaimg.cn % 2 Fmiddle % 2F66ff669et8429d4dd33c4% 26690% "real_src =" http://s5.sinaimg.cn/middle/66ff669et8429d4dd33c4&690&690 ">

 

Replace the title text with AdventureWorks Reseller. Click OK ". Click "Preview" to Preview the report, as shown in:

Server R2 map report production (2) "alt =" SQL Server R2 map report production (2) "src =" http://s2.sinaimg.cn/middle/66ff669et8429d4f5cca1&690&690 "action-type =" show-slide "action-data =" http % 3A % 2F % 2Fs2.sinaimg.cn % 2 Fmiddle % 2F66ff669et8429d4f5cca1% 26690% "real_src =" http://s2.sinaimg.cn/middle/66ff669et8429d4f5cca1&690&690 ">

A simple map report for Washington, DC is created. The report includes the report title, map title, map, and distance scale. Different towns and towns are distinguished by colors in the color palette, but the colors are not associated with any data. The distance between the scale is displayed in both kilometers and Miles. Legends and levels are not displayed because they have no associated data. The binding of data to the map area is described below.

2.2 use SQL space data to create a map layer

Next, we will add a new map layer based on the preceding report through another data source-SQL space data. We will add a map layer, displays the location of the store that sells the AdventureWorks product. The procedure is as follows:

Switch to the design view.

Double-click a map to display the map layer area. On the toolbar, click the new layer wizard button.

Server R2 map report production (2) "alt =" SQL Server R2 map report production (2) "src =" http://s9.sinaimg.cn/middle/66ff669et8429d4ee7be8&690&690 "action-type =" show-slide "action-data =" http % 3A % 2F % 2Fs9.sinaimg.cn % 2 Fmiddle % 2F66ff669et8429d4ee7be8% 26690% "real_src =" http://s9.sinaimg.cn/middle/66ff669et8429d4ee7be8&690&690 ">

On the "select spatial data source" Page, select "SQL Server spatial query" and click "Next ".

On "select connection to SQL Server space data source", click "new ".

In the "Data Source properties" dialog box, click "General ". As shown in, create a data source SQLMap and connect to the Adventureworks database.

Server R2 map report production (2) "alt =" SQL Server R2 map report production (2) "src =" http://s10.sinaimg.cn/middle/66ff669et8429d4ff1889&690&690 "action-type =" show-slide "action-data =" http % 3A % 2F % 2Fs10.sinaimg.cn % 2 Fmiddle % 2F66ff669et8429d4ff1889% 26690% "real_src =" http://s10.sinaimg.cn/middle/66ff669et8429d4ff1889&690&690 ">

Click OK,