This is a migrated thread and some comments may be shown as answers.

Radgrid Filtering vs Paging

1 Answer 33 Views
Grid
This is a migrated thread and some comments may be shown as answers.
New User
Top achievements
Rank 1
New User asked on 18 Aug 2011, 08:18 PM
I currently have a couple of grids that have some dropdowns as filters.  When I choose a filter where the data is only on page 2 of the grid the grid return 'No Data in Grid' but when I page over to page 2 the data is filtered correctly.  This is happening for both of my grids. 
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WorkQueue.aspx.cs" Inherits="Sterling.SNEF.Tax.Web.WorkQueue" %>
  
<%@ Register Assembly="Telerik.Web.UI" 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">
<head runat="server">
    <title>Work Queue</title>
    <style type="text/css">
        .RadGrid_Web20 .rgCommandRow
        {
            color: #35467C !important;
            height: 24px !important;
        }
    </style>
</head>
<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
  
    <script type="text/javascript">      
  
        function pageLoad(sender, eventArgs) {
            if (!eventArgs.get_isPartialLoad()) {
                $find("<%= RadAjaxManager1.ClientID %>").ajaxRequest("InitialPageLoad");
            }
        
  
  
        function onRequestStart(sender, args)
        {
            if (args.get_eventTarget().indexOf("ExportToExcelButton") >=0)
            {
                args.set_enableAjax(false);
            }
        }
     
    </script>
  
</telerik:RadCodeBlock>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
    </telerik:RadScriptManager>
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
        <ClientEvents OnRequestStart="onRequestStart" />
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadAjaxManager1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="Panel1" LoadingPanelID="LoadingPanel" />
                </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="Panel1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="Panel1" LoadingPanelID="RadAjaxLoadingPanel1" />
                </UpdatedControls>
            </telerik:AjaxSetting>                        
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <telerik:RadAjaxLoadingPanel ID="LoadingPanel" runat="server" HorizontalAlign="Center"
        Width="50px" BorderColor="#99CCFF">
        <asp:Image ID="Image1" runat="server" ImageUrl="Images/loading.gif" ImageAlign="Top">
        </asp:Image>
    </telerik:RadAjaxLoadingPanel>
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Web20">
    </telerik:RadAjaxLoadingPanel>    
    <asp:Panel ID="Panel1" runat="server">
        <asp:Panel ID="Panel2" Visible="false" runat="server">
            <div style="border: thin solid #666666; left: 5px; position: relative; 
                left: 5px; width: 900px; border-collapse: collapse; background-color: #CCCCCC">
                <table>
                    <tr valign="top">
                        <td align="left" style="width: 220px;">
                            <asp:Label ID="lblSearchBy" runat="server" Font-Bold="True" Font-Names="arial,sans-serif"
                                Font-Size="12px">Search by: </asp:Label>
                                </br>                                
                                <asp:DropDownList ID="DropDownList1" runat="server"
                                    Font-Names="Arial" Font-Size="12px">
                                    <asp:ListItem>Select</asp:ListItem>
                                    <asp:ListItem>Hard Stops</asp:ListItem>
                                    <asp:ListItem>HOA</asp:ListItem>
                                    <asp:ListItem>Late Release</asp:ListItem>
                                    <asp:ListItem>Payment Denials</asp:ListItem>
                                    <asp:ListItem>Unworkable</asp:ListItem>
                                    <asp:ListItem>Work Status</asp:ListItem>
                                </asp:DropDownList>
                        </td>
                        <td align="left" style="width: 200px;">
                            <asp:Label ID="Label1" runat="server" Font-Names="arial,sans-serif" Font-Bold="True"
                                Font-Size="12px">Name: </asp:Label>
                                </br>
                                <asp:DropDownList ID="DropDownList2" runat="server"
                                    Font-Names="Arial" Font-Size="12px" Width="100px">
                                    <asp:ListItem>Select   </asp:ListItem>
                                </asp:DropDownList>
                        </td>
                        <td align="left" style="width: 70px;">
                            <asp:Label ID="Label3" runat="server" Font-Bold="True" Font-Names="arial,sans-serif"
                                Font-Size="12px">From Date: </asp:Label>
                        </br>
                        <telerik:RadDatePicker ID="dateStart" runat="server" FocusedDate="" Skin="Web20"
                        Width="130px" TabIndex="2">
                        <Calendar ID="Calendar3" runat="server" UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False"
                            ViewSelectorText="x" Skin="Web20" ShowRowHeaders="false">
                        </Calendar>
                        <DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>
                        <DateInput ID="DateInput3" runat="server" DisplayDateFormat="M/d/yyyy" DateFormat="M/d/yyyy">                       
                        </DateInput>
                    </telerik:RadDatePicker>                                                                       
                        </td>
                        <td align="left" style="width: 50px;">
                            <asp:Label ID="Label4" runat="server" Font-Bold="True" Font-Names="arial,sans-serif"
                                Font-Size="12px">To Date: </asp:Label>
                         </br>                            
                        <telerik:RadDatePicker ID="RadDatePicker2" runat="server" FocusedDate="" Skin="Web20"
                        Width="130px" TabIndex="2">
                        <Calendar ID="Calendar1" runat="server" UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False"
                            ViewSelectorText="x" Skin="Web20" ShowRowHeaders="false">
                        </Calendar>
                        <DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>
                        <DateInput ID="DateInput1" runat="server" DisplayDateFormat="M/d/yyyy" DateFormat="M/d/yyyy">                       
                        </DateInput>
                    </telerik:RadDatePicker>                             
                        </td>
                        <td width="90px" valign="bottom">
                            <asp:Button ID="SearchButton" runat="server" Text="Search" SkinID="Web20"/>
                        </td>
                        <td valign="bottom">
                        <asp:Button ID="DefaultButton" runat="server" Text="Default View" SkinID="Web20"/>
                        </td>
                    </tr>
                </table>
            </div>
            <div style="left: 5px; position: relative; left: 5px;">
                <br />
                <asp:Label ID="lblCurrentandPrior" runat="server" Font-Bold="True" Font-Size="Large"
                    Font-Names="Arial">Open Items Summary</asp:Label>
            </div>
            <div style="border: thin solid #5177B5; left: 5px; position: relative; left: 5px;
                width: 900px;">
                <table border="1" width="800px" style="border-collapse: collapse;">
                    <tr>
                        <td align="center" style="width: 145px; background-color: #7FA5D7;">
                            <asp:Label ID="hdrAssignee" runat="server" Text="Assignees" Font-Bold="True" Font-Names="Arial"
                                Font-Size="12px" ForeColor="White"></asp:Label>
                        </td>
                        <td align="center" style="width: 70px; background-color: #7FA5D7;">
                            <asp:Label ID="Label5" runat="server" Text="States" Font-Bold="True" Font-Names="arial,sans-serif"
                                Font-Size="12px" ForeColor="White"></asp:Label>
                        </td>
                        <td align="center" style="width: 100px; background-color: #7FA5D7;">
                            <asp:Label ID="Label6" runat="server" Text="Jurisdictions" Font-Bold="True" Font-Names="Arial"
                                Font-Size="12px" ForeColor="White"></asp:Label>
                        </td>
                        <td align="center" style="width: 100px; background-color: #7FA5D7;">
                            <asp:Label ID="Label7" runat="server" Text="Total Items" Font-Bold="True" Font-Names="Arial"
                                Font-Size="12px" ForeColor="White"></asp:Label>
                        </td>
                        <td align="center" style="width: 110px; background-color: #7FA5D7;">
                            <asp:Label ID="Label8" runat="server" Text="Still Open" Font-Bold="True" Font-Names="Arial"
                                Font-Size="12px" ForeColor="White"></asp:Label>
                        </td>
                        <td align="center" style="width: 100px; background-color: #7FA5D7;">
                            <asp:Label ID="Label9" runat="server" Text="Unworkable" Font-Bold="True" Font-Names="Arial"
                                Font-Size="12px" ForeColor="White"></asp:Label>
                        </td>
                        <td align="center" style="width: 90px; background-color: #7FA5D7;">
                            <asp:Label ID="Label11" runat="server" Text="Workable" Font-Bold="True" Font-Names="Arial"
                                Font-Size="12px" ForeColor="White"></asp:Label>
                        </td>
                        <td align="center" style="width: 85px; background-color: #7FA5D7;">
                            <asp:Label ID="Label12" runat="server" Text="% Complete" Font-Bold="True" Font-Names="Arial"
                                Font-Size="12px" ForeColor="White"></asp:Label>
                        </td>
                    </tr>
                    <tr>
                        <td align="right" style="width: 145px;">
                            <asp:Label ID="lblhdrAssignees" runat="server" Text=" " Font-Names="Arial" Font-Size="12px"></asp:Label>
                        </td>
                        <td align="right" style="width: 70px;">
                            <asp:Label ID="lblhdrStates" runat="server" Font-Names="arial,sans-serif" Font-Size="12px"></asp:Label>
                        </td>
                        <td align="right" style="width: 100px;">
                            <asp:Label ID="lblhdrJurisdictions" runat="server" Font-Names="arial,sans-serif"
                                Font-Size="12px"></asp:Label>
                        </td>
                        <td align="right" style="width: 100px;">
                            <asp:Label ID="lblhdrTotal" runat="server" Font-Names="arial,sans-serif" Font-Size="12px"></asp:Label>
                        </td>
                        <td align="right" style="width: 110px;">
                            <asp:Label ID="lblhdrStillOpen" runat="server" Font-Names="arial,sans-serif" Font-Size="12px"></asp:Label>
                        </td>
                        <td align="right" style="width: 100px;">
                            <asp:Label ID="lblhdrCannot" runat="server" Font-Names="arial,sans-serif" Font-Size="12px"></asp:Label>
                        </td>
                        <td align="right" style="width: 90px;">
                            <asp:Label ID="lblhdrWorkable" runat="server" Font-Names="arial,sans-serif" Font-Size="12px"></asp:Label>
                        </td>
                        <td align="right" style="width: 85px;">
                            <asp:Label ID="lblComplete" runat="server" Font-Names="arial,sans-serif" Font-Size="12px"></asp:Label>
                        </td>
                    </tr>
                </table>
            </div>
            <br />
            <div style="left: 5px; position: relative; left: 5px;">
                <asp:Label ID="Label10" runat="server" Font-Bold="True" Font-Size="Large" Font-Names="Arial">Open Items by Assignee</asp:Label>
                <telerik:RadGrid ID="grdOpenItemsByAssignee" AllowFilteringByColumn="True" Skin="Web20"
                    AllowSorting="True" AllowPaging="true" PageSize="100" runat="server" AutoGenerateColumns="False"
                    OnNeedDataSource="grdOpenItemsByAssignee_NeedDataSource" ShowStatusBar="true"
                    EnableLinqExpressions="false" Width="900px" Height="255px" OnExcelMLExportRowCreated="grdWorkItemsAssignee_ExcelMLExportRowCreated">
                    <ExportSettings FileName="OpenItemsAssignee" IgnorePaging="True" OpenInNewWindow="True"
                        ExportOnlyData="true" Excel-Format="ExcelML">
                    </ExportSettings>
                    <MasterTableView CommandItemDisplay="Bottom" AllowNaturalSort="false" UseAllDataFields="true"
                        AllowPaging="true">
                        <CommandItemSettings ShowExportToExcelButton="true" ShowAddNewRecordButton="false"
                            ShowRefreshButton="false" />
                        <Columns>
                            <telerik:GridBoundColumn DataField="AssigneeName" HeaderText="Assignee" UniqueName="AssigneeName"
                                >
                                <HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" />
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="RadComboBoxTitle" DataTextField="value" DataValueField="value"
                                        AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("AssigneeName").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="AssigneeIndexChanged" Width="145px"
                                        DataSource="<%# GenerateComboBoxAssigneesJuris() %>">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
  
                                        <script type="text/javascript">
                                    function AssigneeIndexChanged(sender,args) {
                                        var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("AssigneeName",args.get_item().get_value(),"EqualTo");
                                          
                                    }
                                        </script>
  
                                    </telerik:RadScriptBlock>
                                </FilterTemplate>
                            </telerik:GridBoundColumn>           
                            <telerik:GridBoundColumn DataField="StateName" HeaderText="State" UniqueName="StateName"
                                ItemStyle-HorizontalAlign="Center">
                                <HeaderStyle Font-Bold="True" Width="60px" HorizontalAlign="Center" Font-Names="Arial" />
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="RadComboBoxState" DataTextField="value" DataValueField="value"
                                        AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("StateName").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="StateIndexChanged1" Width="50px"
                                        DataSource="<%# ComboBoxAssigneeState() %>">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="RadScriptBlock2" runat="server">
  
                                        <script type="text/javascript">
                                    function StateIndexChanged1(sender,args) {
                                        var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("StateName",args.get_item().get_value(),"EqualTo");
                                          
                                    }
                                        </script>
  
                                    </telerik:RadScriptBlock>
                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <telerik:GridTemplateColumn DataField="JurisdictionCount" HeaderText="Jurisdictions"
                                UniqueName="JurisdictionCount" SortExpression="JurisdictionCount" AllowFiltering="false"
                                ItemStyle-HorizontalAlign="Center">
                                <HeaderStyle Font-Bold="True" Width="100px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lbJurisdictionAssignee" runat="server" Text='<%# Eval("JurisdictionCount", "{0:N0}")%>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="TotalItems" HeaderText="Total Items" UniqueName="TotalItems"
                                SortExpression="TotalItems" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="75px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lblTotalItemsAssignee" runat="server" Text='<%# Eval("TotalItems", "{0:N0}") %>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="OpenItemsCount" HeaderText="Still Open" UniqueName="OpenItemsCount"
                                SortExpression="OpenItemsCount" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="75px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lbStillOpenAssignee" runat="server" Text='<%# Eval("OpenItemsCount", "{0:N0}") %>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="UnworkableItemsCount" HeaderText="Unworkable"
                                UniqueName="UnworkableItemsCount" SortExpression="UnworkableItemsCount" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="105px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lblUnworkableAssignee" runat="server" Text='<%# Eval("UnworkableItemsCount", "{0:N0}") %>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="WorkableItemsCount" HeaderText="Workable"
                                UniqueName="WorkableItemsCount" SortExpression="WorkableItemsCount" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="105px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lblWorkableAssignee" runat="server" Text='<%# Eval("WorkableItemsCount", "{0:N0}") %>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="PercentComplete" HeaderText="% Complete" UniqueName="PercentComplete"
                                SortExpression="PercentComplete" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lblPctCompleteAssignee" runat="server" Text='<%# Eval("PercentComplete", "{0:F2}%")%>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                        </Columns>
                    </MasterTableView>
                    <HeaderStyle BorderStyle="Solid" />
                    <ClientSettings>
                        <Scrolling AllowScroll="True" UseStaticHeaders="True" />
                    </ClientSettings>
                </telerik:RadGrid>
            </div>
            <br />
            <div style="left: 5px; position: relative; left: 5px;">
                <asp:Label ID="Label13" runat="server" Font-Bold="True" Font-Size="Large" Font-Names="Arial">Open Items by Jurisdiction</asp:Label>
                <telerik:RadGrid ID="grdOpenItemsByJurisdiction" AllowFilteringByColumn="True" Skin="Web20"
                    AllowSorting="True" AllowPaging="true" PageSize="100" runat="server" AutoGenerateColumns="False"
                    OnNeedDataSource="grdOpenItemsByJurisdiction_NeedDataSource" ShowStatusBar="true" HeaderStyle-Width="900px"
                    EnableLinqExpressions="false" Width="900px" Height="255px" OnExcelMLExportRowCreated="grdWorkItemsJurisdiction_ExcelMLExportRowCreated">
                    <ExportSettings FileName="WorkItemsJurisdiction" IgnorePaging="True" OpenInNewWindow="True"
                        ExportOnlyData="true" Excel-Format="ExcelML">
                    </ExportSettings>
                    <MasterTableView CommandItemDisplay="Bottom" AllowNaturalSort="false" UseAllDataFields="true">
                        <CommandItemSettings ShowExportToExcelButton="true" ShowAddNewRecordButton="false"
                            ShowRefreshButton="false" />
                        <Columns>
                          <telerik:GridBoundColumn DataField="Assignee" HeaderText="Assignee" UniqueName="Assignee">
                                <HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" />
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="RadComboBoxTitle" DataTextField="Value" DataValueField="Value"
                                        AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("Assignee").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="TitleIndexChanged1" Width="145px"
                                        DataSource="<%# GenerateComboBoxAssigneesJuris() %>">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
  
                                        <script type="text/javascript">
                                    function TitleIndexChanged1(sender,args) {
                                        var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("Assignee",args.get_item().get_value(),"EqualTo");
                                          
                                    }
                                        </script>
  
                                    </telerik:RadScriptBlock>
                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="State" HeaderText="State" UniqueName="State"
                                ItemStyle-HorizontalAlign="Center">
                                <HeaderStyle Font-Bold="True" Width="60px" HorizontalAlign="Center" Font-Names="Arial" />
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="RadComboBoxState" DataTextField="value" DataValueField="value"
                                        AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("State").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="StateIndexChanged2" Width="50px"
                                        DataSource="<%# ComboBoxAssigneeState() %>">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="RadScriptBlock3" runat="server">
  
                                        <script type="text/javascript">
                                    function StateIndexChanged2(sender,args) {
                                        var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("State",args.get_item().get_value(),"EqualTo");
                                          
                                    }
                                        </script>
  
                                    </telerik:RadScriptBlock>
                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="WorkStatus" HeaderText="Work Status" UniqueName="WorkStatus"
                                ItemStyle-HorizontalAlign="Center">
                                <HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" />
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="RadComboWorkStatus" DataTextField="value" DataValueField="value"
                                        AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("WorkStatus").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="WorkIndexChanged" Width="150px"
                                        DataSource="<%# ComboBoxWorkStatus() %>">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="RadScriptBlock4" runat="server">
  
                                        <script type="text/javascript">
                                    function WorkIndexChanged(sender,args) {
                                        var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("WorkStatus",args.get_item().get_value(),"EqualTo");
                                          
                                    }
                                        </script>
  
                                    </telerik:RadScriptBlock>
                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <%-- <telerik:GridTemplateColumn DataField="State" HeaderText="State" UniqueName="State"
                                        SortExpression="State" AllowFiltering="false" Visible="true">
                                        <HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" />
                                        <ItemTemplate>
                                            <asp:Label ID="lbState" runat="server" Text='<%# Eval("State") %>'></asp:Label>
                                        </ItemTemplate>
                                        <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                                    </telerik:GridTemplateColumn>--%>
                            <telerik:GridTemplateColumn DataField="JurisdictionELD" HeaderText="ELD" UniqueName="ELD"
                                SortExpression="JurisdictionELD" AllowFiltering="false" ItemStyle-HorizontalAlign="Center">
                                <HeaderStyle Font-Bold="True" Width="60px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lbELD" runat="server" Text='<%# Eval("JurisdictionELD", "{0:M/yy}")%>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Center" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridBoundColumn DataField="Jurisdiction" HeaderText="Jurisdiction" UniqueName="Jurisdiction"
                                ItemStyle-HorizontalAlign="Center">
                                <HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" />
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="RadComboJurisdiction" DataTextField="value" DataValueField="value"
                                        AppendDataBoundItems="true" runat="server" OnClientSelectedIndexChanged="JurisIndexChanged"
                                        Width="150px" DataSource="<%# ComboBoxJurisdictions() %>">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="RadScriptBlock5" runat="server">
  
                                        <script type="text/javascript">
                                    function JurisIndexChanged(sender,args) {
                                        var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("Jurisdiction",args.get_item().get_value(),"EqualTo");
                                          
                                    }
                                        </script>
  
                                    </telerik:RadScriptBlock>
                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="ProcurementMethod" HeaderText="Proc Meth" UniqueName="ProcurementMethod"
                                ItemStyle-HorizontalAlign="Center">
                                <HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" />
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="RadComboProcMeth" DataTextField="Description" DataValueField="Description"
                                        AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("ProcurementMethod").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="ProcIndexChanged" Width="150px"
                                        DataSource="<%# GenerateProcMeth() %>">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="RadScriptBlock6" runat="server">
  
                                        <script type="text/javascript">
                                    function ProcIndexChanged(sender,args) {
                                        var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("ProcurementMethod",args.get_item().get_value(),"EqualTo");
                                          
                                    }
                                        </script>
  
                                    </telerik:RadScriptBlock>
                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <telerik:GridTemplateColumn DataField="PercentComplete" HeaderText="% Complete" UniqueName="clmPctComplete"
                                SortExpression="PercentComplete" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lblPctCompleteAssignee" runat="server" Text='<%# Eval("PercentComplete", "{0:F2}%")%>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="TotalItems" HeaderText="Total Items" UniqueName="TotalItems"
                                SortExpression="TotalItems" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="100px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lblTotalItemsAssignee" runat="server" Text='<%# Eval("TotalItems", "{0:N0}") %>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="StillOpenCount" HeaderText="Still Open" UniqueName="StillOpen"
                                SortExpression="StillOpenCount" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="100px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lbStillOpenAssignee" runat="server" Text='<%# Eval("StillOpenCount", "{0:N0}") %>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="UnworkableItemsCount" HeaderText="Unworkable"
                                UniqueName="Unworkable" SortExpression="UnworkableItemsCount" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="105px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lblUnworkableAssignee" runat="server" Text='<%# Eval("UnworkableItemsCount", "{0:N0}") %>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridTemplateColumn DataField="WorkableItemsCount" HeaderText="Workable"
                                UniqueName="WorkableItemsCount" SortExpression="WorkableItemsCount" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="105px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lblWorkableAssignee" runat="server" Text='<%# Eval("WorkableItemsCount", "{0:N0}") %>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridBoundColumn DataField="IsLR" HeaderText="LR" UniqueName="IsLR" 
                                ItemStyle-HorizontalAlign="Center" SortExpression="IsLR">
                                <HeaderStyle Font-Bold="True" Width="60px" HorizontalAlign="Center" Font-Names="Arial" />
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="RadComboBoxLR" DataTextField="value" DataValueField="value"
                                        AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("IsLR").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="LRIndexChanged" Width="50px" DataSource="<%# ComboYesNo() %>">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="RadScriptBlock7" runat="server">
  
                                        <script type="text/javascript">
                                    function LRIndexChanged(sender,args) {
                                        var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("IsLR",args.get_item().get_value(),"EqualTo");
                                          
                                    }
                                        </script>
  
                                    </telerik:RadScriptBlock>
                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="IsHOA" HeaderText="HOA" UniqueName="IsHOA"
                                ItemStyle-HorizontalAlign="Center" SortExpression="isHOA">
                                <HeaderStyle Font-Bold="True" Width="60px" HorizontalAlign="Center" Font-Names="Arial" />
                                <FilterTemplate>
                                    <telerik:RadComboBox ID="RadComboBoxHOA" DataTextField="value" DataValueField="value"
                                        AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("IsHOA").CurrentFilterValue %>'
                                        runat="server" OnClientSelectedIndexChanged="HOAIndexChanged" Width="50px" DataSource="<%# ComboYesNo() %>">
                                        <Items>
                                            <telerik:RadComboBoxItem Text="All" />
                                        </Items>
                                    </telerik:RadComboBox>
                                    <telerik:RadScriptBlock ID="RadScriptBlock8" runat="server">
  
                                        <script type="text/javascript">
                                    function HOAIndexChanged(sender,args) {
                                        var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
                                        tableView.filter("IsHOA",args.get_item().get_value(),"EqualTo");
                                          
                                    }
                                        </script>
  
                                    </telerik:RadScriptBlock>
                                </FilterTemplate>
                            </telerik:GridBoundColumn>
                            <telerik:GridTemplateColumn DataField="TSPayeeCode" HeaderText="TS Payee" UniqueName="TSPayee"
                                SortExpression="TSPayeeCode" AllowFiltering="false">
                                <HeaderStyle Font-Bold="True" Width="105px" HorizontalAlign="Center" Font-Names="Arial" />
                                <ItemTemplate>
                                    <asp:Label ID="lblTSPayee" runat="server" Text='<%# Eval("TSPayeeCode", "{0:N0}") %>'></asp:Label>
                                </ItemTemplate>
                                <ItemStyle HorizontalAlign="Right" ForeColor="Black" />
                                <FooterStyle HorizontalAlign="Right" Font-Bold="true" />
                            </telerik:GridTemplateColumn>
                            <telerik:GridBoundColumn DataField="AssigneeEmployeeKey" ReadOnly="True" UniqueName="AssigneeEmployeeKey"
                                Visible="False">
                            </telerik:GridBoundColumn>
                        </Columns>
                    </MasterTableView>
                    <HeaderStyle BorderStyle="Solid" />
                    <ClientSettings>
                        <Scrolling AllowScroll="True" UseStaticHeaders="True" />
                    </ClientSettings>
                </telerik:RadGrid>
            </div>
        </asp:Panel>
    </asp:Panel>
    </form>
</body>
</html>
Any help would be appreciated.

1 Answer, 1 is accepted

Sort by
0
Iana Tsolova
Telerik team
answered on 23 Aug 2011, 09:43 AM
Hi,

Could you please confirm that you have not enabled custom paging for the grid and that you are assigning all data to the grid DataSource, not only the records which should be displayed in the current page?

Greetings,
Iana
the Telerik team

Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's DevProConnections Awards. We are competing in mind-blowing 20 categories and every vote counts! VOTE for Telerik NOW >>

Tags
Grid
Asked by
New User
Top achievements
Rank 1
Answers by
Iana Tsolova
Telerik team
Share this question
or