关于动态增加水晶报表9.0中的字段？

[qiweiyong]

由于在数据库中的字段是随时要增加的，那么我怎么把这些不定数的字段的数据动态的显示在报表的详细资料中？希望能详细点回答，谢谢！

[qiweiyong]

还有，是不是无法实现动态增加水晶报表的列，还是购买水晶报表的某些权限后就可以了（如果可以是用哪个库？）。

[xwdd129]

haibodotnet的专栏----如何在水晶报表中动态添加字段

http://blog.csdn.net/haibodotnet/archive/2003/11/09/21504.aspx

[qiweiyong]

我按照上面所说的做了，为什么还是错的？（int ss= crReportDocument.DataDefinition.FormulaFields.Count;的ss始终为0）
CrystalReport8 crReportDocument;

//ADO.NET Variables
OleDbConnection adoOleDbConnection;
OleDbDataAdapter adoOleDbDataAdapter;
DataSet dataSet;
private System.Windows.Forms.DataGrid dataGrid1;


public Form1()
{
InitializeComponent();
String strUserId = "sa";

String strPassword = "123";

String strServer = "QIWEIYONG";

String strConnection = "Provider=SQLOLEDB.1;Password=" + strPassword;
strConnection += ";Persist Security Info=True;User ID=" + strUserId;
strConnection += ";Initial Catalog=Costumes;Data Source=" + strServer;

adoRs = new ADODB.RecordsetClass();
adoRs.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
adoRs.Open(strSQL, strConnection, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockBatchOptimistic, -1);

crReport = new CrystalReport7();
crReport.SetDataSource (adoRs);

crystalReportViewer1.ReportSource = crReport;*/
string connectionString= "";
connectionString = "Provider=SQLOLEDB;";
connectionString += "Server=QIWEIYONG;Database=pubs;";
connectionString += "User ID=sa;Password=123";

adoOleDbConnection = new OleDbConnection(connectionString);

string sqlString = "";
sqlString = "select * from authors";
adoOleDbDataAdapter = new OleDbDataAdapter(sqlString, adoOleDbConnection);

dataSet = new DataSet();

adoOleDbDataAdapter.Fill(dataSet, "authors");

crReportDocument = new CrystalReport8();
crReportDocument.SetDataSource(dataSet.Tables["authors"]);
int ss= crReportDocument.DataDefinition.FormulaFields.Count; （这个ss为什么始终是0？）

crReportDocument = new CrystalReport8();

[qiweiyong]

请问有么有这类代码啊？

[qiweiyong]

没人知道吗？

[小蕊_claudia]

我也想知道，学习。。。。

[小蕊_claudia]

你需要先把报表加载到crReportDocument里，ss才会有数据。


crReportDocument = new CrystalReport8();
crReportDocument.Load(reportpath);
crReportDocument.SetDataSource(dataSet.Tables["authors"]);