.net 水晶报表自动生存列的问题,大家帮忙看看!!!

Dataset1 ds; //DataSet对象

string sqlText; //根据选择的字段来写的查询语句

ParameterFields parameters; //参数字段集合

ParameterField parameter; //参数字段对象
CrystalReport1 report1; //报表对象

下面是通过一个Button的事件!报表里面我把要传值的参数字段都加到了报表中用的IFildeObject对象但显示报表列的时候我用的是TextObject 对象.

public TextObject GetTextObject(ReportDocument Report,string reportObjectName)

{

TextObject text;

text = Report.ReportDefinition.ReportObjects[reportObjectName] as TextObject;

if(text != null)

return text;

else

return null;

}

这里是给TextObject 传值;

string field = "";

parameters = new ParameterFields();

string[] FieldString;

if(this.checkBox1.Checked)

field = this.checkBox1.Text;

if(this.checkBox2.Checked)

field += "," + this.checkBox2.Text;

if(this.checkBox3.Checked)

field += "," + this.checkBox3.Text;

if(this.checkBox4.Checked)

field += "," + this.checkBox4.Text;

if(this.checkBox5.Checked)

field +="," + this.checkBox5.Text;

if(field == "")

{

MessageBox.Show("选择字段");

return;

}

if(field.Substring(0,1) == ",")

field = field.Substring(1,field.Length -1);

FieldString = field.Split(',');

sqlText = "Select "+ field.ToString()+ " from Power.busy"; //根据条件自动生产查询语句

dbConnection = new OracleConnection(constring);

dbAdapter = new OracleDataAdapter(sqlText,dbConnection);

ds = new Dataset1();

try

{

dbAdapter.Fill(ds.Tables["Busy"]);

}

catch(Exception ex)

{

Debug.Fail(ex.Message);

}

这里我做测试用了CheckBox 来选择字段,填充DataSet

report = new CrystalReport1();

for(int i=0;i<FieldString.Length;i++)

{

report = new CrystalReport1();

report.DataDefinition.FormulaFields["myField"+(i+1)].Text = "{BUSY."+FieldString[i]+"}";

string StringText = "";

StringText = FieldString[i].ToString();

TextObject textObject;

string textObjects = "Text"+i.ToString();

if(FieldString[i] == "ID")