代码：

[HotUpdate]
    [Description("透视表")]
    public class TSBReportServerSoucer : SysReportBaseService
    {
        int dwnumber = 1;//单位，默认元为单位
        //初始化
        public override void Initialize()
        {
            //是否分组汇总
            this.ReportProperty.IsGroupSummary = true;
            base.ReportProperty.ReportName = new LocaleValue("透视报表");
            base.Initialize();

        }
        //组织名称
        private string GetMultiOrgnNameValues(string orgIdStrings)
        {
            List<string> list = new List<string>();
            string result = string.Empty;
            if (orgIdStrings.Trim().Length > 0)
            {
                IQueryService service = Kingdee.BOS.Contracts.ServiceFactory.GetService<IQueryService>(base.Context);
                QueryBuilderParemeter para = new QueryBuilderParemeter
                {
                    FormId = "ORG_Organizations",
                    SelectItems = SelectorItemInfo.CreateItems("FNAME"),
                    FilterClauseWihtKey = string.Format(" FORGID IN ({0}) AND FLOCALEID={1}", orgIdStrings, base.Context.UserLocale.LCID)
                };
                DynamicObjectCollection dynamicObjectCollection = service.GetDynamicObjectCollection(base.Context, para, null);
                foreach (DynamicObject current in dynamicObjectCollection)
                {
                    list.Add(current["FNAME"].ToString());
                }
                if (list.Count > 0)
                {
                    result = string.Join(",", list.ToArray());
                }
            }
            return result;
        }
        //基础资料名称
        private string GetBaseDataNameValue(DynamicObjectCollection dyobj)
        {
            string name = "";
            foreach (DynamicObject dynbj in dyobj)
            {
                if (dynbj != null || !dynbj.DynamicObjectType.Properties.Contains("Name"))
                {
                    DynamicObject dynbj2 = (DynamicObject)dynbj[2];
                    name = name + ",'" + dynbj2["Name"].ToString() + "'";
                }
            }
            if (name.Length > 0)
            {
                name = name.Substring(1, name.Length - 1);
            }
            return name;
        }

        //创建临时报表
        public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
        {

string Filter = GetFilterWhere(filter);

string seqFld = string.Format(base.KSQL_SEQ, OrderColumn(filter));

base.SettingInfo = new PivotReportSettingInfo();

            // 取数SQL
            // FID, FEntryId, 编号、状态、物料、数量、单位、单位精度、单价、价税合计 ,t1M_L.FNAME as FMaterialName
            string sql = string.Format(@"/*dialect*/
                                select
                                FID,
                                FEntryID,
                                F_BDI_BORROWER,
                                F_BDI_FUNDBANK,
                                F_BDI_LoanType,
                                F_BDI_CONTRACTNUMBER,
                                F_BDI_WARRANTPACT,
                                F_BDI_REPAYYEAR,
                                F_BDI_LOANBEGINDATE,
                                F_BDI_LOANENDDATE,
                                F_BDI_MONEYRATE,
                                F_BDI_CREDITAMOUNT,
                                F_BDI_REPAYMENTDATE,
                                F_BDI_REPAYMENTDATEmm,
                                F_BDI_CORPUS,
                                F_BDI_RETADECI,
                            {0} into {1} from
                            (
                                select
                                t1.FID,
                                t2.FEntryID,
                                org_L.FNAME as F_BDI_BORROWER,
                                bk_L.FNAME as F_BDI_FUNDBANK,
                                t3.F_BDI_LoanType,
                                t1.F_BDI_CONTRACTNUMBER,
                                t3.F_BDI_WARRANTPACT,
                                t1.F_BDI_REPAYYEAR,
                                LEFT(CONVERT(VARCHAR,t1.F_BDI_LOANBEGINDATE,23),10) as F_BDI_LOANBEGINDATE,
                                LEFT(CONVERT(VARCHAR,t1.F_BDI_LOANENDDATE,23),10) as F_BDI_LOANENDDATE,
                                t1.F_BDI_MONEYRATE,
                                t1.F_BDI_CREDITAMOUNT/{2} as F_BDI_CREDITAMOUNT,
                                LEFT(CONVERT(VARCHAR,t2.F_BDI_REPAYMENTDATE,23),10) as F_BDI_REPAYMENTDATE,
                                LEFT(CONVERT(VARCHAR,t2.F_BDI_REPAYMENTDATE,23),7) as F_BDI_REPAYMENTDATEmm,
                                t2.F_BDI_CORPUS/{2} as F_BDI_CORPUS,
                                t2.F_BDI_RETADECI/{2} as F_BDI_RETADECI
                                from BDI_t_Repayment t1 inner join BDI_t_RepaymentEntry t2 on t1.FID=t2.FID
                                inner join BDI_t_ZLcontracts t3 on t1.F_BDI_SOURCEBILLNO=t3.FBILLNO
                                inner join T_ORG_Organizations org on t1.F_BDI_BORROWER=org.FORGID
                                inner join T_ORG_ORGANIZATIONS_L org_L on org.FORGID=org_L.FORGID
                                inner join T_BD_BANK bk on t1.F_BDI_FUNDBANK=bk.FBANKID
                                inner join T_BD_BANK_L bk_L on bk.FBANKID=bk_L.FBANKID
                            ) t1 {3}
                            ",
                        seqFld,
                        tableName,
                        dwnumber,
                        Filter
                        );
            DBUtils.ExecuteDynamicObject(this.Context, sql);
            //借款主体
            SettingField field1 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "F_BDI_BORROWER",
                FieldName = "F_BDI_BORROWER",
                Name = new LocaleValue("借款主体")
            }, 0);
            field1.IsShowTotal = false;
            base.SettingInfo.RowTitleFields.Add(field1);
            base.SettingInfo.SelectedFields.Add(field1);
            //贷款时间

            //融资机构
            SettingField field2 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "F_BDI_FUNDBANK",
                FieldName = "F_BDI_FUNDBANK",
                Name = new LocaleValue("融资机构")
            }, 0);
            //field2.SumType = 0;
            field2.IsShowTotal = false;
            base.SettingInfo.RowTitleFields.Add(field2);
            base.SettingInfo.SelectedFields.Add(field2);
            //贷款类型
            //SettingField daikuanType = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            //{
            //    Key = "F_BDI_LoanType",
            //    FieldName = "F_BDI_LoanType",
            //    Name = new LocaleValue("贷款类型")
            //}, 0);
            //daikuanType.IsShowTotal = false;
            //base.SettingInfo.RowTitleFields.Add(daikuanType);
            //base.SettingInfo.SelectedFields.Add(daikuanType);
            //合同编号
            SettingField field3 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "F_BDI_CONTRACTNUMBER",
                FieldName = "F_BDI_CONTRACTNUMBER",
                Name = new LocaleValue("合同编号")
            }, 0);
            //field3.SumType = 3;
            field3.IsShowTotal = false;
            base.SettingInfo.RowTitleFields.Add(field3);
            base.SettingInfo.SelectedFields.Add(field3);

            //担保合同编号

            SettingField field4 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "F_BDI_WARRANTPACT",
                FieldName = "F_BDI_WARRANTPACT",
                Name = new LocaleValue("担保合同编号")
            }, 0);
            field4.IsShowTotal = false;
            base.SettingInfo.RowTitleFields.Add(field4);
            base.SettingInfo.SelectedFields.Add(field4);
            //贷款年限
            SettingField field5 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "F_BDI_REPAYYEAR",
                FieldName = "F_BDI_REPAYYEAR",
                Name = new LocaleValue("贷款年限（月）")
            }, 0);
            field5.IsShowTotal = false;
            base.SettingInfo.RowTitleFields.Add(field5);
            base.SettingInfo.SelectedFields.Add(field5);
            //贷款起始日期
            SettingField field6 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "F_BDI_LOANBEGINDATE",
                FieldName = "F_BDI_LOANBEGINDATE",
                Name = new LocaleValue("贷款起始日期")
            }, 0);
            field6.IsShowTotal = false;
            base.SettingInfo.RowTitleFields.Add(field6);
            base.SettingInfo.SelectedFields.Add(field6);
            //贷款截止日期
            SettingField field7 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "F_BDI_LOANENDDATE",
                FieldName = "F_BDI_LOANENDDATE",
                Name = new LocaleValue("贷款截止日期")
            }, 0);
            field7.IsShowTotal = false;
            base.SettingInfo.RowTitleFields.Add(field7);
            base.SettingInfo.SelectedFields.Add(field7);
            //利率
            SettingField field8 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "F_BDI_MONEYRATE",
                FieldName = "F_BDI_MONEYRATE",
                Name = new LocaleValue("利率")
            }, 0);
            field8.IsShowTotal = false;
            base.SettingInfo.RowTitleFields.Add(field8);
            base.SettingInfo.SelectedFields.Add(field8);
            //合同金额
            SettingField field9 = PivotReportSettingInfo.CreateColumnSettingField(new TextField()
            {
                Key = "F_BDI_CREDITAMOUNT",
                FieldName = "F_BDI_CREDITAMOUNT",
                Name = new LocaleValue("合同金额")
            }, 0);
            field9.IsShowTotal = false;
            base.SettingInfo.RowTitleFields.Add(field9);
            base.SettingInfo.SelectedFields.Add(field9);
            //本金
            SettingField field10 = PivotReportSettingInfo.CreateColumnSettingField(new DecimalField()
            {
                Key = "F_BDI_CORPUS",
                FieldName = "F_BDI_CORPUS",
                Name = new LocaleValue("本金")
            }, 0);
            field10.SumType = 1;
            field10.IsShowTotal = false;
            base.SettingInfo.AggregateFields.Add(field10);
            base.SettingInfo.SelectedFields.Add(field10);
            //利息
            SettingField field11 = PivotReportSettingInfo.CreateColumnSettingField(new DecimalField()
            {
                Key = "F_BDI_RETADECI",
                FieldName = "F_BDI_RETADECI",
                Name = new LocaleValue("利息")
            }, 0);
            field11.SumType = 1;
            field11.IsShowTotal = false;
            base.SettingInfo.AggregateFields.Add(field11);
            base.SettingInfo.SelectedFields.Add(field11);
            //还款日期
            SettingField field12 = PivotReportSettingInfo.CreateColumnSettingField(new DateField()
            {
                Key = "F_BDI_REPAYMENTDATE",
                FieldName = "F_BDI_REPAYMENTDATE",
                Name = new LocaleValue("还款日期")
            }, 0);
            field12.SumType =0;
            field12.IsShowTotal = false;

            base.SettingInfo.AggregateFields.Add(field12);
            base.SettingInfo.SelectedFields.Add(field12);
            base.SettingInfo.AllowExpand = false;

            //还款日期月份
            SettingField field13 = PivotReportSettingInfo.CreateColumnSettingField(new DateField()
            {
                Key = "F_BDI_REPAYMENTDATEmm",
                FieldName = "F_BDI_REPAYMENTDATEmm",
                Name = new LocaleValue("还款月份")
            }, 0);
            field13.IsShowTotal = false;
            base.SettingInfo.ColTitleFields.Add(field13);
            base.SettingInfo.SelectedFields.Add(field13);
        }

        ////获取过滤条件
        private string GetFilterWhere(IRptParams filter)
        {

            DynamicObject customFilter = filter.FilterParameter.CustomFilter;
            StringBuilder strwhere = new StringBuilder();
            strwhere.AppendLine("Where 1=1 ");

            //根据借款主体过滤
            string JieKuanzuzhi = this.GetBaseDataNameValue(customFilter["F_BDI_JieKuanzuzhi"] as DynamicObjectCollection);
            string JieK = string.IsNullOrWhiteSpace(JieKuanzuzhi)
                ? " " : string.Format(" AND F_BDI_BORROWER IN ({0}) ", JieKuanzuzhi);
            strwhere.AppendLine(JieK);
            //根据贷款类型过滤
            string daikuantype = (customFilter["F_BDI_daikuanType"] == null || customFilter["F_BDI_daikuanType"].ToString()=="") ? string.Empty : customFilter["F_BDI_daikuanType"].ToString();
            strwhere.AppendLine(string.Format(" AND F_BDI_LoanType like '%{0}%'", daikuantype));
            //日期
            string startValue = (customFilter["FOrderStartDate"] == null) ? string.Empty : Convert.ToDateTime(customFilter["FOrderStartDate"]).ToString("yyyy-MM-dd");
            string endValue = (customFilter["FOrderEndDate"] == null) ? string.Empty : Convert.ToDateTime(customFilter["FOrderEndDate"]).ToString("yyyy-MM-dd");
            strwhere.AppendLine(string.Format(" AND F_BDI_REPAYMENTDATE>='{0}' and F_BDI_REPAYMENTDATE<='{1}' ", startValue, endValue));

            //物料
            //string baseDataNameValue = this.GetBaseDataNameValue(customFilter["F_PAEZ_WLID"] as DynamicObjectCollection);
            //string MaterailName = string.IsNullOrWhiteSpace(baseDataNameValue)
            //    ? " " : string.Format(" AND FMaterialName IN ({0}) ", baseDataNameValue);
            //strwhere.AppendLine(MaterailName);

            //单据编号
            //string BillNo = (Convert.ToString(customFilter["F_PoOrderBillNo"]) == "") ? " " : " AND FBILLNO='" + customFilter["F_PoOrderBillNo"].ToString() + "' ";
            //strwhere.AppendLine(BillNo);

            //根据融资机构（银行）过滤
            string baseSuppName = this.GetBaseDataNameValue(customFilter["F_BDI_RongZiJG"] as DynamicObjectCollection);
            string SuppName = string.IsNullOrWhiteSpace(baseSuppName)
             ? " " : string.Format(" AND F_BDI_FUNDBANK IN ({0}) ", baseSuppName);
             strwhere.AppendLine(SuppName);

            string text2 = string.IsNullOrWhiteSpace(filter.FilterParameter.FilterString) ? " " : " AND " + filter.FilterParameter.FilterString.Replace("{ts", "").Replace("}", "");
            strwhere.AppendLine(text2);
            //获取过滤框的人民币单位
            string danwei = customFilter["F_BDI_danwei"].ToString();
            if (danwei == "万元")
            {
                dwnumber = 1000;
            }
            if (danwei=="元")
            {
                dwnumber = 1;
            }
            return strwhere.ToString();
        }

        /// 设置汇总列信息
        public override List<SummaryField> GetSummaryColumnInfo(IRptParams filter)
        {
            var result = base.GetSummaryColumnInfo(filter);
            result.Add(new SummaryField("F_BDI_CORPUS", Kingdee.BOS.Core.Enums.BOSEnums.Enu_SummaryType.SUM));//本金
            result.Add(new SummaryField("F_BDI_RETADECI", Kingdee.BOS.Core.Enums.BOSEnums.Enu_SummaryType.SUM));//利率
            return result;
        }

        ///排序语句
        private string OrderColumn(IRptParams filter)
        {
            string OrderBy = "";
            string datasort = Convert.ToString(filter.FilterParameter.SortString);//排序
            if (datasort != "")
            {
                OrderBy = " " + datasort + " ";
            }
            else
            {
                OrderBy = " FID ";
            }
            return OrderBy;
        }

        ///报表头赋值
        //public override ReportTitles GetReportTitles(IRptParams filter)
        //{
        //    ReportTitles reportTitles = base.GetReportTitles(filter);
        //    //var aFilter = filter.FilterParameter.CustomFilter; // 过滤界面 - 快捷
        //    DynamicObject customFilter = filter.FilterParameter.CustomFilter;

// // reportTitles.AddTitle("FBeginDate", "2019-02-69");
// this.ReportTitles.AddTitle("F_BDI_StartDate", DateTime.Parse(customFilter["FOrderStartDate"].ToString()).ToString("yyyy-MM-dd"));

        //    return reportTitles;
        //}
        ///报表头赋值
        public override ReportTitles GetReportTitles(IRptParams filter)
        {
            var result = base.GetReportTitles(filter);
            DynamicObject dyFilter = filter.FilterParameter.CustomFilter;
            if (dyFilter != null)
            {
                if(result==null)
                {
                    result = new ReportTitles();
                }
                //设置报表title
                result.AddTitle("F_BDI_StartDate", Convert.ToString(dyFilter["FOrderStartDate"]));
                result.AddTitle("F_BDI_EndDate", Convert.ToString(dyFilter["FOrderEndDate"]));
                result.AddTitle("F_BDI_JieKuanZZ", this.GetBaseDataNameValue(dyFilter["F_BDI_JieKuanzuzhi"] as DynamicObjectCollection));
                result.AddTitle("F_BDI_RZBank", this.GetBaseDataNameValue(dyFilter["F_BDI_RongZiJG"] as DynamicObjectCollection));
                result.AddTitle("F_BDI_chinaDW", Convert.ToString(dyFilter["F_BDI_danwei"]));
            }
            return result;
        }

}

产品问题透视表如何取消指定列字段总计？

产品问题 透视表如何取消指定列字段总计？

恭喜您！

产品问题
透视表如何取消指定列字段总计？

产品问题透视表如何取消指定列字段总计？