Hey guys,

I'm beginning my foray into MS SQL Reporting Services and loving every minute of it.

I've loaded the Report server onto SQL 2000 SP4 and have loaded SRS SP2 as well.

The problem I'm having is with adding a <Style></Style> section to the <Datapoint></Datapoint> section of a chart control. I am supposed to be able to control the color of the datapoints (with the <Color> element) but am having no such luck. The control always defaults to the default colors.

Code:
              <DataPoint>
                <DataValues>
                  <DataValue>
                    <Value>=Sum(Fields!UnitsInStock.Value)</Value>
                  </DataValue>
                </DataValues>
                <DataLabel>
                  <Value>=Fields!CategoryName.Value</Value>
                  <Visible>true</Visible>
                </DataLabel>
                <Style>
                  <Color>=Code.GetColor(Fields!CategoryName.Value)</Color>                  
                </Style>
...
  <Code>    Private Shared colorPalette As String() = {"Blue", "Green", "Red", "Orange", "Aqua", "Teal", "Gold", "RoyalBlue", "#A59D93", "#B8341B", "#352F26", "#F1E7D6", "#E16C56", "#CFBA9B"}
    Private Shared count As Integer = 0
    Private Shared 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
</Code>
This works very well in other controls, just not the Chart control.

Has anyone else out there worked with SRS and the Chart control?

Thanks!

Ben