or
ActiveBatchesRadGrid_ItemCommand calls the method ConfigureExport in the base class so all exports function the sameprivate void ActiveBatchesRadGrid_ItemCommand(object source, GridCommandEventArgs e){ switch (e.CommandName) { case RadGrid.InitInsertCommandName: _gridTableView = e.Item.OwnerTableView; break; case RadGrid.ExportToExcelCommandName: ExpandAllDetailTableRecords(source, ExpandedStates, false); ConfigureExport(source, e); break; } }protected static void ConfigureExport(object source, GridCommandEventArgs e){ e.Item.OwnerTableView.ExpandCollapseColumn.Visible = false; e.Item.OwnerTableView.GetColumn("PolicyEditRecord").Visible = false; e.Item.OwnerTableView.GetColumn("DeleteTransaction").Visible = false; e.Item.OwnerTableView.GetColumn("ManualAdjustmentBatchID").Visible = false; e.Item.OwnerTableView.GetColumn("ManualAdjustmentID").Visible = false; ((RadGrid)source).ExportSettings.ExportOnlyData = true; //((RadGrid)source).PageSize = ((RadGrid)source).MasterTableView.VirtualItemCount; ((RadGrid)source).ExportSettings.IgnorePaging = true; ((RadGrid)source).ExportSettings.OpenInNewWindow = false; ((RadGrid)source).MasterTableView.HierarchyDefaultExpanded = false; ((RadGrid)source).MasterTableView.ExportToExcel();}VirtualItemCount is commented out because it throws an "System.ArgumentOutOfRangeException: Specified argument was out of the range of
valid values." error. I have not tried it yet but I think it may be due to the export being conducted on the DetailGrid and not the MasterGrid. Any comments on that would be appreciated too.<telerik:RadGrid ID="gvCCECCommitteeProperties" GridLines="None" AutoGenerateColumns="false" PageSize="15" EnableEmbeddedSkins="true" Skin="Default" Width="99%" AllowFilteringByColumn="true" AllowAutomaticDeletes="false" AllowMultiRowEdit="false" AllowMultiRowSelection="false" AllowPaging="true" AllowSorting="false" runat="server" OnItemCreated="gvCCECCommitteeProperties_ItemCreated" DataSourceID="SqlDataSource1" AllowAutomaticUpdates="true" AllowAutomaticInserts="False" OnInit="gvCCECCommitteeProperties_Init" SelectCommandType="StoredProcedure" SelectCommand="SelectEmployees" UpdateCommandType="" UpdateCommand="UPDATE [CCECCommitteeProperties] SET [LastName] = @LastName, [FirstName] = @FirstName, [MiddleName] = @MiddleName, [Suffix] = @Suffix, [IsDependent] = @IsIndependent, [IsUnopposed] = @IsUnapplosed, [IsOneParty] = @IsOneParty, [IsPrimaryWinner] = @IsPrimaryWinner, [IsGeneralWinner] = @IsGeneralWinner, [IsActive] = @IsActive, [IsQualifiedForBallot] = @IsQualifiedForBallot, [IsReallocated] = @IsReAllocated, [IsIncumbent] = @IsIncumbent WHERE [CCECCommitteePropertyID] = @CCECCommitteePropertyID" ShowStatusBar="true"> <MasterTableView ShowFooter="false" DataKeyNames="CCECCommitteePropertyID" EditMode="InPlace" CommandItemDisplay="TopAndBottom"> <Columns> <telerik:GridEditCommandColumn FooterText="EditCommand footer" UniqueName="EditCommandColumn" HeaderText="Edit" HeaderStyle-Width="100px" UpdateText="Update"> </telerik:GridEditCommandColumn> <telerik:GridTemplateColumn HeaderStyle-Width="250px" HeaderText="Names<br>(Last Name)" AllowFiltering="true" DataField="LastName"> <ItemTemplate> <div style="width: 250px"> <asp:Label Width="100px" ID="Label1" runat="server" Text="Last Name;" ></asp:Label> <asp:Label Width="100px" ID="txtLastName" runat="server" Text='<%# Bind("LastName") %>'></asp:Label> <br /> <asp:Label Width="100px" ID="Label2" runat="server" Text="First Name:" ></asp:Label> <asp:Label Width="100px" ID="txtFirstName" runat="server" Text='<%# Bind("FirstName") %>'></asp:Label> <br /> <asp:Label Width="100px" ID="Label4" runat="server" Text="Middle Name:" ></asp:Label> <asp:Label Width="100px" ID="txtMiddleName" runat="server" Text='<%# Bind("MiddleName") %>'></asp:Label> <br /> <asp:Label Width="100px" ID="Label3" runat="server" Text="Suffix:" ></asp:Label> <asp:Label Width="100px" ID="txtSuffix" runat="server" Text='<%# Bind("Suffix") %>'></asp:Label> </div> </ItemTemplate> <EditItemTemplate> <div style="width: 250px" > <asp:Label Width="100px" ID="Label1" runat="server" Text="Last Name;" ></asp:Label> <asp:TextBox Width="100px" ID="LastName" runat="server" Text='<%# Bind("LastName") %>'></asp:TextBox> <br /> <asp:Label Width="100px" ID="Label2" runat="server" Text="First Name:" ></asp:Label> <asp:TextBox Width="100px" ID="FirstName" runat="server" Text='<%# Bind("FirstName") %>'></asp:TextBox> <br /> <asp:Label Width="100px" ID="Label4" runat="server" Text="Middle Name:" ></asp:Label> <asp:TextBox Width="100px" ID="MiddleName" runat="server" Text='<%# Bind("MiddleName") %>'></asp:TextBox> <br /> <asp:Label Width="100px" ID="Label3" runat="server" Text="Suffix:" ></asp:Label> <asp:TextBox Width="100px" ID="Suffix" runat="server" Text='<%# Bind("Suffix") %>'></asp:TextBox> </div> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Information<br>(Filer Id)" AllowFiltering="true" DataField="CommitteeID"> <ItemTemplate> <div style="float: left;"> FilerID: <asp:Label ID="lblFilerID" runat="server" Text='<%# Eval("CommitteeID") %>'></asp:Label> <br /> Party: <asp:Label ID="lblCandidateParty" runat="server" Font-Bold="False" Text='<%# Eval("PartyName") %>'></asp:Label> </div> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsActive" HeaderText="Active?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsIndependent" HeaderText="Independent?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsUnopposed" HeaderText="Unopposed?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsOneParty" HeaderText="One Party<br>Dominant?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsPrimaryWinner" HeaderText="Primary<br>Winner?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsGeneralWinner" HeaderText="General<br>Winner?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsQualifiedForBallot" HeaderText="Qualified<br>for Ballot?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsReallocated" HeaderText="Reallocated?" ></telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn AllowFiltering="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" DataField="IsIncumbent" HeaderText="Incumbent?" ></telerik:GridCheckBoxColumn> <telerik:GridBoundColumn Visible="false" DataField="OfficeID" ></telerik:GridBoundColumn> </Columns> </MasterTableView></telerik:RadGrid>protected void gvCCECCommitteeProperties_Init(object sender, System.EventArgs e){ GridFilterMenu menu = gvCCECCommitteeProperties.FilterMenu; int i = 0; while (i < menu.Items.Count) { if (i == 0) { if (menu.Items[i].Text == "NoFilter" || menu.Items[i].Text == "Contains" || menu.Items[i].Text == "StartsWith" || menu.Items[i].Text == "EqualTo") { i++; } else { menu.Items.RemoveAt(i); } } }}None of these options fixed the issue. One setting that seemed to get me closer was removing HeaderStyle-Wrap=False and ItemStyle-Wrap=False. Again setting each of these to false got me much closer however they were still way off. Any help with this would be greatly appreciated as time is of the essence. Thank you.