or
<tr> <td><p><strong>Start Date: </strong></p></td> <td> <telerik:RadDateTimePicker runat="server" ID="rdtpStartDate" Skin="Windows7" DbSelectedDate='<%#Bind("StartDate") %>' ClientEvents-OnDateSelected="dateSelected" /> <asp:RequiredFieldValidator runat="server" Display="None" ErrorMessage="Start Date is required." EnableClientScript="true" ControlToValidate="rdtpStartDate" /> </td></tr><tr> <td><p><strong>End Date: </strong></p></td> <td> <telerik:RadDateTimePicker runat="server" ID="rdtpEndDate" Skin="Windows7" DbSelectedDate='<%#Bind("EndDate") %>' /> <asp:RequiredFieldValidator runat="server" Display="None" ErrorMessage="End Date is required." EnableClientScript="true" ControlToValidate="rdtpEndDate" /> </td></tr><script language="javascript" type="text/javascript"> function dateSelected(sender, args) { var hv = document.getElementById('<%=this.hvEndDateId.ClientID %>').value; var edp = $find(hv); var newDate = sender.get_selectedDate(); edp.set_minDate(newDate); } </script>
<telerik:RadSplitter ID="RadSplitter1" runat="server" Width="100%" Height="700px"> <telerik:RadPane ID="LeftPane" runat="server" Width="250px" Scrolling="Both"> <asp:Panel ID="QAGuidePanel" runat="server" Width="100%" HorizontalAlign="Left"> <asp:SqlDataSource ID="QAGuideSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:GuidesConnectionString %>" SelectCommand="SELECT [SerID], ('~/QA/Pages/' + [Path] + '.aspx') as FullPath, [ParentID], [Title] FROM [QAGuide]"></asp:SqlDataSource> <telerik:RadTreeView ID="QAGuideRadTreeView" runat="server" DataSourceID="QAGuideSqlDataSource" DataNavigateUrlField="FullPath" DataFieldParentID="ParentID" DataFieldID="SerID" DataTextField="Title" > <DataBindings> <telerik:RadTreeNodeBinding Depth="0" Expanded="true" /> </DataBindings> </telerik:RadTreeView> </asp:Panel> </telerik:RadPane> <telerik:RadSplitBar ID="Radsplitbar1" runat="server"></telerik:RadSplitBar> <telerik:RadPane ID="MiddlePane1" runat="server" Scrolling="None"> <telerik:RadSplitter ID="Radsplitter2" runat="server" Orientation="Horizontal" VisibleDuringInit="false"> <telerik:RadPane ID="Radpane2" runat="server"> <div style="padding: 5px"> <asp:ContentPlaceHolder id="ContentPlaceHolder1" runat="server"> </asp:ContentPlaceHolder> <asp:Panel ID="ContentPanel" style="margin:10px;" HorizontalAlign="Left" runat="server"> <asp:Label ID="SerIDLabel" Visible="false" runat="server" ></asp:Label> <asp:SqlDataSource ID="ContentSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:GuidesConnectionString %>" SelectCommand="SELECT * FROM [QAGuide] WHERE ([SerID] = @SerID)"> <SelectParameters> <asp:ControlParameter ControlID="SerIDLabel" Name="SerID" PropertyName="Text" Type="Int64" /> </SelectParameters> </asp:SqlDataSource> <asp:FormView ID="ContentFormView" runat="server" Visible="true" Width="100%" DataKeyNames="SerID" DataSourceID="ContentSqlDataSource"> <ItemTemplate> <asp:Label ID="TitleLabel" SkinID="HeaderText" runat="server" Text='<%# Eval("Title") %>' /> <br /><br /> <asp:Label ID="TextCnsrtLabel" runat="server" Text='<%# Eval("Cntnt") %>' ></asp:Label> </ItemTemplate> </asp:FormView> </asp:Panel> </div> </telerik:RadPane> </telerik:RadSplitter> </telerik:RadPane> </telerik:RadSplitter>
Radgrid columns preparing dynamically. Group code is:
Protected SubRadGrid1_ColumnCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridColumnCreatedEventArgs) Handles RadGrid1.ColumnCreated
If e.Column.DataType.Name = "Decimal" Or e.Column.DataType.Name = "Double" Then
CType(e.Column, Telerik.Web.UI.GridBoundColumn).DataFormatString = "{0:N3}"
CType(e.Column, Telerik.Web.UI.GridBoundColumn).Groupable = True
CType(e.Column, Telerik.Web.UI.GridBoundColumn).Aggregate = Telerik.Web.UI.GridAggregateFunction.Sum
End If
End Sub
Group totals working fine if I use 1 group. When I create second a group 1th level sub total is not correct. For example:
| SALARY | DIVISION | REGION | ||
| Region: AAA | ||||
| Division : XXX | ||||
| 796,50 | XXX | AAA | ||
| 796,50 | XXX | AAA | ||
| 796,50 | XXX | AAA | ||
| 2.389,50 | ||||
| Division : YYY | ||||
| 796,50 | YYY | AAA | ||
| 796,5 | ||||
| 1.593,00 | ||||
| Region: BBB | ||||
| Division : LLL | ||||
| 3646,00 | LLL | BBB | ||
| 3657,00 | LLL | BBB | ||
| 3180,00 | LLL | BBB | ||
| 3500,00 | LLL | BBB | ||
| 13.983,00 | ||||
| 3.500,00 | ||||