This is a migrated thread and some comments may be shown as answers.

group header aggregates with multiple group levels

0 Answers 15 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Grace
Top achievements
Rank 1
Grace asked on 11 May 2017, 04:25 PM

I have 3 levels of grouping in my radgrid and I need to display the sum of one of the detail levels at each group header level.  I have tried creating groups client side and server side with the same results.  The group header levels end up displaying and calculating sporadically on inner groups 2 and 3.  The top most group always displays correctly with the total hours.  Below is my code for the grid.  Any help or direction would be appreciated.

<t:RadGrid ID="rgPTOA" runat="server" GroupingEnabled="true"
OnNeedDataSource="rgPTOA_OnNeedDataSource" ShowGroupPanel="false"
OnItemCommand="rgPTOA_OnItemCommand" GroupingSettings-GroupByFieldsSeparator=" "
Visible="false"
GridLines="None"
ShowFooter="false"
HeaderStyle-Wrap="false"
ShowHeader="false" AutoGenerateColumns="false" OnPreRender="rgPTOA_PreRender"
>
<ClientSettings AllowGroupExpandCollapse="true">
</ClientSettings>
<GroupingSettings RetainGroupFootersVisibility="true" />
<MasterTableView ShowGroupFooter="true" EnableNoRecordsTemplate="true" ShowHeadersWhenNoRecords="false" DataKeyNames="EmpNameLine"
AutoGenerateColumns="false" Width="100%" TableLayout="Fixed" GroupLoadMode="Client"
>
<NoRecordsTemplate>NO RECORDS </NoRecordsTemplate>
<Columns>
<telerik:GridTemplateColumn>
<ItemTemplate>
<!-- Content Area -->
<!-- result 1-1-1-1 -->
<section>
<section class="large-border-bottom-grey">
<div class="magic-mobile-panels no-table">
<div class="row">
<!-- date requested -->
<div class="column small-12 large-expand">
<div class="mmpanel">
<header>
DATE REQUESTED
</header>
<div>
<asp:Label ID="Label7" runat="server" Text='<%# Eval("PTO_DATE", "{0:MM/dd/yyyy}") %>'> </asp:Label>
</div>
</div>
</div>
<!-- benefit type -->
<div class="column small-12 large-expand">
<div class="mmpanel">
<header>
BENEFIT TYPE
</header>
<div>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("PAY_TYPE_CODE") %> '> </asp:Label>
</div>
</div>
</div>
<!-- labor status -->
<div class="column small-12 large-expand">
<div class="mmpanel">
<header>
LABOR STATUS
</header>
<div>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("LaborStatus") %> '> </asp:Label>
</div>
</div>
</div>
<!-- dist. code -->
<div class="column small-12 large-expand show-for-large">
<div class="mmpanel">
<header>
DIST. CODE
</header>
<div>
<asp:Label ID="Label3" runat="server" Text='<%# Eval("PR_DIST_ID") %> '> </asp:Label>
</div>
</div>
</div>
<!-- start time -->
<div class="column small-12 large-expand">
<div class="mmpanel">
<header>
START TIME
</header>
<div>
<asp:Label ID="Label4" runat="server" Text='<%# Eval("PTO_Date","{0:hh:mm tt}")%> '> </asp:Label>
</div>
</div>
</div>
<!-- hours -->
<div class="column small-12 large-expand">
<div class="mmpanel">
<header>
HOURS
</header>
<div>
<asp:Label ID="Label5" runat="server" Text='<%# Eval("PTO_HOURS") %> '> </asp:Label>
</div>
</div>
</div>
<!-- review due date -->
<div class="column small-12 large-expand">
<div class="mmpanel">
<header>
REVIEW DUE DATE
</header>
<div>
<asp:Label ID="Label6" runat="server" Text='<%# Eval("PTO_APPROVE_DUE","{0:hh:mm tt}")%> '> </asp:Label>
</div>
</div>
</div>
<!-- approval status -->
<div class="column small-12 large-expand show-for-large">
<div class="mmpanel">
<header>
STATUS
</header>
<div>
<asp:Label ID="Label8" runat="server" Text='<%# Eval("PTOVerificationStatus") %> '> </asp:Label>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- desktop -->
<section class="show-for-large">
<div class="row column-center-divider">
<!-- comment -->
<div class="column">
<div class="panel-2">
<header>COMMENT</header>
<div class="font-size-smaller">
<asp:Label ID="Label9" runat="server" Text='<%# Eval("PTO_COMMENT") %> '> </asp:Label>
</div>
</div>
</div>
<!-- approval comment -->
<div class="column">
<div class="panel-2">
<header>APPROVAL COMMENT</header>
<div class="font-size-smaller">
<asp:Label ID="Label10" runat="server" Text='<%# Eval("PTO_REVIEW_COMM") %> '> </asp:Label>
</div>
</div>
</div>
</div>
</section>
<!-- /desktop -->
</section>
<!-- /result 1-1-1-1 -->
<!-- /RESULTS -->
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
<GroupByExpressions>
<%--First Grouping Header--%>
<t:GridGroupByExpression>
<GroupByFields>
<t:GridGroupByField FieldName="DeptID" />
</GroupByFields>
<SelectFields>
<t:GridGroupByField FieldName="DeptID" HeaderText=" " HeaderValueSeparator="" />
<t:GridGroupByField FieldName="PTO_HOURS" FieldAlias="A2" Aggregate="Sum" FormatString="{0:F2}" HeaderText=" &nbsp;&nbsp;&nbsp;Total Hours" />
</SelectFields>
</t:GridGroupByExpression>
<%--Second Grouping Header--%>
<t:GridGroupByExpression>
<GroupByFields>
<t:GridGroupByField
FieldName="EmpNameLine" />
</GroupByFields>
<SelectFields>
<t:GridGroupByField FieldName="EmpNameLine" HeaderText="Employee" />
<t:GridGroupByField FieldName="PTO_HOURS" FieldAlias="A3" Aggregate="Sum" FormatString="{0:F2}" HeaderText=" &nbsp;&nbsp;&nbsp;Total Hours" />
</SelectFields>
</t:GridGroupByExpression>
<%--Third Grouping Header--%>
<t:GridGroupByExpression>
<GroupByFields>
<t:GridGroupByField
FieldName="PAY_TYPE_CODE" />
</GroupByFields>
<SelectFields>
<t:GridGroupByField FieldName="PAY_TYPE_CODE" HeaderText="Pay Type" />
<t:GridGroupByField FieldName="PTO_HOURS" FieldAlias="A4" Aggregate="Sum" FormatString="{0:F2}" HeaderText=" &nbsp;&nbsp;&nbsp;Total Hours" />
</SelectFields>
</t:GridGroupByExpression>
</GroupByExpressions>
</MasterTableView>
</t:RadGrid>

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Grace
Top achievements
Rank 1
Share this question
or