CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0- To get started, we are going to remove the extra items that are added by. Right-
click on the Map and remove the checkbox from Show Meridians. Do it again
to remove the checkbox from Show Parallels. Perform the same action for the
Color Scale (bottom left) and the Distance Scale (bottom right). Right-click on
the legend and then select Delete Legend. Perform the same action for the
Map Title, At this point, the Map looks like a giant grey rectangle right? I would
say that we are all done, but that would be a joke. In actuality, now we are
ready to work some mapping magic. - Right-click the map, select Map, and then Add Layer. Leave the default Map
Gallery selected, choose the USA by State Inset, and then click Next. We will set
the zoom to be dynamic later on, so for now, click Next on the Choose spatial
data and map view options screen to progress through the New Map Layer
wizard. Choose the middle option, Color Analytical Map and click Next. We
could create a new dataset or browse for another one, but we already have one
that we can use. Select our Emp_Svc_Cost_RB3 dataset that already exists in
our report and hit Next. In the Specify the match fields for spatial and
analytical data screen, put a checkbox in STATENAME, and then select
BranchStateName as the Analytical Dataset Field to map to Click Next. Set the
Theme to Generic, Field to Visualize to BranchStateName, and click Finish to
complete the map layer wizard. - Click on one of the States to bring up the Map Layers box and click on the
down arrow next to the image of the eye. Select Polygon Color Rule. For this
example, we are going to choose the option to Visualize data by using custom
colors. Next, click the Add custom colors button and set the color to be Sea
Green. Click OK to save the Map Color Rules Properties. - Resize the map to be the same width of the BranchStateName textbox and
approximately 2.5 inches in height. Resize the width of the column that
contains the map to be about 2 inches wide. Set the height of the row
containing the map to be around 2.5 inches. - Right-click on the map and select Viewport Properties. Navigate to the Fill tab
and set the Fill style to be Solid. Click on the Border tab and set the Line style
to None. Click on the Shadow tab and set the Shadow offset to be 0pt. Now to
have the map dynamically zoom into the State, click on the Center and Zoom
tab. Change the setting to Center map to show all data-bound map elements
and set the zoom level to be 1000. Click OK to save the Viewport Properties. - Expand the Parameters folder in the Report Data pane. Next we’re going to add
a few year values for our ServiceYear parameter. Double-click on the
ServiceYear parameter to open its properties window. Click on the Available
values and select Specify values. Click the Add button three times to hold three
different values. For the first value, enter 2009 as the Value. Enter 2010 for the
next one and 2011 for the last one. Click on the Default Values tab and choose
the option to Specify values again. Click the Add button and set its value to be
2009. Click OK to save the Report Parameter Properties. The report should
closely resemble what is shown in Figure 13-65.