or
<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 | ||||
Dim Print As New System.Diagnostics.ProcessStartInfo()Print.Verb = "print"Print.WindowStyle = ProcessWindowStyle.HiddenPrint.FileName = fullpathPrint.UseShellExecute = TrueSystem.Diagnostics.Process.Start(Print)<GroupByExpressions> <telerik:GridGroupByExpression > <SelectFields > <telerik:GridGroupByField FieldAlias="Engagement Name" FieldName="EngName" FormatString="{0:d}"></telerik:GridGroupByField> </SelectFields> <GroupByFields > <telerik:GridGroupByField FieldName="EngNameWithID" HeaderText="Engagement Name"></telerik:GridGroupByField> </GroupByFields> </telerik:GridGroupByExpression></GroupByExpressions>HeaderText="Engagement Name" as per localization.Thanks.....