Losing pager after exporting

13 posts, 1 answers
  1. Lasly
    Lasly avatar
    115 posts
    Member since:
    Nov 2009

    Posted 14 Dec 2010 Link to this post

    Hi,

    I've a problem when try to exporting my radgrid with excel button.
    When exporting the data, page loses the pager.

    Data was exported successfully.

    How can i resolve this problem?

    Thanks
    Regards
  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 14 Dec 2010 Link to this post

    Hello,

    Check whether you have set the ExportOnlyData property as 'true' which in turn excludes the controls from the exported file. If so set it as 'false' and check if it works now.

    ASPX:
    <ExportSettings ExportOnlyData="false"></ExportSettings>

    -Shinu.

  3. Daniel
    Admin
    Daniel avatar
    4949 posts

    Posted 14 Dec 2010 Link to this post

    Hello Martini,

    You can export the pager item if ExportOnlyData is set to false. Best results can be achieved when PagerMode is set to Slider because you will get plain text only.
    <ExportSettings ExportOnlyData="false" />
    <PagerStyle Mode="Slider" />

    Regards,
    Daniel
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
  4. Lasly
    Lasly avatar
    115 posts
    Member since:
    Nov 2009

    Posted 17 Dec 2010 Link to this post

    My problem has no in the Excel file but in the ASP page.

    My pager disappears in the ASP page after exporting and do not disappears in the Excel file.

    My Exporting is correct, it is page that behaves strange.



    Can you help me?

    Regards
    Thanks

  5. Daniel
    Admin
    Daniel avatar
    4949 posts

    Posted 17 Dec 2010 Link to this post

    Hello Martini,

    Could you please post your code in this thread? I would like to examine you approach, if possible.

    Best regards,
    Daniel
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
  6. Lasly
    Lasly avatar
    115 posts
    Member since:
    Nov 2009

    Posted 20 Dec 2010 Link to this post

    Hello Daniel
    This is the asp page, my radgrid is inside a radajaxpanel.
    01.<telerik:RadAjaxPanel ID="panelRGricerca" runat="server">
    02. <table id="tblDati" runat="server" width="99%" height="90%" align="center">
    03.  <tr>
    04.   <td width="10">
    05.    &nbsp;
    06.   </td>
    07.   <td valign="top">
    08.    <div style="overflow: auto; height: 100%; width: 100%;" id="divRicerca">
    09.     <telerik:RadGrid ID="grdRicerca" runat="server" Skin="Default" AutoGenerateColumns="false"
    10.      EnableViewState="true" AllowPaging="true" OnNeedDataSource="grdRicerca_OnNeedDataSource"
    11.      Width="99%" AllowSorting="true">
    12.      <PagerStyle AlwaysVisible="false" Mode="NumericPages" ShowPagerText="false" />
    13.      <ExportSettings IgnorePaging="true" OpenInNewWindow="true" ExportOnlyData="true">
    14.       <Pdf PageBottomMargin="1cm" PageLeftMargin="1cm" PageRightMargin="1cm" PageTopMargin="1cm"
    15.        PageWidth="297mm" PageHeight="210mm" FontType="Subset" />
    16.      </ExportSettings>
    17.      <MasterTableView PageSize="10" EnableViewState="true" AllowPaging="true" AllowSorting="true"
    18.       ShowHeadersWhenNoRecords="false" CommandItemDisplay="Top">
    19.       <NoRecordsTemplate>
    20.        <asp:Image runat="server" ID="imgNoRecord" ImageUrl="images/__banner.jpg" />
    21.        <br />
    22.        <asp:Label runat="server" ForeColor="Red" Font-Bold="true" ID="noRecord" Text="Non sono presenti dati con i criteri di ricerca immessi."></asp:Label>
    23.       </NoRecordsTemplate>
    24.       <Columns>
    25.        <telerik:GridHyperLinkColumn HeaderText="Codice UE" DataTextField="IdUe" DataTextFormatString="{0}"
    26.         DataNavigateUrlFields="IdUe, TipologiaUe" DataNavigateUrlFormatString="?target=details&args={0},{1}">
    27.        </telerik:GridHyperLinkColumn>
    28.        <telerik:GridBoundColumn HeaderText="Denominazione" DataField="Denominazione">
    29.        </telerik:GridBoundColumn>
    30.        <telerik:GridBoundColumn HeaderText="Descrizione" DataField="DescrizioneUE">
    31.        </telerik:GridBoundColumn>
    32.        <telerik:GridBoundColumn HeaderText="Regione" DataField="REGIONE">
    33.        </telerik:GridBoundColumn>
    34.        <telerik:GridBoundColumn HeaderText="Provincia" DataField="PROVINCIA">
    35.        </telerik:GridBoundColumn>
    36.        <telerik:GridBoundColumn HeaderText="Comune" DataField="COMUNE">
    37.        </telerik:GridBoundColumn>
    38.        <telerik:GridBoundColumn HeaderText="Indirizzo" DataField="Indirizzo">
    39.        </telerik:GridBoundColumn>
    40.        <telerik:GridHyperLinkColumn ItemStyle-HorizontalAlign="Center" HeaderText="" DataTextField="IdUe"
    41.         DataTextFormatString="<img height='16' widhth='16' src='images/dwf.gif' border='0' title='Visualizza in Gestione Spazi' alt='Planimetria' />"
    42.         DataNavigateUrlFields="IdUe, TipologiaUe" DataNavigateUrlFormatString="?target=planimetria&args={0},{1}">
    43.        </telerik:GridHyperLinkColumn>
    44.       </Columns>
    45.       <CommandItemSettings ShowExportToExcelButton="true" ShowRefreshButton="false" ShowAddNewRecordButton="false" />   
    46.      </MasterTableView>
    47.     </telerik:RadGrid>
    48.    </div>
    49.   </td>
    50.   <td width="10">
    51.    &nbsp;
    52.   </td>
    53.  </tr>
    54. </table>
    55.</telerik:RadAjaxPanel>

    This is the javascript function who allow to export in excel, word or pdf format:
    1.function onRequestStart(sender, args) {
    2.   if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0 || 
    3.       args.get_eventTarget().indexOf("ExportToWordButton") >= 0 ||       
    4.       args.get_eventTarget().indexOf("ExportToCsvButton") >= 0) {
    5.          args.set_enableAjax(false);
    6.   }
    7.}


    In the code behind I'm using the need data source event to bind the data from database.
    My problem appears after exported the data and try to click on a control into radgrid.

    If I reload the page, the control behaves right.

    I'm using RadAjaxManager to update the radajaxpanel when click on a control inside the radgrid.

    I think that the problem is during the exporting when I call the method set_enableAjax(false).

    Perhaps the control radgrid lose some property during this process...

    Best regards.

  7. Daniel
    Admin
    Daniel avatar
    4949 posts

    Posted 22 Dec 2010 Link to this post

    Hello Martini,

    Thank you for the sample code. I believe the problem is caused due to the fact that you are ajaxifying RadGrid two times. I recommend that you replace the RadAjaxPanel with regular ASP.NET Panel control.

    Let me know if the problem still persists.

    Kind regards,
    Daniel
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
  8. Lasly
    Lasly avatar
    115 posts
    Member since:
    Nov 2009

    Posted 24 Dec 2010 Link to this post

    Hi,

      I've tired to use ASP.NET UpdatePanel and Panel but the problems can not resolve.

    During this work I've found a page who doesn't use Panel, and the problem with exporting doesn't disappears.

    Now I try to export the data in the server-side.

     I don't understand how in your example the pager doesn't disappears, maybe I've wrong anything during the designing step.

    Thanks

  9. Answer
    Daniel
    Admin
    Daniel avatar
    4949 posts

    Posted 24 Dec 2010 Link to this post

    Hello Martini,

    I attached a sample project that demonstrates how to export RadGrid when residing in ajaxified container. Please test it locally and let me know if I can assist you further.

    Below, you can find the code that cancels the AJAX request when exporting:
    Sys.WebForms.PageRequestManager.getInstance().add_initializeRequest(initializeRequestHandler);
    function initializeRequestHandler(sender, args)
    {
        if (args.get_postBackElement().id.indexOf("Export") != -1)
        {
            args.set_cancel(true);
            sender._form["__EVENTTARGET"].value = args.get_postBackElement().id.replace(/\_/g, "$");
            sender._form["__EVENTARGUMENT"].value = "";
            sender._form.submit();
            return;
        }
    }

    Regards,
    Daniel
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
  10. Ibsa
    Ibsa avatar
    4 posts
    Member since:
    Jul 2012

    Posted 30 Jul 2012 Link to this post

    Hi, Martini, Telerik team, have you found a solution to this issue please? I am having the same exact problem and I can't seem to get it resolved. I downloaded the project file attached at the end if this thread and tried to no avail to get paging/sorting/filtering working once export button is clicked. I am working on an application page on SharePoint 2010 with "RadControls for ASP.NET AJAX Q1 2011" installed. 

    Thanks,
    Ibsa
  11. Lasly
    Lasly avatar
    115 posts
    Member since:
    Nov 2009

    Posted 31 Jul 2012 Link to this post

    Hi ibsa,

    I hope to help you. (It's been a long time)

    the solution is the following function:

    / / Handle the ajax request generated inside a RadAjaxPanel
    OnRequestStart function (sender, args) {
         / / Blocking asynchronous requests and force a full postback
       
         if (args.get_eventTarget (). indexOf ("ExportToExcelButton")! = -1 | |
             args.get_eventTarget (). indexOf ("ExportToWordButton")! = -1 | |
             args.get_eventTarget (). indexOf ("ExportToCsvButton")! = -1 | |
             args.get_eventTarget (). indexOf ("ExportToPdfButton")! = -1
           
             )
            
            
             {
             args.set_enableAjax (false);
         }
      
    }
    you have to call from your RadAjaxManager.     
    <telerik:RadAjaxManager ID="ajaxManager" runat="server">
           <ClientEvents OnRequestStart="OnRequestStart" />
       </telerik:RadAjaxManager>
        
    if it does not work, let me know .. that we try again together.

    Lasly.

  12. Ibsa
    Ibsa avatar
    4 posts
    Member since:
    Jul 2012
  13. Omar
    Omar avatar
    2 posts
    Member since:
    Nov 2017

    Posted 13 Nov 2017 Link to this post

    Hello

    I'm having a similar issue.

    My RadGrid is in an asp panel, within a content page, which at the same time is within a master page. Unfortunately, whenever i click on the ExportToCsvButton, the csv is working and downloading properly, but at the end a _blank page is being shown and no more than that.

    Have already implemented the set_enableAjax(false) solution, but is not working. Hope you may help me out with this.

    Best Regards

Back to Top