import clr
clr.AddReference("System")
#clr.AddReference("System.Core")
clr.AddReference("Kingdee.BOS")
clr.AddReference("Kingdee.BOS.App")
clr.AddReference("Kingdee.BOS.Core")
clr.AddReference("Kingdee.BOS.Contracts")
clr.AddReference("Kingdee.BOS.DataEntity")
clr.AddReference("Kingdee.BOS.ServiceHelper")
clr.AddReference('Newtonsoft.Json')
#引入命名空间
from Kingdee.BOS import *
from Kingdee.BOS.App import *
from Kingdee.BOS.App.Data import *
from Kingdee.BOS.Contracts import *
from Kingdee.BOS.Contracts.Report import *
from Kingdee.BOS.Core.Report.PlugIn import *
from Kingdee.BOS.Core.Report import *
from Kingdee.BOS.Core.Report.PivotReport import *
from Kingdee.BOS.Orm.DataEntity import *
from Kingdee.BOS.Util import *
from System import *
from System.ComponentModel import*
from System.Collections.Generic import*
from System.Text import*
from System.Threading.Tasks import*
from Kingdee.BOS.ServiceHelper import *
from Kingdee.BOS.Core.SqlBuilder import*
from Kingdee.BOS.Core.Enums import *
from Kingdee.BOS.Core.Metadata.FieldElement import *
from Kingdee.BOS.Core.Metadata.GroupElement import *
from Newtonsoft.Json import *
from Newtonsoft.Json.Linq import *
from System.Data import *

def Initialize():

    this.ReportProperty.IsGroupSummary=True
    this.ReportProperty.BillKeyFieldName="FIDENTITYID"
    this.ReportProperty.ReportName=LocaleValue("透视表插件演示")

def BuilderReportSqlAndTempTable(filter,tableName):
    localEid=this.Context.UserLocale.LCID#获取当前语言环境代码,中文为2052
    custFilter=filter.FilterParameter.CustomFilter
    if(custFilter==None):
        return
    FDate=str(custFilter["FDate"])[0:10]
    sql=("""/*dialect*/
    SELECT
        TM.FID,TM.Fbillno,TM.FCREATORID,TM.FCREATEDATE,TF.Fallamount,ml.FNAME as Fitemname,TE.FENTRYID as FIDENTITYID
    INTO {0}
    FROM T_PUR_POORDER TM
    INNER JOIN T_PUR_POORDERENTRY_F TF ON TM.FID = TF.FID
    INNER JOIN T_PUR_POORDERENTRY TE ON TM.FID = TE.FID
    inner join T_BD_MATERIAL m on te.FMATERIALID = m.FMATERIALID
    inner join T_BD_MATERIAL_L ml on m.FMATERIALID = ml.FMATERIALID
    WHERE 1=1  and convert(varchar(100),TM.Fdate,23)>='{1}' and tm.FPURCHASEORGID='100054'
    """).format(tableName,str(FDate))
    #raise Exception(sql)
    DBUtils.ExecuteDynamicObject(this.Context,sql)

    reportSouce=DBUtils.ExecuteDataSet(this.Context, String.Format("SELECT * FROM {0}", tableName)).Tables[0]

    #raise NameError(JsonConvert.SerializeObject(reportSouce))

    SettingInfo=PivotReportSettingInfo()

    field=TextField()
    field.Key="Fbillno"
    field.FieldName="Fbillno"
    field.Name=LocaleValue("单据编号",localEid)
    field1 = PivotReportSettingInfo.CreateColumnSettingField(field, 0)
    SettingInfo.RowTitleFields.Add(field1)
    SettingInfo.SelectedFields.Add(field1)

    field=TextField()
    field.Key="Fitemname"
    field.FieldName="Fitemname"
    field.Name=LocaleValue("物料名称",localEid)
    field2  = PivotReportSettingInfo.CreateColumnSettingField(field, 0)
    SettingInfo.ColTitleFields.Add(field2 )
    SettingInfo.SelectedFields.Add(field2 )
    #raise NameError(JsonConvert.SerializeObject(settingMaterial))

    fieldData=DecimalField()
    fieldData.Key="Fallamount"
    fieldData.FieldName="Fallamount"
    fieldData.Name=LocaleValue("金额",localEid)
    field3 = PivotReportSettingInfo.CreateDataSettingField(fieldData, 0, GroupSumType.Sum, "N3")
    SettingInfo.AggregateFields.Add(field3)
    SettingInfo.SelectedFields.Add(field3)
    #raise NameError(JsonConvert.SerializeObject(fieldData))

根据C#例子转换成python，前端无法显示数据；下图为论坛例子效果。请教一下老师们以上代码哪部分没处理到位。

产品问题关于透视表python服务插件无法构造数据问题。

220 产品问题 关于透视表python服务插件无法构造数据问题。

恭喜您！

产品问题
关于透视表python服务插件无法构造数据问题。

220 产品问题关于透视表python服务插件无法构造数据问题。