Showing posts with label Match between spatial data and analytical data.. Show all posts
Showing posts with label Match between spatial data and analytical data.. Show all posts

Population Statistics Report using Maps in ssrs

Create a report in SSRS which is a Population.Rdl report with DataSources.Rds and datasets data from a database table .

In SSIS toolbox select the map and drag on it to Designer body(canvas) and in the wizard

STEP 1:select the new map layer from the map gallery or ESRI shape file or SQL server spatial query and in the following steps
STEP 2: crop the map or add a layer
STEP 3: For map visualization select the theme from BASIC MAP,COLOR ANALYTICAL MAP,BUBBLE MAP
STEP 4: Choose the dataset that you created according to the requirement,
STEP 5: Specify the match fields between spatial data and analytical data
STEP 6: Choose the color theme, field to visualize , and color rule which is very important to view the data effects
STEP 7: Right click on polygon properties in the map layer and do customize according to your requirement , The polygon properties and polygon color rule are important to customize