Group header aggregates and footers aggregates

[Phil]

I have a RadGrid where I am grouping by expression and I'm aggregating some values in the group header.  The aggregates in the group header work fine and total all the values in the group as expected until I set the Aggregate property of the GridBoundColumn field to Sum of the field I'm trying to aggregate in the group header.  instead of having a total of the group in the group header for that field, just the last value of the group is being placed in the group header.  I need to have group totals in the group header and then overall totals in the grid footer.  Is there a way to do this? 

[Phil]

Nevermind.  I figured it out.  I just had to use aliases that were different from the fields in my GridBoundColumn in my GridGroupByExpression and the GridGroupByFields.

[Le]

Hello,
I got the issue like that.How to set the value of Group Header into the value of Group Footer when I add groupby expression.
I use GridBoundColumn to show the value of Group Footer, but the result is wrong when I add two or three 'group by' expression.
I need the value of grid footer is the same with Group Header.
Plz help me, Thanks!!!

Best regards,
Le

[Le]

Plz, help me!!!
Best regards,
Le

[Rosen]

Hello Le,

Can you please download latest internal build and see if it helps?

Sincerely yours,
Rosen
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Le]

Hi,
I get the lasted version 2009.1 402 and It's the snippet code to show Group Footer in RadGrid

        

GridBoundColumn colCount = (GridBoundColumn)RadGrid1.MasterTableView.Columns.FindByDataField("COLUMNNAME");

 

 

colCount.Aggregate = GridAggregateFunction.Count;

 

 

colCount.FooterAggregateFormatString =

"Count " + r.CAPTION + ":{0}";

 

But the value of Group Header and Group Footer are not the same (RadGrid added two or more groupby expression)

Any help!!

 

Thanks,
Le

 

[Le]

Plz help me,
I got the lastest internal Build 2009-1-519, and I test this version with small project which run right. In my scenario,the value of Group Footer went wrong, when i added 2 or 3 groupby expression.I don't know why, plz help me check!!!
And this is my snippet code:

private void CreateColumnAndBindData(DataTable dt, DataTable dtColumn)
    {
        #region Create Columns
        foreach (DataColumn col in dt.Columns)
        {
            DataRow[]  dr = dtColumn.Select("COLUMNNAME = '" + col.ColumnName + "'");
            if (dr.Length > 0)
            {
                ds.TBL_COLUMNRow r = dr[0] as ds.TBL_COLUMNRow;

                switch (r.DATATYPE)
                {
                    case "NUMBER":

                        GridBoundColumn grdColumn = new GridBoundColumn();
                        grdColumn.DataField = r.COLUMNNAME;
                        grdColumn.HeaderText = r.CAPTION;
                        grdColumn.UniqueName = r.COLUMNNAME;
                        grdColumn.SortExpression = r.COLUMNNAME;
                        grdColumn.DataType = Type.GetType("System.Decimal");
                        grdReport.MasterTableView.Columns.Add(grdColumn);
                        break;
                    case "NVARCHAR2":
                        GridBoundColumn grdColumn1 = new GridBoundColumn();
                        grdColumn1.DataField = r.COLUMNNAME;
                        grdColumn1.HeaderText = r.CAPTION;
                        grdColumn1.UniqueName = r.COLUMNNAME;
                        grdColumn1.SortExpression = r.COLUMNNAME;
                        grdColumn1.DataType = Type.GetType("System.String");
                        grdReport.MasterTableView.Columns.Add(grdColumn1);
                        break;
                    case "VARCHAR2":
                        GridBoundColumn grdColumn2 = new GridBoundColumn();
                        grdColumn2.DataField = r.COLUMNNAME;
                        grdColumn2.HeaderText = r.CAPTION;
                        grdColumn2.UniqueName = r.COLUMNNAME;
                        grdColumn2.SortExpression = r.COLUMNNAME;
                        grdColumn2.DataType = Type.GetType("System.String");
                        grdReport.MasterTableView.Columns.Add(grdColumn2);
                        break;
                    case "DATE":
                        GridBoundColumn grdDateColumn = new GridBoundColumn();
                        grdDateColumn.DataField = r.COLUMNNAME;
                        grdDateColumn.HeaderText = r.CAPTION;
                        grdDateColumn.UniqueName = r.COLUMNNAME;
                        grdDateColumn.SortExpression = r.COLUMNNAME;
                        grdDateColumn.DataFormatString = "{0:M/d/yyyy}";
                        grdDateColumn.DataType = Type.GetType("System.DateTime");
                        grdReport.MasterTableView.Columns.Add(grdDateColumn);
                        break;
                    case "TIMESTAMP(6) WITH LOCAL TIME ZONE":
                        GridBoundColumn grdDateColumn1 = new GridBoundColumn();
                        grdDateColumn1.DataField = r.COLUMNNAME;
                        grdDateColumn1.HeaderText = r.CAPTION;
                        grdDateColumn1.UniqueName = r.COLUMNNAME;
                        grdDateColumn1.SortExpression = r.COLUMNNAME;
                        grdDateColumn1.DataFormatString = "{0:M/d/yyyy}";
                        grdDateColumn1.DataType = Type.GetType("System.DateTime");
                        grdReport.MasterTableView.Columns.Add(grdDateColumn1);
                        break;
                    default:
                        GridBoundColumn grdColumn3 = new GridBoundColumn();
                        grdColumn3.DataField = r.COLUMNNAME;
                        grdColumn3.HeaderText = r.CAPTION;
                        grdColumn3.UniqueName = r.COLUMNNAME;
                        grdColumn3.SortExpression = r.COLUMNNAME;
                        grdColumn3.DataType = Type.GetType("System.Decimal");
                        grdReport.MasterTableView.Columns.Add(grdColumn3);
                        break;
                }

            }
        }
        #endregion

        #region Create Expression

        int iIndex = 0;
        try
        {
            foreach (dsReportInfor.TBL_COLUMNTOGROUPBYRow rGroupBy in ReportInfor.TBL_COLUMNTOGROUPBY)
            {
                DataRow[] dr = dtColumn.Select("COLUMNID = '" + rGroupBy.COLUMNID + "'");
                if (dr.Length > 0)
                {
                    GridGroupByExpression ex = new GridGroupByExpression();
                    ds.TBL_COLUMNRow r = dr[0] as ds.TBL_COLUMNRow;
                    GridGroupByField f = new GridGroupByField();
                    f.FieldName = r.COLUMNNAME;
                    f.HeaderText = r.CAPTION;
                    ex.GroupByFields.Add(f);
                    ex.SelectFields.Add(f);
                    grdReport.MasterTableView.GroupByExpressions.Add(ex);

                    iIndex++;
                }
            }


        }
        catch (Exception ex)
        {
            ShowValidate(string.Format("<strong>Cannot add group by expression: {0}</strong><br>", ex.Message));
        }
        if (iIndex > 0)
        {
            grdReport.ShowGroupPanel = true;
            //grdReport.MasterTableView.AllowPaging = false;
        }

        int n = 0;
        foreach (dsReportInfor.TBL_COLUMNTOTOTALRow rColumn2Total in ReportInfor.TBL_COLUMNTOTOTAL)
        {
            DataRow[] dr = dtColumn.Select("COLUMNID = '" + rColumn2Total.COLUMNID + "'");
            if (dr.Length > 0 && ReportInfor.TBL_COLUMNTOGROUPBY.Select("COLUMNID = '" + rColumn2Total.COLUMNID + "'").Length == 0)
            {
                ds.TBL_COLUMNRow r = dr[0] as ds.TBL_COLUMNRow;
                for (int i = 0; i < iIndex; i++)
                {
                    if (Convert.ToBoolean(rColumn2Total.GETMIN))
                    {
                        GridGroupByField f = new GridGroupByField();
                        f.HeaderText = r.CAPTION;
                        f.FieldName = r.COLUMNNAME;
                        f.FieldAlias = "F" + n++;
                        f.HeaderText = "Min " + r.CAPTION;
                        f.Aggregate = GridAggregateFunction.Min;
                        grdReport.MasterTableView.GroupByExpressions[i].SelectFields.Add(f);

                        //Customize FooterGroup
                        GridBoundColumn colMin = (GridBoundColumn)grdReport.MasterTableView.Columns.FindByUniqueName(r.COLUMNNAME);
                        colMin.Aggregate = GridAggregateFunction.Min;
                        //colMin.FooterText = "Min " + r.CAPTION + " : ";
                        if (r.DATATYPE.Equals("DATE") || r.DATATYPE.Equals("TIMESTAMP(6) WITH LOCAL TIME ZONE"))
                        {
                            colMin.FooterAggregateFormatString = "Min " + r.CAPTION + ":{0:M/d/yyyy}";
                            //f.FormatString = "{0:M/d/yyyy}";
                        }
                        else
                            colMin.FooterAggregateFormatString = "Min " + r.CAPTION + ":{0:c}";

                    }
                    if (Convert.ToBoolean(rColumn2Total.GETMAX))
                    {
                        GridGroupByField f = new GridGroupByField();
                        f.HeaderText = r.CAPTION;
                        f.FieldName = r.COLUMNNAME;
                        f.FieldAlias = "F" + n++;
                        f.HeaderText = "Max " + r.CAPTION;
                        f.Aggregate = GridAggregateFunction.Max;
                        grdReport.MasterTableView.GroupByExpressions[i].SelectFields.Add(f);

                        //Customize FooterGroup
                        GridBoundColumn colMax = (GridBoundColumn)grdReport.MasterTableView.Columns.FindByUniqueName(r.COLUMNNAME);
                        colMax.Aggregate = GridAggregateFunction.Max;
                        //colMax.FooterText = "Max " + r.CAPTION + " : ";

                        if (r.DATATYPE.Equals("DATE") || r.DATATYPE.Equals("TIMESTAMP(6) WITH LOCAL TIME ZONE"))
                        {
                            colMax.FooterAggregateFormatString = "Max " + r.CAPTION + ":{0:M/d/yyyy}";
                            //f.FormatString = "{0:M/d/yyyy}";
                        }
                        else
                            colMax.FooterAggregateFormatString = "Max " + r.CAPTION + ":{0}";

                    }
                    if (Convert.ToBoolean(rColumn2Total.GETAVG) && !r.DATATYPE.Equals("DATE") && !r.DATATYPE.Equals("TIMESTAMP(6) WITH LOCAL TIME ZONE"))
                    {
                        GridGroupByField f = new GridGroupByField();
                        f.HeaderText = r.CAPTION;
                        f.FieldName = r.COLUMNNAME;
                        f.FieldAlias = "F" + n++;
                        //f.HeaderText = "Avg " + r.CAPTION;
                        f.Aggregate = GridAggregateFunction.Avg;
                        f.FormatString = "Avg:{0:0.00}";
                        grdReport.MasterTableView.GroupByExpressions[i].SelectFields.Add(f);
                        //expression.SelectFields.Add(f);

                        //Customize FooterGroup
                        GridBoundColumn colAvg = (GridBoundColumn)grdReport.MasterTableView.Columns.FindByUniqueName(r.COLUMNNAME);
                        colAvg.Aggregate = GridAggregateFunction.Avg;
                        colAvg.FooterAggregateFormatString = "Avg " + r.CAPTION + ":{0:0.00}";

                    }
                    if (Convert.ToBoolean(rColumn2Total.GETSUM) && !r.DATATYPE.Equals("DATE") && !r.DATATYPE.Equals("TIMESTAMP(6) WITH LOCAL TIME ZONE"))
                    {
                        GridGroupByField f = new GridGroupByField();
                        f.HeaderText = r.CAPTION;
                        f.FieldName = r.COLUMNNAME;
                        f.FieldAlias = "F" + n++;
                        f.HeaderText = "Sum " + r.CAPTION;
                        //f.FormatString = "Sum:{0:C2}";
                        f.Aggregate = GridAggregateFunction.Sum;
                        grdReport.MasterTableView.GroupByExpressions[i].SelectFields.Add(f);

                        //Customize FooterGroup
                        GridBoundColumn colSum = (GridBoundColumn)grdReport.MasterTableView.Columns.FindByUniqueName(r.COLUMNNAME);

                        //colSum.FooterAggregateFormatString = "Sum:{0}";
                        //colSum.FooterText = "Sum " + r.CAPTION + " : ";

                        if (string.IsNullOrEmpty(colSum.FooterAggregateFormatString))
                        {
                            colSum.FooterAggregateFormatString = "Sum " + r.CAPTION + ":{0}";
                            colSum.Aggregate = GridAggregateFunction.Sum;
                        }


                    }
                    if (Convert.ToBoolean(rColumn2Total.GETCOUNT))
                    {
                        GridGroupByField f = new GridGroupByField();
                        f.HeaderText = r.CAPTION;
                        f.FieldName = r.COLUMNNAME;
                        f.FieldAlias = "F" + n++;
                        f.HeaderText = "Count " + r.CAPTION;
                        f.Aggregate = GridAggregateFunction.Count;
                        grdReport.MasterTableView.GroupByExpressions[i].SelectFields.Add(f);

                        //Customize FooterGroup
                        GridBoundColumn colCount = (GridBoundColumn)grdReport.MasterTableView.Columns.FindByUniqueName(r.COLUMNNAME);
                        //colCount.FooterText = "Count " + r.CAPTION + " : ";
                        colCount.Aggregate = GridAggregateFunction.Count;
                        colCount.FooterAggregateFormatString = "Count " + r.CAPTION + ":{0}";

                    }
                }//end for
            }//end if
            n++;
        }

        #endregion

        #region Create formular columns
        foreach (dsReportInfor.TBL_FORMULACOLUMNRow rFomularColumn in ReportInfor.TBL_FORMULACOLUMN)
        {
            if (rFomularColumn.FORMASTER.Equals(0))
            {
                GridBoundColumn grdColumn = new GridBoundColumn();
                grdColumn.DataField = rFomularColumn.CAPTION;
                grdColumn.HeaderText = rFomularColumn.CAPTION;
                grdReport.MasterTableView.Columns.Add(grdColumn);
            }
        }
        #endregion

        grdReport.DataSource = dt;
    }

Plz help me review it!!!
Best regards,
Le

[Rosen]

Hi Le,

Indeed there is an issue with group footer aggregate which our developers are currently investigating.

Please excuse us inconvenience.

Sincerely yours,
Rosen
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Le]

Hello,
Plz tell me immediately when you fix this issue.
Thanks & best regards,
Le

[Rosen]

Hello,

I'm happy to inform you that our developers has managed to address the grouping footers calculation issue. Please download Q1 2009 SP2 release and see if it helps.

Regards,
Rosen
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.