[Solved] Export Grid with Rad Combobox Filters

[Hala Malkawi]

Hello,
I'm using Telerik Rad Grid (RadControls 'Prometheus' for ASP.NET Q1 2008RadControls 'Prometheus' for ASP.NET Q1 2008), and i'm trying to export the data by image buttons in grid command item, and the grid has filters (filter cell has Rad Combobox), every thing is working fine except that after export completed the filter combobox doesn't work at all, even it can be selected by the cursor.

any help Please,

Thanks in advance.

[Princy]

Hello Hala,

Have you by any chance ajaxified your Grid? The filtering menu might not appear after exporting for certain scenarios. Here's the link to a KB article which explains more on this regard.
Filtering Menu fails to display after Export from AJAXified Grid

Thanks
Princy.

[Hala Malkawi]

unfortunately this solution doesn't work and also i've tried all attached examples, but no Luck :(

in my page not only the grid filters(combobox and filter menu) don't open, also any Rad Combobox at the page even it is not attached to radmanager in Ajax settings.

[Daniel]

Hello Hala,

Please post your markup here so we can get a better picture about your scenario.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Hala Malkawi]

in aspx page (content page) and the rad manager at the page but the RadScriptManager in master page

Master Page markup

<telerik:RadScriptManager ID="RadScriptManager1" runat="server" EnableScriptCombine="true"
            AsyncPostBackTimeout="10000">
        </telerik:RadScriptManager>

in content page

<telerik:RadCodeBlock runat="server" ID="RadCodeBlock1">

    <script type="text/javascript">


    function onRequestStart(sender, args)
   {
       if (args.get_eventTarget().indexOf("btnExport") >= 0)
       {
           args.EnableAjax = false;
      }
   }
    </script>
    </telerik:RadCodeBlock>

    <telerik:RadAjaxManager ID="FoodQuickSearchAjaxManager" runat="server"  ClientEvents-OnRequestStart="onRequestStart">
    <AjaxSettings>
    <telerik:AjaxSetting AjaxControlID="trgResults">
    <UpdatedControls>
    <telerik:AjaxUpdatedControl ControlID="trgResults" LoadingPanelID="RadAjaxLoadingPanel1" />
    <telerik:AjaxUpdatedControl ControlID="lblResultsNo" />
    <telerik:AjaxUpdatedControl ControlID="lblSearchTerm" />
    </UpdatedControls>
    </telerik:AjaxSetting>
    <telerik:AjaxSetting AjaxControlID="btnRfrshRslts">
    <UpdatedControls>
    <telerik:AjaxUpdatedControl ControlID="trgResults" LoadingPanelID="RadAjaxLoadingPanel1" />
    <telerik:AjaxUpdatedControl ControlID="lblResultsNo" />
    <telerik:AjaxUpdatedControl ControlID="lblSearchTerm" />
    </UpdatedControls>
    </telerik:AjaxSetting>
    </AjaxSettings>
    </telerik:RadAjaxManager>
<table>
                    <tr>
                        <td align="right">
                            <asp:Label ID="lblQuickSrch" runat="server" Font-Bold="True"></asp:Label>&nbsp;
                        </td>
                        <td>
                            <telerik:RadComboBox ID="rcbSearchItems" runat="server" Skin="Outlook" DropDownWidth="220px" Width="230px">
                                <CollapseAnimation Duration="200" Type="OutQuint" />
                            </telerik:RadComboBox>
                        </td>
</tr>
<tr>
                        <td>
                            <div id="divTrgResults" runat="server" style="overflow-x: scroll; width: 930px; position: relative;">
                                <telerik:RadGrid ID="trgResults" Width="100%" OnLoad="trgResults_Load" runat="server" AllowPaging="True" PageSize="50" Font-Bold="False" GridLines="None" ShowFooter="True" AllowSorting="True" AllowFilteringByColumn="True" OnItemCreated="trgResults_ItemCreated" OnItemDataBound="trgResults_ItemDataBound" OnPageIndexChanged="trgResults_PageIndexChanged" AutoGenerateColumns="False" GroupingEnabled="False" OnSortCommand="trgResults_SortCommand" OnNeedDataSource="trgResults_NeedDataSource" OnInit="trgResults_Init" OnItemCommand="trgResults_ItemCommand">
                                <ExportSettings ExportOnlyData="True" OpenInNewWindow="True">
                                </ExportSettings>
                                    <MasterTableView Font-Bold="False" CommandItemDisplay="Top" Font-Overline="False" AllowCustomPaging="True" AllowCustomSorting="True" AllowNaturalSort="False">
                                        <CommandItemTemplate>
                                            <table>
                                                <tr>
                                                    <td style="width:30%">
                                                        <div style="float: left;">
                                                            <span style="color: White; font-weight: bold; vertical-align: middle;">EXPORT TO:</span>            <asp:ImageButton ID="btnExportToWord" CommandName="ExportToWord" OnClientClick="javascript:ExportGrid();return false;" ImageAlign="Middle" Style="cursor: pointer;" ImageUrl="/images/icon_dl_word.gif" AlternateText="Export to Word" Width="16px" Height="16px" runat="server"/>
                                                            <asp:ImageButton ID="btnExportToExcel" CommandName="ExportToExcel" ImageAlign="Middle" Style="cursor: pointer;" ImageUrl="/images/icon_dl_excel.gif" AlternateText="Export to Excel" Width="16px" Height="16px" runat="server"></asp:ImageButton>
                                                            <asp:ImageButton ID="btnExportToCSV" ImageAlign="Middle" Style="cursor: pointer;" ImageUrl="/images/icon_dl_txt.gif" AlternateText="Export to CSV" CommandName="ExportToCSV" Width="16px" Height="16px" runat="server"></asp:ImageButton>
                                                            <span style="color: White; font-weight: bold; vertical-align: middle;">&nbsp;&nbsp;&nbsp;Please use CSV for 3000 records and up.</span>
                                                        </div>
                                                    </td>
                                                </tr>
                                            </table>
                                        </CommandItemTemplate>
                                        <SortExpressions>
                                            <telerik:GridSortExpression FieldName="Name" />
                                        </SortExpressions>
                                        <EditFormSettings>
                                            <PopUpSettings ScrollBars="None" />
                                        </EditFormSettings>
                                        <Columns>
                                            <telerik:GridCheckBoxColumn UniqueName="checkCol" AllowFiltering="False" Resizable="False" Visible="False">
                                                <HeaderStyle Font-Bold="False" BackColor="Silver" />
                                            </telerik:GridCheckBoxColumn>
                                            <telerik:GridBoundColumn DataField="Id" UniqueName="idCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="Level" UniqueName="lvlCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="CountryName" UniqueName="cntryCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="ContextId" UniqueName="cntxtIdCol" Visible="False" AllowFiltering="False" AllowSorting="False">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="ContextName" UniqueName="cntxtCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="SearchType" UniqueName="itmTypeCol" Visible="False">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="Name" UniqueName="itmNameCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="SupplierName" UniqueName="supplierCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="BrandName" UniqueName="brandCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="SubBrandName" UniqueName="subbrandCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="HSCategoryName" UniqueName="hsCategoryCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridTemplateColumn UniqueName="hsColorCol" DataField="HSColorId" SortExpression="HSColorId">
                                                <ItemTemplate>
                                                    <asp:Image runat="server" ID="imgColor" />
                                                    <asp:Label runat="server" ID="lblNAColor"></asp:Label>
                                                </ItemTemplate>
                                            </telerik:GridTemplateColumn>
                                            <telerik:GridBoundColumn DataField="HSValue" UniqueName="hsValueCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="LastEditedBy" UniqueName="lstEdtByCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="LastEditedDate" UniqueName="lstEdtDateCol" DataFormatString="{0:dd-MMM- yyyy}" DataType="System.DateTime">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="WorkFlowState" UniqueName="statusCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="IsObsolete" UniqueName="isobsoleteCol">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn DataField="ProductType" UniqueName="ProductTypeCol" Visible="False">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridTemplateColumn UniqueName="EditCol" AllowFiltering="False">
                                                <ItemTemplate>
                                                    <asp:Image ImageUrl="~/Include/Img/Edit.gif" ID="EditImage" runat="server"></asp:Image>
                                                </ItemTemplate>
                                            </telerik:GridTemplateColumn>
                                        </Columns>
                                        <ExpandCollapseColumn Visible="False" Resizable="False">
                                            <HeaderStyle Width="20px" />
                                        </ExpandCollapseColumn>
                                        <RowIndicatorColumn Visible="False">
                                            <HeaderStyle Width="20px" />
                                        </RowIndicatorColumn>
                                    </MasterTableView>
                                    <GroupPanel ID="GroupPanel" Style="width: 100%;">
                                    </GroupPanel>
                                    <PagerStyle AlwaysVisible="True" Mode="NextPrevAndNumeric" PagerTextFormat="page: {4} &amp;nbsp;Displaying page {0} of {1}, items {2} to {3} of {5}." />
                                    <ClientSettings EnableRowHoverStyle="True">
                                        <Selecting AllowRowSelect="True" />
                                    </ClientSettings>

                                    <ItemStyle BackColor="White" BorderColor="White" />
                                    <FilterItemStyle BackColor="White" BorderColor="White" />

                                </telerik:RadGrid>
                            </td></tr></table>
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Transparency="30" CssClass="LoadingPanel_Hay">
    </telerik:RadAjaxLoadingPanel>

and at server side, only i'm adding radcomboboxes instead of textboxes for grid filtering cells, but for export there is nothing added.

I tried to override onprerender to override isInPostBack but nothing changed.

Thanks,

[Daniel]

Hello Hala,

The only thing I noticed is that your DIV (divTrgResults) doesn't have a closing tag. I created a simplified demo based on your code and it runs as expected on my end.  Please examine it on your end and let me know if I'm missing something.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.