57.2、报表插件，透视表

57.2、报表插件，透视表原创

金蝶云·星空-BOS平台

林荫大道_找工作

14人赞赏了该文章 6,605次浏览编辑于2020年07月16日 08:18:29

续

57.1

和上一节 55.2 操作类似

1、添加类 TSPOOrderDetailt3

2、引用，使用，继承和上一节一样

3、复制 53.3的代码

4、初始化

        //初始化
        
        public override void Initialize()
        {
            //是否分组汇总
            this.ReportProperty.IsGroupSummary = true;
            
            base.ReportProperty.ReportName = new LocaleValue("透视报表");
            
            base.Initialize();
        }

5、获取组织名称，基础资料名称和上一节一致

7、修改临时表

            base.SettingInfo = new PivotReportSettingInfo();

7.1、标题

SettingField field1 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "FOrgname",
                FieldName = "FOrgname",
                Name = new LocaleValue("组织")
            },0);
            base.SettingInfo.RowTitleFields.Add(field1);
            base.SettingInfo.SelectedFields.Add(field1);

            SettingField field2 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "FSuppName",
                FieldName = "FSuppName",
                Name = new LocaleValue("供应商")
            }, 0);
            field2.SumType = 0;
            base.SettingInfo.AggregateFields.Add(field2);
            base.SettingInfo.SelectedFields.Add(field2);

            SettingField field3 = PivotReportSettingInfo.CreateColumnSettingField(new DecimalField()
             {
                 Key = "FALLAMOUNT",
                 FieldName = "FALLAMOUNT",
                 Name = new LocaleValue("金额")
             }, 0);
            field3.SumType = 1;
            base.SettingInfo.AggregateFields.Add(field3);
            base.SettingInfo.SelectedFields.Add(field3);

            SettingField field4 = PivotReportSettingInfo.CreateColumnSettingField(new DateField()
             {
                 Key = "FDate",
                 FieldName = "FDate",
                 Name = new LocaleValue("订单日期")
             }, 0);
            base.SettingInfo.ColTitleFields.Add(field4);
            base.SettingInfo.SelectedFields.Add(field4);