Specify Consistent Colors across Multiple Shape Charts (Report Builder and SSRS)

Artykuł
02/16/2015

On non-shape charts, a new color is selected from the palette based on the index of series in the chart. For example, the first series on your chart will be mapped to the first color in the palette. However, this behavior differs for shape charts. On shape charts, each color in the palette is mapped to a data point in the dataset. For example, data point 1 is mapped to the first color in the palette, data point 2 is mapped to the second color palette and so on.

If a data point has no value, it is omitted from display on a shape chart. This means that the data point is skipped from being colored. For example, if point 2 has a value of zero, point 1 will be mapped to the first color in the palette, and point 3 will be mapped to the second color in the palette. This approach is useful because the empty points in the dataset of a pie chart do not unnecessarily use a palette color when the empty point does not need to be drawn.

As a side effect, when multiple pie charts are displayed in a report, the pie charts may display different colors for data points that have the same category grouping. To resolve this, you need to define individual colors that map to a category group instead of individual data values. How you do this depends on if the shape charts are sparklines in a table or matrix, or if they are shape charts in the report itself.

The legend is connected to the series, so any color you specify for the series will automatically be shown on the legend.

[!UWAGA]

You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

To specify consistent colors across multiple sparkline shape charts in a table or matrix

Click the chart to display the Chart Data pane.
In the Category Groups area, right-click a category and click Category Group Properties.
On the General tab, in the Synchronize groups in box, click the name of the category for which you would like to synchronize colors, and then click OK.

To specify consistent colors across multiple shape charts

Right-click outside the body of the report, and select Report Properties.
In Code, type the following code into the textbox.
```
    Private colorPalette As String() = {"Color1", "Color2", "Color3"}
    Private count As Integer = 0
    Private mapping As New System.Collections.Hashtable()
    Public Function GetColor(ByVal groupingValue As String) As String
        If mapping.ContainsKey(groupingValue) Then
            Return mapping(groupingValue)
        End If
        Dim c As String = colorPalette(count Mod colorPalette.Length)
        count = count + 1
        mapping.Add(groupingValue, c)
        Return c
    End Function
```
[!UWAGA]

You will need to replace the "Color1" strings with your own colors. You can use named colors, for example "Red", or you can use six-digit hexadecimal value that represent the color, such as "#FFFFFF" for black. If you have more than three colors defined, you will need to extend the array of colors so that the number of colors in the array matches the number of points in your shape chart. You can add new colors to the array by specifying a comma-separated list of string values that contain named colors or hexadecimal representations of colors.
Click OK.
Right-click on the shape chart and select Series Properties.
In Fill, click the Expression (fx) button to edit the expression for the Color property.
Type the following expression, where "MyCategoryField" is the field that is displayed in the Category Groups area:
```
=Code.GetColor(Fields!MyCategoryField)
```

Udostępnij za pośrednictwem

Specify Consistent Colors across Multiple Shape Charts (Report Builder and SSRS)

To specify consistent colors across multiple sparkline shape charts in a table or matrix

To specify consistent colors across multiple shape charts

Zobacz także

Zadania

Koncepcje

Dodatkowe zasoby