I'm trying to create a chart with 2 series and I keep an error when I attempt to build it.
Exception Details: System.FormatException: Input string was not in a correct format.
My Code
<
chartfx7:Chart ID="Chart1" runat="server" DataSourceID="ClientScoreDistribution" Height="250px" Width="375px">
<DataSourceSettings>
<Fields>
<chartfx7:FieldMap DisplayName="PercentOfShops" Name="PercentOfShops" Usage="Value" />
<chartfx7:FieldMap DisplayName="SurveyYear" Name="SurveyYear" Usage="ColumnHeading" />
<chartfx7:FieldMap DisplayName="ScoreGroupIncrementsOf10" Name="ScoreGroupIncrementsOf10" Usage="RowHeading" />
</Fields>
</DataSourceSettings>
<Series>
<chartfx7:SeriesAttributes Text="SurveyYear 0" />
<chartfx7:SeriesAttributes Text="SurveyYear 1" />
<chartfx7:SeriesAttributes Text="SurveyYear 2" />
</Series>
</chartfx7:Chart>
<br />
<asp:SqlDataSource ID="ClientScoreDistribution" runat="server" ConnectionString="<%$ ConnectionStrings:BMDW02.BMDWConnectionString %>"
SelectCommand="SELECT NDW_DetailRecords.ClientId, NDW_DetailRecords.QuestionnaireHeaderID, NDW_DetailRecords.SurveyYear, NDW_DetailRecords.ScoreGroupIncrementsOf10, COUNT(NDW_DetailRecords.NDW_DetailRecordsId) AS ScoreGroupNumberOfShops, NDW_EntitySnapshot.YTDNumberOfShops, CONVERT (decimal(18 , 4), CONVERT (decimal(18 , 4), COUNT(NDW_DetailRecords.NDW_DetailRecordsId)) / CONVERT (decimal(18 , 4), NDW_EntitySnapshot.YTDNumberOfShops)) AS PercentOfShops FROM NDW_DetailRecords INNER JOIN NDW_EntitySnapshot ON NDW_DetailRecords.ClientId = NDW_EntitySnapshot.ClientId AND NDW_DetailRecords.QuestionnaireHeaderID = NDW_EntitySnapshot.QuestionnaireHeaderID WHERE (NDW_DetailRecords.YearsBack IN (0, - 1)) AND (NDW_EntitySnapshot.OrgLevel = 'company') GROUP BY NDW_DetailRecords.ClientId, NDW_DetailRecords.QuestionnaireHeaderID, NDW_DetailRecords.ScoreGroupIncrementsOf10, NDW_EntitySnapshot.YTDNumberOfShops, NDW_DetailRecords.SurveyYear HAVING (NDW_DetailRecords.ClientId = @ClientId) AND (NDW_DetailRecords.QuestionnaireHeaderID = @QuestionnaireHeaderId)">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="SV" Name="ClientId" QueryStringField="ClientId" Type="String" />
<asp:QueryStringParameter DefaultValue="74" Name="QuestionnaireHeaderId" QueryStringField="QuestionnaireHeaderId" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>