Grouping not being displayed on Header for Sub Groups

2 posts, 0 answers
  1. Bill
    Bill avatar
    175 posts
    Member since:
    Apr 2010

    Posted 24 Jan 2013 Link to this post

    I'm having an issue where the grid is not displaying the Ship sub total (see attachment).

    How can I get the Ship Total to display the total for the Ship instead of the "{0:C}" literal?

    How can I also get rid of the SORT bar (see attachement).
    I don't have any code behind to handle this and I don't need to.

    Here is some pertinent code that I have the way the grid is set up....
    <telerik:RadGrid ID="RadGrid1" runat="server"
                            PageSize="20" AllowSorting="True" AllowPaging="True" ShowGroupPanel="True"
                            OnColumnCreated="RadGrid1_ColumnCreated">
                            <PagerStyle Mode="NumericPages"></PagerStyle>
                            <MasterTableView Width="100%">
                            </MasterTableView>
                            <ClientSettings>
                                <Resizing AllowColumnResize="True"></Resizing>
                            </ClientSettings>
                        </telerik:RadGrid>

    protected void Button1_Click(object sender, EventArgs e)
    {
        string groupBY = "CruiseLine [CruiseLine], Sum(Sales) GroupTotal [CruiseLine Total] Group By CruiseLine";
        group(groupBY);
    }
     
    protected void Button2_Click(object sender, EventArgs e)
    {
        string groupBY = "Ship [Ship], Sum(Sales) GroupTotal [Ship Total] Group By Ship";
        group(groupBY);
    }
     
    protected void Button3_Click(object sender, EventArgs e)
    {
        string groupBY = "Date [Date], Sum(Sales) GroupTotal [Date Total] Group By Date";
        group(groupBY);
    }

    protected void group(string groupBY)
        {
            try
            {
                GridGroupByExpression expression1 = GridGroupByExpression.Parse(groupBY);
                this.CustomizeExpression(expression1);
                this.RadGrid1.MasterTableView.GroupByExpressions.Add(expression1);
            }
            catch (Exception ex)
            {
                lblError.Text = string.Format("<span style='color:red'>Cannot add group by expression: {0}</span>", ex.Message);
                lblError.Visible = true;
            }
            finally
            {
                BindData();
            }
        }

    protected void BindData()
        {
            Hashtable htParams = new Hashtable();
            htParams.Add("@CruiseLine", ViewState["prmCruiseLine"]);
            htParams.Add("@Ship", ViewState["prmShip"]);
            htParams.Add("@FromDate", FromDate.SelectedDate.Value.ToShortDateString());
            htParams.Add("@ToDate", ToDate.SelectedDate.Value.ToShortDateString());
     
            // Call SPROC to populate grid
            DataUtiliities data = new DataUtiliities("PrepaidConnectionString");
            DataSet dsRpt = data.ExecuteDataSet("SelectProductInfoByShipAndDate2", htParams);
     
            // Bind the Grid
            RadGrid1.DataSource = dsRpt.Tables[0].DefaultView;
            RadGrid1.DataBind();
        }

    Here is the output of the groups during debugging:
    groupBY = "CruiseLine [CruiseLine], Sum(Sales) GroupTotal [CruiseLine Total] Group By CruiseLine"
    expression1 = {CruiseLine , sum(Sales) GroupTotal Group By CruiseLine}
     
    groupBY = "Ship [Ship], Sum(Sales) GroupTotal [Ship Total] Group By Ship"
    expression1 = {Ship , sum(Sales) GroupTotal Group By Ship}
  2. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 30 Jan 2013 Link to this post

    Hi William,

    We have reports for similar issue in the past however it appeared to be rather difficult to reproduce on our end as it depends on the specific data added in the RadGrid. I would suggest you to open a regular support ticket and send us a sample runnable application which demonstrates the problem.
    Meanwhile you could disable the Linq Grouping and verify if the issue still appears.

    Greetings,
    Maria Ilieva
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top