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

IgnorePaging not work

1 Answer 143 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Marcelo
Top achievements
Rank 1
Marcelo asked on 14 Feb 2011, 09:55 PM
Hi, a have a problem with IgnorePaging="true" is not exporting all the pages to excel.
This is my code

<telerik:RadSlidingPane ID="RadSlidingPane2" runat="server" Title="Elementos Georeferenciados" Width="600px" EnableDock="false">
 <telerik:RadAjaxPanel ID="RadAjaxPanel2" runat="server" ClientEvents-OnRequestStart="pnlRequestStarted">
  <telerik:RadGrid ID="gridTematico" runat="server" AllowSorting="True" GridLines="None" Skin="Office2007" AllowFilteringByColumn="True" AllowPaging="True" PageSize="50" OnItemDataBound="gridTematico_ItemDataBound" OnColumnCreated="gridTematico_ColumnCreated" OnCancelCommand="gridTematico_CancelCommand" OnEditCommand="gridTematico_EditCommand" OnSelectedIndexChanged="gridTematico_SelectedIndexChanged" OnUpdateCommand="gridTematico_UpdateCommand">
   <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>
   <MasterTableView CommandItemDisplay="Bottom" ShowFooter="True" ShowGroupFooter="True" UseAllDataFields="True">
    <Columns>
     <telerik:GridTemplateColumn UniqueName="TemplateColumn" HeaderText="NÂș" AllowFiltering="False" FilterControlAltText="Filter TemplateColumn column">
      <ItemTemplate>
       <asp:Label ID="fila" runat="server" Width="30px" />
      </ItemTemplate>
      <HeaderStyle Width="30px" Font-Size="X-Small" Font-Bold="True" />
     </telerik:GridTemplateColumn>
     <telerik:GridEditCommandColumn ButtonType="ImageButton" FilterControlAltText="Filter EditCommandColumn column"></telerik:GridEditCommandColumn>
    </Columns>
    <CommandItemSettings RefreshText="Actualizar" ShowAddNewRecordButton="False" />
    <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>
    <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>
     <EditFormSettings>
      <EditColumn ButtonType="ImageButton" FilterControlAltText="Filter EditCommandColumn column" UniqueName="EditCommandColumn1"></EditColumn>
     </EditFormSettings>
    </MasterTableView>
    <ClientSettings EnablePostBackOnRowClick="True">
     <Selecting AllowRowSelect="True" />
    </ClientSettings>
    <FilterMenu EnableImageSprites="False"></FilterMenu>
    <ExportSettings ExportOnlyData="True" FileName="ElementosGeoreferenciados" IgnorePaging="True" OpenInNewWindow="True">
     <Csv ColumnDelimiter="Semicolon" />
    </ExportSettings>
   </telerik:RadGrid>
   <table>
   <tr>
    <td style="width: 32px;">
     <asp:ImageButton ID="btnExcel" runat="server" ImageUrl="~/images/iconos/File_Excel.png" ToolTip="Exportar a Excel" Visible="False" OnClick="btnExcel_Click" Width="32px" Height="32px" />
    </td>
    <td style="width: 32px;">
     <asp:ImageButton ID="btnCsv" runat="server" ImageUrl="~/images/iconos/File_Csv.png" ToolTip="Exportar a csv" Visible="False" OnClick="btnCsv_Click" Width="32px" Height="32px" />
    </td>
    <td style="width: 32px;">
     <asp:ImageButton ID="btnWord" runat="server" ImageUrl="~/images/iconos/File_Word.png" ToolTip="Exportar a Word" Visible="False" OnClick="btnWord_Click" Width="32px" Height="32px" />
    </td>
   </tr>
   </table>
  </telerik:RadAjaxPanel>
</telerik:RadSlidingPane>

<telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
 <script type="text/javascript">
  function pnlRequestStarted(ajaxPanel, eventArgs)
  {
   if((eventArgs.EventTarget.indexOf("btnExcel")!=-1)||(eventArgs.EventTarget.indexOf("btnCsv")!=-1)||(eventArgs.EventTarget.indexOf("btnWord")!=-1))
    eventArgs.EnableAjax = false;
  }
 </script>
</telerik:RadScriptBlock>

protected void btnExcel_Click(object sender, ImageClickEventArgs e)
{
 gridTematico.ExportSettings.IgnorePaging = true;
 gridTematico.ExportSettings.ExportOnlyData = true;
 gridTematico.ExportSettings.OpenInNewWindow = true;
 gridTematico.MasterTableView.ExportToExcel();
}

1 Answer, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 15 Feb 2011, 10:52 AM
Hello Marcelo,

The code is working on my end when i am using AdvancedDataBinding. I guess you are using Simple Data Binding. If that the case I suggest you to use Grid / Advanced Data Binding (using NeedDataSource event) to get the complete grid items when exporting.

Hope this information helps,
Princy.


Tags
Grid
Asked by
Marcelo
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Share this question
or