or
<telerik:RadHtmlChart runat="server" ID="RadHtmlChart2" DataSourceID="SqlDataSourceActionColor" OnDataBound="RadHtmlChart2_DataBound"> <PlotArea> <Series> <telerik:ColumnSeries DataFieldY="Value" Name="IncidentByMonth"> </telerik:ColumnSeries> </Series> <XAxis DataLabelsField="COLOR"> <LabelsAppearance RotationAngle="300"> </LabelsAppearance> </XAxis> <YAxis> <TitleAppearance Text=""> </TitleAppearance> </YAxis> </PlotArea> <Legend> <Appearance Visible="false"> </Appearance> </Legend> <ChartTitle Text="Near Miss by Risk Category"> </ChartTitle></telerik:RadHtmlChart><asp:SqlDataSource ID="SqlDataSourceActionColor" runat="server" ConnectionString="<%$ ConnectionStrings:OSHAConnectionString %>" SelectCommand=" select a.COLOR, a.Action, b.Value from ( select 'RED' as COLOR, 'ACTION NECESSARY' as Action UNION ALL select 'YELLOW' as COLOR, 'ACTION APPROPRIATE IF PRATICAL AND ECONOMIC' AS ACTION UNION ALL select 'GREEN' as COLOR, 'NO ACTION REQUIRED' AS ACTION ) a LEFT OUTER JOIN ( select count(ID) as Value, ActionColor, Action from [aaa_v_ReportingData] where YEAR = @Year and Location = @Location group by ActionColor, Action ) B ON B.ACTIONCOLOR = A.COLOR"> <SelectParameters> <asp:ControlParameter ControlID="RadComboBox2" Name="Year" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="RadComboBox1" Name="Location" PropertyName="SelectedValue" /> </SelectParameters></asp:SqlDataSource>

