Grid only exports when paging page 1 is selected.

[adam]

My problem is my radgrid only exports when the user selects page 1 on the rad grid.  ie. If user selects page 2 through infinity and then exports it the grid. The excel spreadsheet will have the column names but no data. But if the user is has paging page 1 selected it will export the entire data set.  I stumped.

I have attaced the code that I am using.  Thank you for any help

 

<

 

 

telerik:RadButton ID="RadBtnExport" CssClass="button" Width="150px" Text="Export to Excel" OnClick="RadBtnExport_Click" runat="server" Skin="WebBlue"></telerik:RadButton>

 

<

 

 

telerik:RadGrid ID="RadGridResults" runat="server"

 

 

 

AllowPaging="True" AllowSorting="True"

 

 

 

 

 

 

 

 

AllowFilteringByColumn="True" GridLines="None"

 

 

 

EnableLinqExpressions="False" PageSize="30" Width="900px" Skin="WebBlue"

 

 

 

 

 

 

 

 

EnableImageSprites="True" AllowCustomPaging="true" ExportSettings-ExportOnlyData="true"

 

 

 

 

 

 

 

 

AutoGenerateColumns="true" ExportSettings-IgnorePaging="true"

 

 

 

 

 

 

 

 

OnNeedDataSource="RadGridSearchResults_NeedDataSource" OnSortCommand="RadComboBoxReport_SortCommand">

 

 

 

 

 

 

 

 

<MasterTableView CommandItemDisplay="Top" CommandItemSettings-ShowAddNewRecordButton="false" CommandItemSettings-ShowRefreshButton="false" CommandItemSettings-ShowExportToExcelButton="true">

 

 

 

 

 

 

 

 

<RowIndicatorColumn>

 

 

 

 

 

 

 

 

<HeaderStyle Width="10px"></HeaderStyle>

 

 

 

 

 

 

 

 

</RowIndicatorColumn>

 

 

 

 

 

 

 

 

<ExpandCollapseColumn>

 

 

 

 

 

 

 

 

<HeaderStyle Width="10px"></HeaderStyle>

 

 

 

 

 

 

 

 

</ExpandCollapseColumn>

 

 

 

 

 

 

 

 

<PagerStyle Mode="NumericPages" AlwaysVisible="true"/>

 

 

 

 

 

 

 

 

<CommandItemSettings ShowExportToExcelButton="true" ShowAddNewRecordButton="false" />

 

 

 

 

 

 

 

 

</MasterTableView>

 

 

 

 

 

 

 

 

<ClientSettings>

 

 

 

 

 

 

 

 

<Scrolling AllowScroll="True" SaveScrollPosition="True">

 

 

 

 

 

 

 

 

</Scrolling>

 

 

 

 

 

 

 

 

</ClientSettings>

 

 

 

 

 

 

 

 

</telerik:RadGrid>

 

 

 

protected void RadBtnExport_Click(object sender, System.EventArgs e)

 

{

 

 

try

 

 

 

 

 

{

 

 

if (RadGridResults.Items.Count > 0)

 

{

RadGridResults.ExportSettings.ExportOnlyData =

 

true;

 

RadGridResults.ExportSettings.IgnorePaging =

 

true;

 

 

 

//call the method on export formatting

 

 

 

 

 

RadGridResults.ExcelExportCellFormatting +=

 

new Telerik.Web.UI.OnExcelExportCellFormattingEventHandler(RadGridResults_ExcelExportCellFormatting);

 

RadGridResults.MasterTableView.ExportToExcel();

}

}

 

 

catch (Exception ex)

 

{

 

 

StackTrace stackTrace = new StackTrace();

 

 

 

LogException.LogErrorMessage(ex, stackTrace.GetFrame(1).GetMethod().Name);

 

lblErrMsg.Text =

 

Messages.ReportExportError;

 

}

}

 

 

protected void RadGridResults_ExcelExportCellFormatting(object source, ExcelExportCellFormattingEventArgs e)

 

{

e.Cell.Style[

 

"mso-number-format"] = @"0000";

 

}

[Princy]

Hello Adam,

This is not the expected behavior when you have set IgnorePaging as true. Here is the full code that i tried which worked as expected.
aspx:

<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
  <telerik:RadGrid runat="server" ID="RadGrid1" AutoGenerateColumns="false" AllowPaging="true" PageSize="4" OnNeedDataSource="RadGrid1_NeedDataSource">
      <MasterTableView  CommandItemDisplay="Top">
          <Columns>
             <telerik:GridBoundColumn DataField="EmployeeID" UniqueName="EmployeeID">
             </telerik:GridBoundColumn>
             <telerik:GridBoundColumn DataField="FirstName" UniqueName="EmployeeCategory">
             </telerik:GridBoundColumn>
           </Columns>
      </MasterTableView>
   </telerik:RadGrid>
<telerik:RadButton ID="btn" runat="server" Text="Export" onclick="btn_Click"></telerik:RadButton>

C#:

protected void btn_Click(object sender, EventArgs e)
{
       RadGrid1.ExportSettings.ExportOnlyData = true;
       RadGrid1.ExportSettings.IgnorePaging = true;
       RadGrid1.MasterTableView.ExportToExcel();
}

Thanks,
Princy.