You can create a bullet graph based on the data source aggregated data.

Before adding a bullet graph to your report, you must connect your report to a data source (e.g. ReelsDataSource.rdsx) and a data set (e.g. Sales). The sample data source ReelsDataSource.rdsx is included with this installation.

1. From the toolbox, drag a Table item onto the body of your report. The table automatically spreads from the left edge to the right edge of the report body and contains header, detail, and footer rows.
2. With the table selected, set the DataSetName property to Sales.
3. From the toolbox, drag a Bullet item to the detail row of the table on your report.
4. In the property grid, drop down the box next to the Value property and select <Expression...>. In the Expression Editor under Fields, expand the Fields (Sales) node and select a numeric field from the connected data set (e.g. =Fields!SalesAmount.Value). Click the OK button to accept the change. 

   The Value property that we just used defines the key measure displayed on the graph.

   

5. Set the Target Value to 200. This property defines a target for the Value to be compared to.

   

6. Set the Best Value property to 500 and the Worst Value property to 0. The Best Value and Worst Value properties define the value range on the graph.

   

7. You can optionally encode the segments on the graph as qualitative ranges indicating bad, satisfactory and good sections.

• The Range1Boundary property defines a value for the bad/satisfactory boundary on the graph. Set this property to 150.
• The Range2Boundary property defines a value for the satisfactory/good boundary on the graph. Set this property to 300.

8.   You can optionally define the Interval property for the graph value range. Set this property to 100.

9.   Click the Preview tab to view the bullet graph you have added to your report.

As the bullet graph is based on the data source aggregated data, you will have a stack of bullet graphs indicating the Sales Amount value.