Histogram

Comments

• AlexTZ

  April 2010 edited 4:44PM

  Hello,
  
  The grouping feature of Microsoft Chart control is not working very well in case when you group by number interval, so it's better to prepare the grouped data before passing it to the chart.
• Xavi

  April 2010 edited 4:44PM

  Please can you provide a basic guide?
  
  I am creating a dll with the pre-processing functions. Now, I have several options, I have thought something like:
  
  
  var dataset=Distribution.CreateHistogram((Report.GetDataSource("ds") as ViewDataSource).View, "Ages", min, intervals, width);
  
  Report.RegisterData(dataset, "dsHistogram");
  MSChart1.DataSource = Report.GetDataSource("dsHistogram");
  
  
  I was thinking that maybe you can advice me with a best way to do it. Maybe I could create a "dummy" dataset in the editor and fill it from a function, ...
  
  By the way, Distribution.CreateHistogram is a function that returns a DataView with the distribution registers.
  
  Thank you
  
• AlexTZ

  April 2010 edited 4:44PM

  It's better to register that datasource before you run the report. In this case you may set up the chart visually, and don't use a script to fill it. Another option is to use chart.BeforePrint event script:
  
  MSChart1.Series[0].ClearValues();
  
  DataView view = Distribution.CreateHistogram((Report.GetDataSource("ds") as ViewDataSource).View, "Ages", min, intervals, width);
  
  // now enumerate the dataview rows and add values to the chart
  ...
  MSChart1.Series[0].AddValue(x, y);