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.