Hello, I am trying to populate a combination chart with the DataSet below. I don’t seem to be able to get the syntax correct within the MS Word chart object. Any help is much appreciated.
WORD DOCUMENT
Chart Title:
Title <<foreach [row in ds]>><<x [Series_1]>>
Series Syntax:
Series 2 <<y [Series_2]>>
Series 3 <<y [Series_3]>>
JAVA CODE
// Create an Aspose reporting engine
ReportingEngine engine = new ReportingEngine();
engine.buildReport(doc, loadProfileDs());
private DataSet loadProfileDs(){
DataSet ds = new DataSet(); // later versions allow a dataset name.
DataTable dtProfile = new DataTable("dt");
dtProfile.getColumns().add("Series_1");
dtProfile.getColumns().add("Series_2");
dtProfile.getColumns().add("Series_3");
ds.getTables().add(dtProfile);
for(int i=0; i != 10; i ++){
DataRow row = dtProfile.newRow();
row.set("Series_1", 50 + i*25);
row.set("Series_1", 0.25 + i*0.1);
row.set("Series_1", 0.25 + i*0.1);
dtProfile.getRows().add(row);
}
return ds;
}