Trying to export my grid, exports entire aspx page instead

4 posts, 0 answers
  1. Jack Voss
    Jack Voss avatar
    27 posts
    Member since:
    May 2010

    Posted 30 Nov 2011 Link to this post

    Either grid on this page will, instead of exporting the grid and it's data, give me an export of the entire aspx page. 
    I have no idea what is going on with.  Things work fine with the export on the other pages, at least I do get an excel file.

    If anyone has any ideas, I would appreciate the feedback.

    <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="RMAGenerator.aspx.cs" Inherits="ECSMT.RMAGenerator" %>
    <%@ 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>JDE RMA Grid Creation</title>
        <script src="/Scripts/modernizr-2.0.6.min.js" type="text/javascript"> </script>
        <style>
           section 
                {
                    background: #cfdbe6;
                    margin: 20px;
                    padding: 5px;              
                    border-radius: 10px;
                    box-shadow: 4px 4px 10px rgba(0, 0, 0, 0.5);
                    background: cfdbe6;
                    width: 95%;
                    color: #696969;
                    font-size: 12px;
                }
            section h1 {font-size: 16px; font-weight: bold; color:Navy }
            section h2 {font-size: 12px; font-weight: bold; text-decoration: underline}
            .MyImageButton
            {
                cursor: hand;
            }
            .EditFormHeader td
            {
                font-size: 14px;
                padding: 4px !important;
                color: #0066cc;
            }
     
        </style>
    </head>
    <body>
        <form id="form1" runat="server">
            <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
            </telerik:RadScriptManager>
            <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
                <AjaxSettings>
                    <telerik:AjaxSetting AjaxControlID="rgrdRMA">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="rgrdRMA" LoadingPanelID="RadAjaxLoadingPanel1" />
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                    <telerik:AjaxSetting AjaxControlID="rbtnAppend">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="rbtnAppend"></telerik:AjaxUpdatedControl>
                            <telerik:AjaxUpdatedControl ControlID="rgrdRMA" LoadingPanelID="RadAjaxLoadingPanel1" ></telerik:AjaxUpdatedControl>
                        </UpdatedControls>
                    </telerik:AjaxSetting>
    <%--                <telerik:AjaxSetting AjaxControlID="rbtnExport">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="rbtnExport"></telerik:AjaxUpdatedControl>
                            <telerik:AjaxUpdatedControl ControlID="rgrdExpXl" LoadingPanelID="RadAjaxLoadingPanel1" ></telerik:AjaxUpdatedControl>
                        </UpdatedControls>
                    </telerik:AjaxSetting>--%>
                </AjaxSettings>
            </telerik:RadAjaxManager>
            <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default" Width = "100%" Height="100%">
            </telerik:RadAjaxLoadingPanel>
                <h3>RMA Generator</h3>
                <h1>CEI:<asp:Label ID="lblCEI" runat="server" Text="0"></asp:Label>
                CMT:<asp:Label ID="lblCMT" runat="server" Text="0"></asp:Label></h1>
                <h3><asp:Label ID = "lblCustInfo" runat="server" Text="Customer Information" ></asp:Label></h3>
     
                <telerik:RadGrid ID="rgrdRMA" runat="server" GridLines="Both" Skin="Windows7" AllowPaging="False" AllowSorting="false"
                    AutoGenerateColumns="False"  OnNeedDataSource="rgrdRMA_NeedDataSource" OnUpdateCommand="rgrdRMA_UpdateCommand"
                     OnInsertCommand="rgrdRMA_InsertCommand"  OnDeleteCommand="rgrdRMA_DeleteCommand" ShowStatusBar="true">
                    <MasterTableView Width="100%" CommandItemDisplay="Top" DataKeyNames="RowNumber"
                             AutoGenerateColumns="False" EditMode="InPlace" >
                        <Columns>
                            <telerik:GridEditCommandColumn UniqueName="EditCommandColumn">
                            </telerik:GridEditCommandColumn>
                            <telerik:GridDropDownColumn DataField="LastDispo" DataSourceID="SqlDataSource1"
                                HeaderText="LastDispo" ListTextField="DescOne" ListValueField="LastDispo"
                                UniqueName="LastDispo" >
                            </telerik:GridDropDownColumn>
                            <telerik:GridDropDownColumn DataField="LITM" DataSourceID="SqlDataSource2"
                                HeaderText="LITM" ListTextField="DSC" ListValueField="LITM"
                                UniqueName="LITM" >
                            </telerik:GridDropDownColumn>
                            <telerik:GridNumericColumn UniqueName="ReturnQty" SortExpression="ReturnQty" HeaderText="ReturnQty"
                            DataField="ReturnQty" />
                            <telerik:GridDropDownColumn DataField="ReturnEquipNum" DataSourceID="EquipmentForReceipt"
                                HeaderText="ReturnEquipNum" ListTextField="BigDescrip" ListValueField="ReturnEquipNum"
                                UniqueName="ReturnEquipNum" >
                            </telerik:GridDropDownColumn>
                            <telerik:GridBoundColumn UniqueName="ReturnSerialNum" SortExpression="ReturnSerialNum" HeaderText="ReturnSerialNum"
                                DataField="ReturnSerialNum" ReadOnly="true"  />
                            <telerik:GridBoundColumn UniqueName="IncomingLocCode" SortExpression="IncomingLocCode" HeaderText="IncomingLocCode"
                            DataField="IncomingLocCode" />
                            <telerik:GridDropDownColumn DataField="ShipToAddr" DataSourceID="ShipTosFilteredByCMT"
                                HeaderText="ShipToAddr" ListTextField="ShipToAddr" ListValueField="ShipToAddr"
                                UniqueName="ShipToAddr" >
                            </telerik:GridDropDownColumn>
                            <telerik:GridNumericColumn UniqueName="ReplacementQty" SortExpression="ReplacementQty" HeaderText="ReplacementQty"
                            DataField="ReplacementQty" />
                            <telerik:GridNumericColumn UniqueName="ReplacementEquipID" SortExpression="ReplacementEquipID" HeaderText="ReplacementEquipID"
                                DataField="ReplacementEquipID" />
                            <telerik:GridBoundColumn UniqueName="OutgoingLocCode" SortExpression="OutgoingLocCode" HeaderText="OutgoingLocCode"
                                DataField="OutgoingLocCode" />
                            <telerik:GridBoundColumn UniqueName="RequestedShipDate" SortExpression="RequestedShipDate" HeaderText="RequestedShipDate"
                                DataField="RequestedShipDate" ReadOnly="true"/>
                            <telerik:GridButtonColumn UniqueName="DeleteColumn" CommandName="Delete" ButtonType="LinkButton" Text="Delete" />
                        </Columns>
                     </MasterTableView>
                </telerik:RadGrid>
     
     
                 <asp:Table ID="tblControls" runat="server" Width="100%">
                    <asp:TableRow  Width = "100%">
                        <asp:TableCell Width="20%" HorizontalAlign="Right" >
                            <h1>Append RMA Product For</h1>
                        </asp:TableCell>
                        <asp:TableCell Width="30%" HorizontalAlign="Right" >
                            <telerik:RadComboBox ID="rcmbProduct" Runat="server" Width="100%" AutoPostBack="true" ></telerik:RadComboBox>
                        </asp:TableCell>
                        <asp:TableCell Width="10%" HorizontalAlign="Left" >
                            <telerik:RadButton ID="rbtnAppend" runat="server" Text="Append" OnClick="rbtnAppend_Click" AutoPostBack="true"></telerik:RadButton>
                        </asp:TableCell>
                        <asp:TableCell Width="40%" HorizontalAlign ="Justify">
                            <telerik:RadButton ID="rbtnExport" runat="server" Text="Export"  OnClick="rbtnExport_Click" AutoPostBack="true"></telerik:RadButton>
                        </asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow >
                        <asp:TableCell Width="20%" HorizontalAlign="Center" >
                            <asp:Label ID="lblCurPC" Text="Current PC:" runat="server"></asp:Label>
                        </asp:TableCell>
                        <asp:TableCell Width="20%" HorizontalAlign="Center" >
                            <asp:Label ID="lblCurPCType" Text="Current PC Type:" runat="server"></asp:Label>
                        </asp:TableCell>
                        <asp:TableCell Width="20%" HorizontalAlign="Center" >
                            <asp:Label ID="lblCurScreenSKU" Text="Current Screen SKU :" runat="server"></asp:Label>
                        </asp:TableCell>
                        <asp:TableCell Width="40%" HorizontalAlign ="Center">
                        </asp:TableCell>
                    </asp:TableRow>
                </asp:Table>
     
                <telerik:RadGrid ID="rgrdExpXl" runat="server" GridLines="Both" Skin="Windows7" AllowPaging="False"
                    AutoGenerateColumns="False" OnNeedDataSource="rgrdExpXl_NeedDataSource"  >
                    <MasterTableView Width="100%" AutoGenerateColumns="False" >
                        <Columns>
                            <telerik:GridBoundColumn DataField="LastDispo" HeaderText="" UniqueName="LastDispo" />
                            <telerik:GridBoundColumn DataField="LITM" HeaderText="" UniqueName="LITM" />
                            <telerik:GridNumericColumn UniqueName="ReturnQty" HeaderText="" DataField="ReturnQty" />
                            <telerik:GridBoundColumn DataField="ReturnEquipNum" HeaderText="" UniqueName="ReturnEquipNum" />
                            <telerik:GridBoundColumn UniqueName="ReturnSerialNum" HeaderText="" DataField="ReturnSerialNum" />
                            <telerik:GridBoundColumn UniqueName="RequestedShipDate" HeaderText="" DataField="RequestedShipDate" />
                            <telerik:GridBoundColumn DataField="LITM" HeaderText="" UniqueName="LITM2" />
                            <telerik:GridBoundColumn DataField="ShipToAddr" HeaderText="" UniqueName="ShipToAddr" />
                            <telerik:GridNumericColumn UniqueName="ReplacementEquipID" HeaderText="" DataField="ReplacementEquipID" />
                            <telerik:GridNumericColumn UniqueName="ReplacementQty" HeaderText="" DataField="ReplacementQty" />
                            <telerik:GridNumericColumn UniqueName="ReturnQty2" HeaderText="" DataField="ReturnQty" />
                            <telerik:GridNumericColumn UniqueName="LineNumber" HeaderText="" DataField="LineNumber" />
                            <telerik:GridBoundColumn UniqueName="IncomingLocCode" HeaderText="" DataField="IncomingLocCode" />
                            <telerik:GridBoundColumn UniqueName="OutgoingLocCode" HeaderText="" DataField="OutgoingLocCode" />
                        </Columns>
                     </MasterTableView>
                </telerik:RadGrid>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:JDECommon %>"
                    ProviderName="System.Data.SqlClient" SelectCommand="uspGetLastDispoForRMAGrid">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:JDECommon %>"
                    ProviderName="System.Data.SqlClient" SelectCommand="uspGetRMASKUS">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="ShipTosFilteredByCMT" runat="server"
                    ConnectionString="<%$ ConnectionStrings:JDECommon %>"
                    SelectCommand= "uspGetRMAShipTos @CMT">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lblCMT" Name="CMT"
                            PropertyName="Text" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="EquipmentForReceipt" runat="server"
                    ConnectionString="<%$ ConnectionStrings:JDECommon %>"
                    SelectCommand= "uspGetRMAOutboundEquipmentForCEI @CEI ">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lblCEI" Name="CEI"
                            PropertyName="Text" />
                    </SelectParameters>
                </asp:SqlDataSource>
     </form>
    </body>
    <script type="text/javascript">
        Modernizr.load([{
            complete: function ()
            {
                if (!window.jQuery)
                {
                    Modernizr.load('/Scripts/jquery-1.6.1.min.js');
                }
            }
        },
            {
                test: Modernizr.borderradius || Modernizr.boxshadow,
                nope: '/Scripts/PIE.js',
                callback: function ()
                {
                    $('section').each(function ()
                    {
                        PIE.attach(this);
                    });
                }
            }]);
        </script>
     
    </html>
  2. Pablo
    Pablo avatar
    10 posts
    Member since:
    Oct 2012

    Posted 30 Nov 2011 Link to this post

    Try the following:

    Paste the following markup in your grid right before the element <MasterTableView...

    <ExportSettings ExportOnlyData="True" IgnorePaging="true" OpenInNewWindow="true">
                        <Excel Format="ExcelML" />
         </ExportSettings>


    Then in your code do the following 

    for rgrdRMA grid:

     this.rgrdRMA.MasterTableView.ExportToExcel();

    for rgrdExpXl grid: 

     this.rgrdExpXl.MasterTableView.ExportToExcel();

  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Jack Voss
    Jack Voss avatar
    27 posts
    Member since:
    May 2010

    Posted 01 Dec 2011 Link to this post

    I actually set those export setting in the codebehind when they click the button to export.

    The problem was not in the code, the problem was coming from my IE settings.  

    I deleted all of my temporary files, cookies, saved passwords, and web information. 
    Then Restored the Advanced settings , Reset internet expolorer to it's default settings and the export started working.   This is not the first time we have run across weird problems with explorer.  We have had peoples IE not display grids properly and complete the opening of a page and hang.  All so far were fixed by reseting explorerer.  


  5. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 01 Dec 2011 Link to this post

    Hello Jack,

    The exporting feature of the RadGrid work with regular postbacks only. Since you have ajaxified your RadGrid, you need to explicitly disable its ajax mode to export with regular postback. Check the following help documentation which explains the same.
    Export from Ajaxified Grid

    -Shinu.
Back to Top