如何在“应收票据余额表”报表中添加字段

参考的教程贴：{{{/article/1756554}}}

现在想在数据源中添加字段【应收票据结算单.票据号】、【应收票据结算单.被背书单位】
参照教程，想先试着添加下票据号字段，服务插件代码如下：
[code] public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
{
string tableNameExt = GetTableName();
base.BuilderReportSqlAndTempTable(filter, tableNameExt);

StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT");
sql.AppendLine("T1.*,T2.FBILLNUMBER AS [FBAHBILLNUMBER]");
sql.AppendFormat("INTO {0}", tableName);
sql.AppendLine("");
sql.AppendFormat("FROM {0} AS T1", tableNameExt);
sql.AppendLine("");
sql.AppendLine("LEFT JOIN T_CN_BILLRECSETTLE AS T2 ON T1.FBILLNO = T2.FBILLNO");
//string strSql = string.Format("select A.*,b.FUnitId into {0} from {1} as A left join T_SAL_ORDERENTRY b on a.fentryid=b.fentryid",tableName, tablenameExt);
DBUtils.Execute(this.Context, sql.ToString());

string dropTable = string.Format("DROP TABLE {0}", tableNameExt);
DBUtils.Execute(this.Context, dropTable);
}//end method[/code]并且也添加了对应的字段，取消标准插件启用新插件，不过没有任何显示，并且添加的字段也被冲掉了。