This is a migrated thread and some comments may be shown as answers.

Very strange problem when hiding columns when exporting

4 Answers 85 Views

Grid

This is a migrated thread and some comments may be shown as answers.

nader asked on 14 Aug 2011, 11:40 AM

Export-issue.png

I have a very strange problem when i hide columns before exporting grid to excel using " rgReports.MasterTableView.GetColumn("Column5").Visible = false; "

I have grid with 10 columns , when exporting i want to show only 4 columns.assume columns to be shown are column1,column4,column8,column9.
When i hide columns the first columns is shown in n columns where n == hidden columns as shown in the image.

How to really hide columns in an efficient way ??!!!

Here is my code :

rgReports.MasterTableView.GetColumn("Column1").Visible = false;

rgReports.MasterTableView.GetColumn("Column2").Visible = false;

rgReports.MasterTableView.GetColumn("Column3").Visible = false;

rgReports.MasterTableView.GetColumn("Column4").Visible = false;

rgReports.MasterTableView.GetColumn("Column5").Visible = false;

rgReports.MasterTableView.GetColumn("Column6").Visible = false;

rgReports.ExportSettings.FileName ="Report1";

rgReports.ExportSettings.OpenInNewWindow = true;

rgReports.MasterTableView.AllowPaging = false;

rgReports.MasterTableView.Rebind();

rgReports.MasterTableView.ExportToExcel();

Thanks in advance for ur help.

4 Answers, 1 is accepted

answered on 18 Aug 2011, 09:49 AM

<telerik:RadGrid ID="rgReports" runat="server" AllowMultiRowSelection="false" AutoGenerateColumns="false"

AllowCustomPaging="false" OnNeedDataSource="rgreports_onneedDataSource" OnItemDataBound="RgreportsOnItemdatabound"

OnDetailTableDataBind="RgreportsDetaildatabind" OnExportCellFormatting="rgReports_OnExportCellFormatting"

OnPreRender="rgReports_OnPreRender">

<PagerStyle Mode="NumericPages" Width="95%" />

<MasterTableView AllowPaging="true" PageSize="12" Name="MasterSummaryReport" HierarchyLoadMode="Client">

<Columns>

<telerik:GridTemplateColumn HeaderText="Employee" ItemStyle-Width="150px" UniqueName="EmployeeName">

<ItemTemplate>

<asp:LinkButton ID="lblEmpName" runat="server" Text="" OnClick="lnkEmployee_OnClick" />

<asp:LinkButton Text="" runat="server" ID="lnkPenalty" Font-Bold="true" ToolTip="Penalties" >

</asp:LinkButton>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Total WorkingHours" ItemStyle-HorizontalAlign="Center"

HeaderStyle-HorizontalAlign="Center" ItemStyle-Width="50px" UniqueName="TotalWorkingHours">

<ItemTemplate>

<asp:Label ID="lblTotalWorkingHours" runat="server" Text="" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="< Daily Hours" ItemStyle-HorizontalAlign="Center"

HeaderStyle-HorizontalAlign="Center" UniqueName="LDailyHours">

<ItemTemplate>

<asp:LinkButton ID="lblLessthaneighthours" runat="server" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Vacations worked" ItemStyle-HorizontalAlign="Center"

HeaderStyle-HorizontalAlign="Center" UniqueName="Vacationsworked">

<ItemTemplate>

<asp:LinkButton ID="lblVacationsWorked" runat="server" />

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<DetailTables>

<telerik:GridTableView runat="server" Name="SummaryMonthlyDetails">

<Columns>

<telerik:GridTemplateColumn HeaderText="Month" ItemStyle-HorizontalAlign="Center"

HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="70px">

<ItemTemplate>

<asp:Label ID="lblMonth" runat="server" Text="" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Total Working Hours" ItemStyle-HorizontalAlign="Center"

HeaderStyle-HorizontalAlign="Center">

<ItemTemplate>

<asp:Label ID="lblDTotalWorkingHours" runat="server" Text="" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="WeeksWorked" ItemStyle-HorizontalAlign="Center"

HeaderStyle-HorizontalAlign="Center">

<ItemTemplate>

<asp:Label ID="lblDWeeksWorked" runat="server" Text="" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Avg Working H/Day" ItemStyle-HorizontalAlign="Center"

HeaderStyle-HorizontalAlign="Center">

<ItemTemplate>

<asp:Label ID="lblDAverageHours" runat="server" Text="" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="L Daily Hours" ItemStyle-HorizontalAlign="Center"

HeaderStyle-HorizontalAlign="Center">

<ItemTemplate>

<asp:LinkButton ID="lblDLessthaneighthours" runat="server" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="M Daily Hours" ItemStyle-HorizontalAlign="Center"

HeaderStyle-HorizontalAlign="Center">

<ItemTemplate>

<asp:LinkButton ID="lblDMorethaneighthours" runat="server" />

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

</MasterTableView>

</telerik:RadGrid>