在c#中动态生成水晶报表时，动态添加sort

最新推荐文章于 2022-08-08 12:25:50 发布

yudehui

最新推荐文章于 2022-08-08 12:25:50 发布

阅读量1.3k

点赞数

分类专栏： C# 文章标签：报表 c# string float date

本文链接：https://blog.youkuaiyun.com/yudehui/article/details/6289252

版权

C# 专栏收录该内容

45 篇文章

订阅专栏

本文介绍了如何在Crystal Reports中动态添加公式字段并将其用于排序的方法。特别关注了使公式字段具备排序能力所需的关键属性设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

private void SetSortQuick(ReportClientDocument objRPT)
    {
       if ( ! String.IsNullOrEmpty( this .SortField))
      {
        cCreateReport objCreateReport = new cCreateReport();
         string [] arrySortField = this .SortField.Split( new char [] { ' , ' });
         string [] arrySortDirection = this .SortDirection.Split( new char [] { ' , ' });
         for ( int i = 0 ; i < arrySortField.Length; i ++ )
        {
           string [] arryTemp = arrySortField[i].Split( new char [] { ' | ' });
           string strFieldName = arryTemp[ 0 ];
           string strFieldType = arryTemp[ 1 ].ToLower();

           string strFormula = "" , strFormulaName = "" ;
           switch (strFieldType)
          {
             case " datetime " :
              strFormula = " date({ " + arrySortField[i] + " }) " ;
               break ;
             case " numeric " :
             case " int " :
             case " money " :
             case " float " :
              strFormula = " ToNumber({ " + arrySortField[i] + " }) " ;
               break ;
             default :
              strFormula = " { " + arrySortField[i] + " } " ;
               break ;
          }
          strFormulaName = " Order " + i.ToString();

          objRPT.DataDefController.FormulaFieldController.AddByName(strFormulaName, strFormula, CrFormulaSyntaxEnum.crFormulaSyntaxCrystal);
          ISCRField objS = objRPT.DataDefController.FindFieldByFormulaForm( " {@ " + strFormulaName + " } " );

           if (objRPT.DataDefController.SortController.CanSortOn(objS))
          {
            SortClass objSort = new SortClass();
            objSort.SortField = objS;
             int countOfSort = objRPT.DataDefinition.Sorts.Count;
             if (arrySortDirection[i] == " 1 " )
            {
              objSort.Direction = CrSortDirectionEnum.crSortDirectionDescendingOrder;
            }
             else
            {
              objSort.Direction = CrSortDirectionEnum.crSortDirectionAscendingOrder;
            }
            objRPT.DataDefController.SortController.Add(countOfSort, objSort);
          }
        }
      }
    }

必须使用这种方式才可以动态添加公式为排序字段

objRPT.DataDefController.FormulaFieldController.AddByName(strFormulaName, strFormula, CrFormulaSyntaxEnum.crFormulaSyntaxCrystal);
ISCRField objS = objRPT.DataDefController.FindFieldByFormulaForm("{@"+strFormulaName+"}");

我试图使用如下方式动态添加公式字段，但是用CanSortOn检测总是不能作为sort字段。

代码

public void AddFormula(ReportClientDocument oReportClientDocument,
                 string szName,
                 string szFormula,
                CrFieldValueTypeEnum crFieldValueType
                )
    {
      FormulaField oFormulaField;

      oFormulaField = new FormulaField();

      oFormulaField.Name = szName;
      oFormulaField.Text = szFormula;
      oFormulaField.Syntax = CrFormulaSyntaxEnum.crFormulaSyntaxCrystal;
      oFormulaField.Type = crFieldValueType;

      oReportClientDocument.DataDefController.FormulaFieldController.Add(oFormulaField);
    }

代码

     public FormulaField FindFormulaField(ReportClientDocument oReportClientDocument, string szFormula)
    {
      FormulaField oFormulaField;
      Fields oFields;
       int iIndex;
      oFormulaField = new FormulaFieldClass();

      oFields = oReportClientDocument.DataDefinition.FormulaFields;
      iIndex = oFields.Find(szFormula, CrFieldDisplayNameTypeEnum.crFieldDisplayNameName, CeLocale.ceLocaleUserDefault);
      oFormulaField = ((FormulaField)oFields[iIndex]);

       return oFormulaField;
    }

后来我发现找到的公式字段的IsRecurring属性是false.只有这个属性为true时才可以作为sort的字段。