ExportToExcel Causing Object not set to an Instance of an Object

[Brett]

I have successfully tested this feature on my dev and live server on multiple browsers on my machine. However the user is receiving the attached screen. The user is using Internet Explorer, although not sure which version at this time.

I used an ImageButton for the export button.

protected void exportToExcel_Click(object sender, ImageClickEventArgs e) {

          radGridVesselUtil.ExportSettings.IgnorePaging = true;

          radGridVesselUtil.ExportSettings.OpenInNewWindow = true;

          radGridVesselUtil.ExportSettings.ExportOnlyData = true;

          radGridVesselUtil.ExportSettings.FileName = "vessel_util_" + DateTime.Now.ToShortDateString();

          radGridVesselUtil.MasterTableView.ExportToExcel();

      }
 protected void gridDpSummary_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) {
                gridDpSummary.DataSource = SqlDataSource1;
            }


RadGridMarkup

                    

                       <telerik:RadGrid ID="radGridVesselUtil" runat="server" CellSpacing="0"

                         AllowPaging="True" AllowSorting="True" PageSize="25"

                       GridLines="None" EnableEmbeddedSkins="False" Skin="dpgrid"

                         ShowGroupPanel="True" AutoGenerateColumns="False" 

                         onneeddatasource="radGridVesselUtil_NeedDataSource">

                             <MasterTableView>

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

                               <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>

                               <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>

                               <Columns>

                                 <telerik:GridBoundColumn FilterControlAltText="Filter Voyage Column"

                                   HeaderText="Voyage" UniqueName="Voyage" DataField="VoyageID">

                                   <HeaderStyle Width="55px" HorizontalAlign="Center"/>

                                   <ItemStyle HorizontalAlign="Center"/>

                                 </telerik:GridBoundColumn>

                                 <telerik:GridBoundColumn FilterControlAltText="Filter Leg Start Column"

                                   UniqueName="LegStart" HeaderText="Start Date" DataField="LegStart">

                                   <HeaderStyle Width="125px" HorizontalAlign="Center"/>

                                   <ItemStyle HorizontalAlign="Center"/>

                                 </telerik:GridBoundColumn>

                                 <telerik:GridBoundColumn FilterControlAltText="Filter Leg End Column"

                                   UniqueName="LegEnd" HeaderText="End Date" DataField="LegEnd">

                                   <HeaderStyle Width="125px" HorizontalAlign="Center"/>

                                   <ItemStyle HorizontalAlign="Center"/>

                                 </telerik:GridBoundColumn>

                                 <telerik:GridBoundColumn FilterControlAltText="Filter Vessel Column"

                                   UniqueName="VesselName" HeaderText="Vessel" DataField="VesselName">

                                   <HeaderStyle HorizontalAlign="Center"/>

                                 </telerik:GridBoundColumn>

                                 <telerik:GridBoundColumn FilterControlAltText="Filter Facility Column"

                                   UniqueName="FacilityName" HeaderText="Facility" DataField="FacilityName">

                                   <HeaderStyle HorizontalAlign="Center"/>

                                 </telerik:GridBoundColumn>

                                 <telerik:GridBoundColumn FilterControlAltText="Filter Time Usage column"

                                   HeaderText="Time Usage" UniqueName="TimeUsage" DataField="TimeUsage">

                                   <HeaderStyle HorizontalAlign="Center"/>

                                 </telerik:GridBoundColumn>

                                 <telerik:GridBoundColumn FilterControlAltText="Filter Volume Usage column"

                                   HeaderText="Volume Usage" UniqueName="VolumeUsage" DataField="VolumeUsage">

                                   <HeaderStyle HorizontalAlign="Center"/>

                                 </telerik:GridBoundColumn>

                                 <telerik:GridBoundColumn FilterControlAltText="Filter Weight column"

                                   HeaderText="Weight" UniqueName="Weight" DataField="Weight">

                                   <HeaderStyle HorizontalAlign="Center"/>

                                 </telerik:GridBoundColumn>

                                 <telerik:GridBoundColumn FilterControlAltText="Filter Capacity Usage Column"

                                   HeaderText="Capacity Usage" UniqueName="CapacityUsage" DataField="CapacityUsage">

                                   <HeaderStyle HorizontalAlign="Center"/>

                                 </telerik:GridBoundColumn>

                                 <telerik:GridBoundColumn FilterControlAltText="Filter Deck Space Usage Column"

                                   HeaderText="Deck Space Usage" UniqueName="DeckSpaceUsage" DataField="DeckSpaceUsage">

                                   <HeaderStyle HorizontalAlign="Center"/>

                                 </telerik:GridBoundColumn>

                               </Columns>

                               <EditFormSettings>

                               <EditColumn InsertImageUrl="Update.gif" UpdateImageUrl="Update.gif" EditImageUrl="Edit.gif" CancelImageUrl="Cancel.gif" FilterControlAltText="Filter EditCommandColumn column"></EditColumn>

                               </EditFormSettings>

                               <GroupByExpressions>

                                 <telerik:GridGroupByExpression>

                                   <SelectFields>

                                     <telerik:GridGroupByField FieldName="VoyageID" HeaderText="Voyage" />

                                   </SelectFields>

                                   <GroupByFields>

                                     <telerik:GridGroupByField FieldName="VoyageID" SortOrder="Descending" />

                                   </GroupByFields>

                                 </telerik:GridGroupByExpression>

                               </GroupByExpressions>

                             </MasterTableView>

                              <PagerStyle Mode="NextPrevNumericAndAdvanced" />

                             <ClientSettings ReorderColumnsOnClient="True" AllowDragToGroup="True" AllowColumnsReorder="True">

                              <Resizing AllowRowResize="True" AllowColumnResize="True" EnableRealTimeResize="True"

                                 ResizeGridOnColumnResize="False"></Resizing>

                             </ClientSettings>

                              <GroupingSettings ShowUnGroupButton="true"/>

                              <FilterMenu EnableImageSprites="False"></FilterMenu>

                              <HeaderContextMenu EnableEmbeddedSkins="False" CssClass="GridContextMenu GridContextMenu_dpgrid"></HeaderContextMenu>

                       </telerik:RadGrid>

[Princy]

Hello Brett,

I cannot reproduce the issue a t my end. Please try calling the Rebind() method after exporting.

Thanks,
Princy.