CHAPTER 5 IMPLEMENTING DASHBOARD STYLE REPORT OBJECTS
Listing 5-4. RDL Output for the Map Control<ReportItems>
<Map Name="Map5">
<MapViewport>
<MapCoordinateSystem>Geographic</MapCoordinateSystem>
<MapProjection>Mercator</MapProjection>
<ProjectionCenterX>NaN</ProjectionCenterX>
<ProjectionCenterY>NaN</ProjectionCenterY>
<MapLimits>
<MinimumX>NaN</MinimumX>
<MinimumY>NaN</MinimumY>
<MaximumX>NaN</MaximumX>
<MaximumY>NaN</MaximumY>
</MapLimits>
<MaximumZoom>4000000</MaximumZoom>
<MapCustomView>
<CenterX>46.09375</CenterX>
<CenterY>63.4690780639648</CenterY>
<Zoom>100</Zoom>
</MapCustomView>
<MapMeridians>
<Style>The completed Map object report is called Map.rdl and is located in the Pro_SSRS project.Implementing a Data Bar
Another new addition to Reporting Services 2008 R2 was the Data Bar. For those of you who are savvy
Excel users, you may recognize this report object from your tinkering in Excel. This object is essentially a
single bar chart (most often displayed horizontally) which allows for a quick at-a-glance, row by row
comparison. Longer bars equate to higher values and shorter bars unequivocally mean lower values.
In this example, we are going to start with the report named Data Bar Start.rdl in our Pro_SSRS
project. You will notice that there is a dataset named Emp_Svc_Cost_Data_Bar already defined that
executes a stored procedure to return the top ten States and the amount of visits for the specified
ServiceMonth parameter. We also have a table with only two columns. Expand the
Emp_Svc_Cost_Data_Bar dataset and drag the StateName field into the first column of the details row in
the table. Next drag the Data Bar report item into the second column of our details row. Upon releasing
the Data Bar, you will be prompted to select the type of Data Bar that you want. Your options are:- Bar
- Stacked Bar
- 100% Stacked Bar
- Column
- Stacked Column
- 100% Stacked Column