<!-- content start -->
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadGrid1">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />
</UpdatedControls>
</telerik:AjaxSetting>
<telerik:AjaxSetting AjaxControlID="btnRunReport">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="WebBlue">
</telerik:RadAjaxLoadingPanel>
<telerik:RadGrid ID="RadGrid1" Skin="Office2007" runat="server" Width="95%" AutoGenerateColumns="False"
OnNeedDataSource="RadGrid1_NeedDataSource" PageSize="25" AllowSorting="True"
AllowPaging="True" GridLines="None" EnableHeaderContextMenu="true" AllowFilteringByColumn="true">
<PagerStyle Mode="NextPrevAndNumeric" />
<ItemStyle HorizontalAlign="Left" />
<AlternatingItemStyle HorizontalAlign="Left" />
<ExportSettings Excel-Format="ExcelML" ExportOnlyData="True" FileName="CommissionStatement"
IgnorePaging="True" OpenInNewWindow="True" Pdf-Author="International Medical Group"
Pdf-Creator="International Medical Group" Pdf-PageHeight="8.5in" Pdf-PageWidth="11in"
Pdf-Title="Commission Statement">
<Pdf Creator="International Medical Group" Author="International Medical Group" Title="Commission Statement"
PageWidth="11in" PageHeight="8.5in"></Pdf>
<Excel Format="ExcelML"></Excel>
</ExportSettings>
<MasterTableView AllowMultiColumnSorting="false" TableLayout="Fixed" CommandItemDisplay="Top">
<CommandItemSettings ShowExportToWordButton="true" ShowExportToPdfButton="true" ShowExportToExcelButton="true"
ShowExportToCsvButton="true" ShowAddNewRecordButton="False" />
<RowIndicatorColumn Visible="True">
</RowIndicatorColumn>
<Columns>
<telerik:GridBoundColumn DataField="CompanyAbbreviation" HeaderText="Company" SortExpression="CompanyAbbreviation"
UniqueName="Company" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true"
Display="true">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="prem_comm_cert_nbr" HeaderText="Certificate Number"
SortExpression="prem_comm_cert_nbr" UniqueName="CertificateNumber" CurrentFilterFunction="StartsWith"
AutoPostBackOnFilter="true">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="prem_comm_desc" HeaderText="Primary Insured Name"
SortExpression="prem_comm_desc" UniqueName="PrimaryInsuredName" CurrentFilterFunction="StartsWith"
AutoPostBackOnFilter="true">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="cov_desc" HeaderText="Coverage" SortExpression="cov_desc"
UniqueName="Coverage" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings ReorderColumnsOnClient="True" AllowColumnsReorder="True" AllowColumnHide="True">
<Resizing AllowRowResize="True" AllowColumnResize="True"></Resizing>
<Animation AllowColumnReorderAnimation="True" />
</ClientSettings>
<FilterMenu Skin="WebBlue">
</FilterMenu>
</telerik:RadGrid>
<telerik:RadGrid ID="RadGrid1" AllowSorting="true" Width="100%" runat="server" > <MasterTableView TableLayout="Fixed" DataKeyNames="KEYID" ClientDataKeyNames="KEYID" GridLines="Both" GroupsDefaultExpanded="true" GroupLoadMode="client" > <GroupByExpressions> <telerik:GridGroupByExpression> <SelectFields > <telerik:GridGroupByField SortOrder="Ascending" FieldAlias="EMPDOH" FieldName="EMPDOH" FormatString="{0:D}" HeaderValueSeparator=" from date: "></telerik:GridGroupByField> </SelectFields> <GroupByFields> <telerik:GridGroupByField FieldName="EMPDOH" SortOrder="Ascending"></telerik:GridGroupByField> </GroupByFields> </telerik:GridGroupByExpression > </GroupByExpressions> <Columns> <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" /> <telerik:GridBoundColumn UniqueName="KEYID" Display="false" DataField="KEYID"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Employees" DataField="Name" UniqueName="Name" ShowFilterIcon="false" SortExpression="Name" AllowFiltering="true" FilterControlWidth="100" AutoPostBackOnFilter="true" /> <telerik:GridBoundColumn HeaderText="Pay Period" DataField="Description" UniqueName="Description" ShowFilterIcon="false" SortExpression="Description"> <FilterTemplate> <telerik:RadComboBox ID="RadComboBoxPP" CausesValidation="false" Width="100" DataSourceID="SqlDataSourcePP" DataTextField="Code" DataValueField="Code" Height="100px" AppendDataBoundItems="true" OnClientSelectedIndexChanged="SelectedIndexChanged" SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("Description").CurrentFilterValue %>' runat="server"> <Items> <telerik:RadComboBoxItem Text="All" /> </Items> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server"> <script type="text/javascript"> function SelectedIndexChanged(sender, args) { var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>"); sender.value = args.get_item().get_value(); tableView.filter("Description", args.get_item().get_value(), "EqualTo"); } </script> </telerik:RadScriptBlock> </FilterTemplate> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Department" DataField="Department" UniqueName="Department" ShowFilterIcon="false" SortExpression="Department"> <FilterTemplate> <telerik:RadComboBox ID="RadComboBoxDep" CausesValidation="false" DataSourceID="SqlDataSourceDepartment" Width="120" DataTextField="Department" DataValueField="Department" Height="100px" AppendDataBoundItems="true" OnClientSelectedIndexChanged="SelectedIndexChanged2" SelectedValue='<%# TryCast(Container, GridItem).OwnerTableView.GetColumn("Department").CurrentFilterValue %>' runat="server"> <Items> <telerik:RadComboBoxItem Text="All" /> </Items> </telerik:RadComboBox> <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server"> <script type="text/javascript"> function SelectedIndexChanged2(sender, args) { var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>"); sender.value = args.get_item().get_value(); tableView.filter("Department", args.get_item().get_value(), "EqualTo"); } </script> </telerik:RadScriptBlock> </FilterTemplate> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn ReadOnly="true" DataField="Paydate" HeaderText="Pay Date" DataFormatString="{0:d}" DataType="System.DateTime" UniqueName="PayDate" AllowFiltering="true" SortExpression="PayDate" FilterControlWidth="90" /> <telerik:GridBoundColumn AllowFiltering="false" HeaderText="Start Date" DataFormatString="{0:d}" DataField="PayDateFrom" UniqueName="PayDateFrom" DataType="System.DateTime" ShowFilterIcon="false" SortExpression="PayDateFrom" /> <telerik:GridBoundColumn HeaderText="End Date" DataField="Paydateto" DataFormatString="{0:d}" UniqueName="Paydateto" DataType="System.DateTime" ShowFilterIcon="false" AllowFiltering="false" SortExpression="Paydateto" /> <telerik:GridBoundColumn HeaderText="Hire/Rehire" DataField="EMPDOH" Groupable="true" UniqueName="EMPDOH" DataFormatString="{0:d}" DataType="System.DateTime" ShowFilterIcon="false" AllowFiltering="false" SortExpression="EMPDOH" /> <telerik:GridBoundColumn DataField="hdismass" UniqueName="hdismass" Display="false" HeaderText="hdismass" AllowFiltering="false" /> <telerik:GridBoundColumn HeaderText="hds" DataField="hds" Display="false" UniqueName="hds" AllowFiltering="false" /> </Columns> </MasterTableView> <ClientSettings AllowColumnsReorder="false" ReorderColumnsOnClient="false" AllowExpandCollapse="true" > <Selecting AllowRowSelect="true" /> <Resizing AllowRowResize="false" EnableRealTimeResize="True" ResizeGridOnColumnResize="true" AllowColumnResize="false"></Resizing> </ClientSettings> <GroupingSettings ShowUnGroupButton="true" /> </telerik:RadGrid>