简单账表调用存储过程来实现，打开账表是空白的，这个是什么原因

临时表的数据

临时表的数字部分为动态列，这部分和代码中的动态列是同样的数据

代码如下

public class Class1 : SysReportBaseService

{

public override void Initialize()

{

base.Initialize();

ReportProperty.IsUIDesignerColumns = false;

ReportProperty.ReportType = ReportType.REPORTTYPE_NORMAL;

IsCreateTempTableByPlugin = true;

ReportProperty.IdentityFieldName = "FIDENTITYID";

}

DynamicObjectCollection dt;

public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)

{

base.BuilderReportSqlAndTempTable(filter, tableName);

DynamicObject dynamicObject = filter.FilterParameter.CustomFilter;

DateTime Date = Convert.ToDateTime(dynamicObject["F_StartDate"]);

DateTime eDate = Convert.ToDateTime(dynamicObject["F_EndDate"]);

List<SqlParam> sqlParams = new List<SqlParam>();

sqlParams.Add(new SqlParam("@FTempTable", KDDbType.AnsiString, tableName));

sqlParams.Add(new SqlParam("@sdate", KDDbType.AnsiString, Date));

sqlParams.Add(new SqlParam("@edate", KDDbType.AnsiString, eDate));

DBUtils.ExecuteStoreProcedure(this.Context, "XRK_QXLX_5", sqlParams);

string sSQL = string.Format(@"/*dialect*/select case when [tian] = 32 then CONVERT(nvarchar, '合计') else CONVERT(nvarchar, [tian]) end as tian from table3");

dt = DBUtils.ExecuteDynamicObject(this.Context, sSQL, null, null, CommandType.Text, null);

string sSQL1 = string.Format(@"/*dialect*/select * into "+ tableName +" from qxmx6");

DBUtils.Execute(this.Context, sSQL1);

}

public override ReportHeader GetReportHeaders(IRptParams filter)

{

base.GetReportHeaders(filter);

DynamicObject dynamicObject = filter.FilterParameter.CustomFilter;

DateTime SDate = Convert.ToDateTime(dynamicObject["F_StartDate"]);

DateTime EDate = Convert.ToDateTime(dynamicObject["F_EndDate"]);

ReportHeader header = new ReportHeader();

//header.AddChild("FIDENTITYID", new LocaleValue("FIDENTITYID"));

header.AddChild("工序说明", new LocaleValue("工序说明"));

header.AddChild("缺陷类型", new LocaleValue("缺陷类型"));

//wl.ColIndex = 0;

for (var i = 0; i < dt.Count; i++)

{

var date = dt[i][0].ToString();

header.AddChild(date, new LocaleValue(date));

}

return header;

}

产品问题简单账表动态显示列，打开账表显示的是空白的

50 产品问题 简单账表动态显示列，打开账表显示的是空白的

恭喜您！

产品问题
简单账表动态显示列，打开账表显示的是空白的

50 产品问题简单账表动态显示列，打开账表显示的是空白的