No bars display when Chart.Series values set via code

No bars display when Chart.Series values set via code

Posted by: raleigh on 31 October 2017, 5:06 pm EST

• 

  raleigh

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 31 October 2017, 5:06 pm EST

  Using VisualStudio 2013 with VB.Net and AR 11.
  
  Have a section report with 1 Chart control in the detail section. If i set the Chart to have 3 Series and then set the ‘.ValueMemberX’ and ‘ValueMembersY’ properties in designer…all is good. The Chart displays the bars for each of the 12 Months along the X axis.
  
  When i attempt to create/add the Series dynamically, in code…only the Legend is displayed. No bars are displayed on the Chart.
  
  I have placed the code below in the DataInitialize() and the DetailFormat() handlers.
  
  What might i be missing?

              
  Dim arChartSeries As New Chart.Series
  
              chartSales.DataSource = rptDataTable        'this is a System.Data.DataTable
  
              arChartSeries = New Chart.Series
              arChartSeries.Name = "Tasting Room"
              arChartSeries.Visible = True
              arChartSeries.ValueMemberX = rptDataTable.Columns("Month").ColumnName
              arChartSeries.ValueMembersY = rptDataTable.Columns("TastingRoom").ColumnName
              chartSales.Series.Add(arChartSeries)
  
              arChartSeries = New Chart.Series
              arChartSeries.Name = "Wine Club"
              arChartSeries.Visible = True
              arChartSeries.ValueMemberX = rptDataTable.Columns("Month").ColumnName
              arChartSeries.ValueMembersY = rptDataTable.Columns("WineClub").ColumnName
              chartSales.Series.Add(arChartSeries)
  
              arChartSeries = New Chart.Series
              arChartSeries.Name = "Other Sales"
              arChartSeries.Visible = True
              arChartSeries.ValueMemberX = rptDataTable.Columns("Month").ColumnName
              arChartSeries.ValueMembersY = rptDataTable.Columns("OtherSales").ColumnName
              chartSales.Series.Add(arChartSeries)
  
  

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 1 November 2017, 4:56 am EST

  Hello,

  You have to set “DataSource” of Chart after adding “Series” to the “Chart”. Please use the following modified code:

  Dim arChartSeries As New Chart.Series

          arChartSeries = New Chart.Series
          arChartSeries.Name = "Tasting Room"
          arChartSeries.Visible = True
          arChartSeries.ValueMemberX = rptDataTable.Columns("Month").ColumnName
          arChartSeries.ValueMembersY = rptDataTable.Columns("TastingRoom").ColumnName
          chartSales.Series.Add(arChartSeries)
  
          arChartSeries = New Chart.Series
          arChartSeries.Name = "Wine Club"
          arChartSeries.Visible = True
          arChartSeries.ValueMemberX = rptDataTable.Columns("Month").ColumnName
          arChartSeries.ValueMembersY = rptDataTable.Columns("WineClub").ColumnName
          chartSales.Series.Add(arChartSeries)
  
          arChartSeries = New Chart.Series
          arChartSeries.Name = "Other Sales"
          arChartSeries.Visible = True
          arChartSeries.ValueMemberX = rptDataTable.Columns("Month").ColumnName
          arChartSeries.ValueMembersY = rptDataTable.Columns("OtherSales").ColumnName
          chartSales.Series.Add(arChartSeries)
          chartSales.DataSource = rptDataTable        'this is a System.Data.DataTable
  

  Hope it helps.

  Thanks,
  
  Mohit

• 

  raleigh

  • Post Options:
  • Link
    Copy

  Posted 1 November 2017, 12:18 pm EST

  That did the trick. Thank you for the quick reply.