<telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" Width="950px" runat="server"
AutoGenerateColumns="False" AllowSorting="True" AllowMultiRowSelection="False" MasterTableView-RowIndicatorColumn-Resizable="false"
ShowHeader="true" OnBiffExporting="RadGrid1_BiffExporting" OnItemCreated="RadGrid1_ItemCreated" OnItemDataBound="RadGrid1_ItemDataBound">
<ExportSettings ExportOnlyData="true" />
<ClientSettings>
<Resizing AllowRowResize="false" ShowRowIndicatorColumn="false" />
</ClientSettings>
<PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle>
<MasterTableView ShowHeader="true" AutoGenerateColumns="False" AllowPaging="true"
DataKeyNames="CustomerID" PageSize="7" HierarchyLoadMode="ServerOnDemand" CommandItemDisplay="Top" RowIndicatorColumn-Display="false">
<CommandItemTemplate>
<div style="height: 25px; width: 940px; padding-top: 7px;">
<div style="float: left; width: 800px; text-align: left; margin-left: 10px;">
<asp:Label ID="Label2" runat="server" Text="Completed/Declined" CssClass="labelTelerik" Font-Size="Medium" Font-Bold="true"></asp:Label>
</div>
<div style="float: left; margin-right: 15px;">
<asp:ImageButton ImageUrl="../Admin/Images/print.png" ToolTip="Print Grid" ID="ImageButton1" AlternateText="Print" runat="server" OnClientClick="PrintRadGrid()" Height="20px" />
</div>
<div style="float: left; margin-right: 15px;">
<asp:Button runat="server" ID="buttonRefresh" CommandName="Rebind" CssClass="rgRefresh" Text=" " ToolTip="Refresh Grid" />
<asp:LinkButton runat="server" ID="linkbuttionRefresh" CommandName="Rebind" Text="Refresh"></asp:LinkButton>
</div>
<div style="margin-left: 10px;">
<asp:Button runat="server" ID="button1" CommandName="ExportToExcel" CssClass="rgExpXLS" Text=" " ToolTip="Export To Excel" /></div>
</div>
</CommandItemTemplate>
<DetailTables>
<telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="StoreID" DataSourceID="SqlDataSource2" Width="100%">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="CustomerID" MasterKeyField="CustomerID"></telerik:GridRelationFields>
</ParentTableRelation>
<DetailTables>
<telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="AgentID" DataSourceID="SqlDataSource3" Width="100%">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="StoreID" MasterKeyField="StoreID"></telerik:GridRelationFields>
</ParentTableRelation>
<DetailTables>
<telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="AgentID" DataSourceID="SqlDataSource4" Width="100%">
<ParentTableRelation>
<telerik:GridRelationFields MasterKeyField="AgentID" DetailKeyField="AgentID" />
</ParentTableRelation>
<Columns>
<telerik:GridBoundColumn SortExpression="JobName" HeaderText="Job Name" HeaderButtonType="TextButton" DataField="JobName" HeaderStyle-Width="150" />
<telerik:GridBoundColumn SortExpression="JobStatus" HeaderText="Job Status" HeaderButtonType="TextButton" HeaderStyle-Width="340" DataField="JobStatus" />
<telerik:GridBoundColumn SortExpression="EntryDate" DataFormatString="{0:MM/dd/yyyy}" HeaderText="EntryDate" HeaderStyle-Width="80" HeaderButtonType="TextButton" DataField="EntryDate" />
<telerik:GridBoundColumn SortExpression="invTotal" DataFormatString="{0:C}" HeaderText="Invoice Total" HeaderStyle-Width="80" HeaderButtonType="TextButton" DataField="invTotal" />
<telerik:GridTemplateColumn UniqueName="TemplateEditColumn" DataField="JobID" HeaderStyle-Width="50">
<ItemTemplate>
<asp:HyperLink ID="ViewLink" runat="server" Text="View"></asp:HyperLink>
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridBoundColumn SortExpression="AgentID" HeaderText="AgentID" HeaderButtonType="TextButton" DataField="AgentID" Display="false" />
<telerik:GridBoundColumn SortExpression="AgentName" HeaderButtonType="TextButton" HeaderText="Agent Name" DataField="AgentName" HeaderStyle-Width="160">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Comp" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="Comp">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Decl" HeaderText="Declined" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="Decl">
</telerik:GridBoundColumn>
<telerik:GridCalculatedColumn HeaderText="Total" UniqueName="Total" DataType="System.Int32" HeaderStyle-Width="80"
DataFields="comp, decl" Expression="{0} + {1}" />
<telerik:GridNumericColumn SortExpression="Perc" HeaderText="Average" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="Perc" DataFormatString="{0:P}">
</telerik:GridNumericColumn>
<telerik:GridBoundColumn SortExpression="TLCount" HeaderText="Total Loss" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="TLCount">
</telerik:GridBoundColumn>
<telerik:GridNumericColumn SortExpression="InvTot" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="InvTot" DataFormatString="{0:C}">
</telerik:GridNumericColumn>
<telerik:GridNumericColumn SortExpression="CompAv" HeaderText="Average Job" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="CompAv" DataFormatString="{0:C}">
</telerik:GridNumericColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridBoundColumn SortExpression="LocationName" HeaderButtonType="TextButton" HeaderText="Location Name" HeaderStyle-Width="180"
DataField="LocationName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Comp" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80" DataField="Comp">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Decl" HeaderText="Declined" HeaderButtonType="TextButton" HeaderStyle-Width="80" DataField="Decl">
</telerik:GridBoundColumn>
<telerik:GridCalculatedColumn HeaderText="Total" UniqueName="Total" DataType="System.Int32" HeaderStyle-Width="80"
DataFields="comp, decl" Expression="{0} + {1}" />
<telerik:GridNumericColumn SortExpression="Perc" HeaderText="Average" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="Perc" DataFormatString="{0:P}">
</telerik:GridNumericColumn>
<telerik:GridBoundColumn SortExpression="TLCount" HeaderText="Total Loss" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="TLCount">
</telerik:GridBoundColumn>
<telerik:GridNumericColumn SortExpression="InvTot" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="InvTot" DataFormatString="{0:C}">
</telerik:GridNumericColumn>
<telerik:GridNumericColumn SortExpression="CompAv" HeaderText="Average Job" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="CompAv" DataFormatString="{0:C}">
</telerik:GridNumericColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridBoundColumn SortExpression="CompanyName" HeaderStyle-Width="200" HeaderButtonType="TextButton" HeaderText="Company Name"
DataField="CompanyName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Comp" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="Comp">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Decl" HeaderText="Declined" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="Decl">
</telerik:GridBoundColumn>
<telerik:GridCalculatedColumn HeaderText="Total" UniqueName="Total" DataType="System.Int32" HeaderStyle-Width="80"
DataFields="comp, decl" Expression="{0} + {1}" />
<telerik:GridNumericColumn SortExpression="Perc" HeaderText="Average" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="Perc" DataFormatString="{0:P}">
</telerik:GridNumericColumn>
<telerik:GridBoundColumn SortExpression="TLCount" HeaderText="Total Loss" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="TLCount">
</telerik:GridBoundColumn>
<telerik:GridNumericColumn SortExpression="InvTot" HeaderText="Completed" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="InvTot" DataFormatString="{0:C}">
</telerik:GridNumericColumn>
<telerik:GridNumericColumn SortExpression="CompAv" HeaderText="Average Job" HeaderButtonType="TextButton" HeaderStyle-Width="80"
DataField="CompAv" DataFormatString="{0:C}">
</telerik:GridNumericColumn>
</Columns>
</MasterTableView>
<ClientSettings ReorderColumnsOnClient="True" AllowDragToGroup="True" AllowColumnsReorder="True">
<Selecting AllowRowSelect="True"></Selecting>
<Resizing AllowRowResize="True" AllowColumnResize="True" EnableRealTimeResize="True"
ResizeGridOnColumnResize="False"></Resizing>
</ClientSettings>
<GroupingSettings ShowUnGroupButton="true"></GroupingSettings>
</telerik:RadGrid>
DataSources
<asp:SqlDataSource ID="SqlDataSource1" ProviderName="System.Data.SqlClient" runat="server"
SelectCommand="Shine.dbo.CustomerJobStatus" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:SessionParameter Name="CustomerID" SessionField="CustomerID" Type="Int32"></asp:SessionParameter>
<asp:ControlParameter Name="StartDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calStartDate" />
<asp:ControlParameter Name="EndDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calEndDate" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" ProviderName="System.Data.SqlClient" runat="server" SelectCommand="Shine.dbo.LocationJobStatus" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:SessionParameter Name="CustomerID" SessionField="CustomerID" Type="Int32"></asp:SessionParameter>
<asp:ControlParameter Name="StartDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calStartDate" />
<asp:ControlParameter Name="EndDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calEndDate" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource3" ProviderName="System.Data.SqlClient" runat="server" SelectCommand="Shine.dbo.AgentJobStatus" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:SessionParameter Name="StoreID" SessionField="StoreID" Type="Int32"></asp:SessionParameter>
<asp:ControlParameter Name="StartDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calStartDate" />
<asp:ControlParameter Name="EndDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calEndDate" />
</SelectParameters>
</asp:SqlDataSource>
 
<asp:SqlDataSource ID="SqlDataSource4" runat="server"
ProviderName="System.Data.SqlClient" SelectCommand="Select EU.FirstName + ' ' + EU.LastName as JobName, J.EntryDate, J.AgentID,
JS.JobStatus + ' (' + SS.SubStatusName + ')' as JobStatus, ISNULL(J.InvoiceTotal, 0) as invTotal, J.JobID
From Shine.dbo.job J
JOIN Shine.dbo.EndUser EU ON EU.EndUserID = J.EndUserID
JOIN Shine.dbo.JobStatus JS ON JS.JobStatusID = J.JobStatusID
JOIN Shine.dbo.JobSubStatus SS ON SS.JobSubStatusID = J.JobSubStatusID
Where j.JobStatusID IN (4,5,6) AND J.LastUpdateDate > @StartDate AND J.LastUpdateDate < DateAdd(day, 1, @EndDate) AND J.AgentID = @AgentID">
<SelectParameters>
<asp:SessionParameter Name="AgentID" SessionField="AgentID" Type="Int32"></asp:SessionParameter>
<asp:ControlParameter Name="StartDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calStartDate" />
<asp:ControlParameter Name="EndDate" DbType="DateTime" PropertyName="DbSelectedDate" ControlID="calEndDate" />
</SelectParameters>
</asp:SqlDataSource>
RadFormDecorator control working properly asp controls and not working for rad controls. Applied skins are not decorating the rad controls. Please see the sample below.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register Assembly="Telerik.Web.UI, Version=2013.2.611.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4"
Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
></
title
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
div
>
<
div
>
<
telerik:RadScriptManager
runat
=
"server"
ID
=
"scriptmgr"
>
</
telerik:RadScriptManager
>
</
div
>
<
div
>
<
telerik:RadFormDecorator
ID
=
"Dd"
EnableEmbeddedSkins
=
"true"
EnableRoundedCorners
=
"true"
runat
=
"server"
DecoratedControls
=
"all"
Skin
=
"Office2007"
/>
</
div
>
<
div
>
<
asp:TextBox
ID
=
"UserName"
autocomplete
=
"off"
runat
=
"server"
></
asp:TextBox
>
</
div
>
<
div
>
<
asp:TextBox
ID
=
"TextBox1"
autocomplete
=
"off"
runat
=
"server"
></
asp:TextBox
>
</
div
>
<
div
>
<
asp:TextBox
ID
=
"TextBox2"
autocomplete
=
"off"
runat
=
"server"
></
asp:TextBox
>
</
div
>
<
div
>
<
asp:TextBox
ID
=
"TextBox3"
autocomplete
=
"off"
runat
=
"server"
></
asp:TextBox
>
</
div
>
<
div
>
<
telerik:RadTextBox
ID
=
"_rdtxtOldPassword"
MaxLength
=
"15"
runat
=
"server"
Width
=
"200px"
TextMode
=
"Password"
AutoCompleteType
=
"Disabled"
>
</
telerik:RadTextBox
>
<
telerik:RadTextBox
ID
=
"_rdtxtNewPassword"
Style
=
"width: 50%"
MaxLength
=
"15"
runat
=
"server"
TextMode
=
"Password"
Width
=
"200px"
AutoCompleteType
=
"Disabled"
>
</
telerik:RadTextBox
>
</
div
>
<
div
>
<
asp:Button
ID
=
"_btnEditPassword"
runat
=
"server"
Text
=
"Submit"
Width
=
"86px"
/>
<
telerik:RadButton
runat
=
"server"
ID
=
"radButtom"
Text
=
"Submit"
></
telerik:RadButton
>
</
div
>
</
div
>
</
form
>
</
body
>
</
html
>
Thanks for your help in advance.