SSRS + report builder 3.0

Question

Helo I'm beginner with Report builder and I need some help please

I'm trying out the tutorial  : Report Builder 3.0   Tutorial: Adding a KPI to Your Report (Report Builder 3.0)

that we can find when we press "help" regarding a gauge pannel properties 

and I have two questions...

1) For a gauge

....

16(Optional) Add a maximum pin to handle overflow so that any value over the scale maximum always points to the maximum pin:

1. Open the Properties pane.
   
   
2. Click the scale. The properties for the linear scale are displayed in the Properties pane.
   
   
3. In the Scale Pins category, expand the MaximumPin node.
   
   
4. Set the Enable property to True. A pin appears after the maximum value on the scale.
   
   
5. Set BorderColor to Lime

How to manage this part? In pointer Properties? I don't understand this notion of scale pine

 

2) I test the indicator

.....To display the present state of a KPI using an indicator

1. Switch to Design view.

2. In the table, right-click the column handler for the cell that you changed in the previous procedure, point to Insert Column, and then click Right. A new column is added to the table.

3. Type KPI in the column heading.

4. Click the cell for the subcategory subtotal.

5. On the Insert tab, in the Data Regions group, double-click Indicator.

   The Select Indicator Type dialog box opens.

6. Click Shapes. The first shape type, 3 Traffic Lights (Unrimmed), is selected.

   You will use this indicator in the tutorial.

7. Click OK.

   The indicator is added to the design surface.

8. Right-click the indicator and click Indicator Properties.

9. Click Values and States.

10. In the Value drop-down list, select [Sum(Sales)], but do not change any other options.

    By default, data synchronization occurs across the data region and you see the value Tablix1, the name of the table data region in the report, in the Synchronization scope box.

    In this report, you can also change the scope of an indicator placed in the cell of the subcategory subtotal to synchronize across the SalesDate field.

11. Click Run to preview the report.

My question is with  what value is compared  sum ​​(sales) of the line sub-category?

With the grand total?  With the grand total (all days combined) sub categories?

What means SCPOPE Tablix1 please ?

Thank you very much for your help

 

Christopher

Answer 1

How to manage this part? In pointer Properties?

In the Scale Pins category, expand the MaximumPin node. The top property in the property pane under Scale Pins > MaximumPin is BorderColor. Click the dropdown arrow and select Lime color (4th column from left, fourth row from top in the color grid).

My question is with what value is compared sum ​​(sales) of the line sub-category?

With the grand total? With the grand total (all days combined) sub categories?

What means SCPOPE Tablix1 please ?

These questions all tie in together.

First what is it compared to? On the same pane (Values and States) that you enter Sum(Sales) in the Value, you will see (at the bottom) Indicator States. By default there are 3 lines. The first says to set the state to Red if the Value is between 0 and 33. Next, yellow if the value is 33 to 66. Last, Green if between 66 and 100. Those are the values it is compared to.

The Scope is set by the table that contains the indicator. For instance, I can create a table that groups my data first by Region, then by Country. Suppose I have 7 regions, one for each continent. If I place an indicator in the Region group, it will be repeated once for each region when the report is viewed. The scope of a given indicator is the region group it is in. So that scope will include the data for all of the countries in that region.

The tutorial said not to change anything else in the Values and States however for most actual reports you will write, you will probably need to adjust the predefined ranges.