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 |
Dim
Print
As
New
System.Diagnostics.ProcessStartInfo()
Print.Verb =
"print"
Print.WindowStyle = ProcessWindowStyle.Hidden
Print.FileName = fullpath
Print.UseShellExecute =
True
System.Diagnostics.Process.Start(Print)