Using StiCalcDataColumn to add Calculated columns to report.

[mace242]

I am trying to add a StiCalcDataColumn programatically to my report. It is going wrong as when I try to save the report I get an null assignment error. The code I am using to add the column is as follows:

StiCalcDataColumn Col = new StiCalcDataColumn(fn, fn, dtype, "\"Hello\"");
Report.Dictionary.DataSources["MainData"].Columns.Add(Col);

Anybody know where I may be going wrong or have an example of using StiCalcDataColumn?

Thanks

Tim

[Brendan]

Code: Select all

StiReport report = new StiReport();

//Load Existing Report
report.Load("c:\\boc\\CalcColumn.mrt");

//Reg Some Test Data
DataTable tbl = new DataTable("MainData");
tbl.Columns.Add("ID", typeof(int));
tbl.Columns.Add("FirstName", typeof(string));
tbl.Columns.Add("Surname", typeof(string));
tbl.Rows.Add( new object[]{1, "Brad", "Smith"} );

report.RegData("MainData", tbl);

//Add a Calculated Column to create a Full Name
StiCalcDataColumn calcColumn = 
	new StiCalcDataColumn(	"FullName", 
							"FullName", 
							typeof(string), 
							"MainData.FirstName + \" \" + MainData.Surname");

report.DataSources["MainData"].Columns.Add(calcColumn);

report.Design();