This is a migrated thread and some comments may be shown as answers.
Issue in RadGrid Export to Excel functionality
28 Answers 91 Views
This is a migrated thread and some comments may be shown as answers.
Ruchi
Top achievements
Rank 1
Ruchi asked on 21 Nov 2015, 01:05 PM

Hi Team,

      We are binding radgrid from server side,  and using default Export to Excel functionality. The problem area is when we export the excel we are getting Extra Words like "Sorted ascSorted desc" in Column Header along with Column Name. We have tried few related properties of export settings but failed to resolve the issue. For your reference attaching problematic excel screenshot and also grid settings below.

Please do needful as soon as possible.

Thanks.

            RadAjaxLoadingPanel RadajaxloadingpanelTestdata = new RadAjaxLoadingPanel();
            RadajaxloadingpanelTestdata.ID = "Radajaxloadingpanel_AccActWidget_" + WidMapID;
            this.Controls.Add(RadajaxloadingpanelTestdata);

            RadAjaxPanel panel_testdata = new RadAjaxPanel();
            panel_testdata.ID = WidMapID;

            RadGrid rgTestData = new RadGrid();
            rgTestData.ID = WidMapID;
            rgTestData.AllowPaging = true;
            rgTestData.AllowSorting = true;
            rgTestData.AutoGenerateColumns = false;
            rgTestData.ExportSettings.IgnorePaging = true;
            rgTestData.ExportSettings.ExportOnlyData = true;
            rgTestData.ExportSettings.Excel.Format.Equals("Biff");
            rgTestData.ExportSettings.HideStructureColumns = true;
            rgTestData.ExportSettings.FileName = "CountsOfTestsLoaded";
            rgTestData.ExportSettings.Pdf.ForceTextWrap = true;
            rgTestData.MasterTableView.DataKeyNames = new string[] { "VerifyDate" };
            rgTestData.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Bottom;
            rgTestData.MasterTableView.ClientDataKeyNames = new string[] { "VerifyDate" };
            rgTestData.MasterTableView.CommandItemSettings.ShowAddNewRecordButton = false;
            rgTestData.MasterTableView.CommandItemStyle.Height.Equals("22px");
            rgTestData.MasterTableView.CommandItemStyle.HorizontalAlign = HorizontalAlign.Right;
            rgTestData.MasterTableView.PagerStyle.AlwaysVisible = true;
            rgTestData.MasterTableView.PagerStyle.Mode.Equals("NextPrevAndNumeric");
            rgTestData.ShowHeader = true;
            rgTestData.ClientSettings.Selecting.AllowRowSelect = true;
            rgTestData.MasterTableView.CommandItemTemplate = new MyCommandItemTemplate() { IsRefresh = true, IsExcel = true, IsPdf = true, IsCsv = true };
            BoundColumns(rgTestData);
            panel_testdata.ClientEvents.OnRequestStart = "onRequestStartTestData";
            panel_testdata.LoadingPanelID = RadajaxloadingpanelTestdata.ClientID;
            this.Controls.Add(panel_testdata);
            panel_testdata.Controls.Add(rgTestData);

28 Answers, 1 is accepted

Sort by
0
Accepted
Nils C.
Top achievements
Rank 1
answered on 06 Jan 2016, 11:39 AM

Hi there.

Did you find a solution for this yet?

We are facing the same issue..

0
Ruchi
Top achievements
Rank 1
answered on 08 Jan 2016, 11:02 AM

Hi Nils,

We haven't got any solution for this. Please let us know if you fiund.

 

Thanks,

Ruchi Patel

0
Kostadin
Telerik team
answered on 11 Jan 2016, 06:40 AM
Hi Ruchi,

We are aware of this issue and I am afraid this is a bug in the binary export formats (Biff, Xlsx and Docx). Nevertheless, our developers already fixed the issue and it will be included in our next official release which will be available till the end of the week. Meanwhile as a workaround you can manually disable the sorting when export the grid.
protected void btnExport_Click(object sender, EventArgs e)
{
    MyRadGrid.AllowSorting = false;
    if (!MyRadGrid.ExportSettings.IgnorePaging)
    {
        MyRadGrid.Rebind();
    }
    MyRadGrid.MasterTableView.ExportToExcel();
}


Regards,
Kostadin
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Ruchi
Top achievements
Rank 1
answered on 15 Jan 2016, 03:38 AM

Hi Kostadin,

Thank you for suggestion the but sorry that didn't work. still I am getting the extra text in the column header.

Thanks,

Ruchi Patel
0
Kostadin
Telerik team
answered on 19 Jan 2016, 03:36 PM
Hi Ruchi,

I tried to replicate the issue on my side but I was unable to. Could you please check out the attached sample and let me know how it differs from your real setup? I would appreciate if you can replicate the issue in the attached sample and let me know how you modified it.

Regards,
Kostadin
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
David
Top achievements
Rank 1
answered on 20 Jan 2016, 09:55 PM

You may try to use the InfrastructureExporting Event on the RadGrid.  Not sure about the performance if theres many columns.

01.Dim hrow As Telerik.Web.UI.ExportInfrastructure.Row = e.ExportStructure.Tables(0).Rows(1)
02.        For Each hcell As Telerik.Web.UI.ExportInfrastructure.Cell In hrow.Cells
03.            If hcell.Text.Contains("Sorted asc") Then
04.                hcell.Value = hcell.Text.Replace("Sorted asc", "")
05.            End If
06.            If hcell.Text.Contains("Sorted desc") Then
07.                hcell.Value = hcell.Text.Replace("Sorted desc", "")
08.            End If
09.        Next hcell

0
David
Top achievements
Rank 1
answered on 21 Jan 2016, 02:00 PM

Im sorry for the VB and formatting.  It does look like the newest release fixes this. However, if you still need it.

Telerik.Web.UI.ExportInfrastructure.Row hrow = e.ExportStructure.Tables(0).Rows(1);
 
 
foreach (Telerik.Web.UI.ExportInfrastructure.Cell hcell in hrow.Cells) {
 
    if (hcell.Text.Contains("Sorted asc")) {
        hcell.Value = hcell.Text.Replace("Sorted asc", "");
 
    }
 
 
    if (hcell.Text.Contains("Sorted desc")) {
        hcell.Value = hcell.Text.Replace("Sorted desc", "");
 
    }
 
}

0
Elena
Top achievements
Rank 1
answered on 21 Mar 2016, 01:09 PM
I updated to the latest telerik version but I'm still seeing the Sorted ascSorted desc text when I export my document.  I have turned off sorting MasterTableView.AllowSorting = false; when I hit the command but it's not working.  I even tried to overwrite the column name but it's overwriting the name but still adding the extra code.  Please help!
0
Kostadin
Telerik team
answered on 24 Mar 2016, 11:59 AM
Hello Elena,

Could you please verify that you can replicate the issue from my previous reply? Additionally could you please let me know which version you are using in your project?

Regards,
Kostadin
Telerik
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
0
Elena
Top achievements
Rank 1
answered on 24 Mar 2016, 12:40 PM

I didn't try to replicate your issue but I tried the available fix and it wasn't working.  I tried 2 versions:  Q1 2016

2016 1 113 40
2016 1 315

I ended up re-writing it and using the Spreadsheet dll.

0
Kostadin
Telerik team
answered on 29 Mar 2016, 05:25 AM
Hi Elena,

I ma glad you were able to find a solution for your case. Nevertheless, if you manage to isolate the issue in a small runnable sample we will investigate it locally and provide you with a proper solution.

Regards,
Kostadin
Telerik
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
0
Thomas
Top achievements
Rank 1
answered on 15 Sep 2016, 01:39 PM

I've been coming across the same issue. Had to replace the column header characters to get the "Sorted ascSorted dec" text removed.

 

Has there been any progress on a potential fix for this problem?

0
Kostadin
Telerik team
answered on 20 Sep 2016, 08:30 AM
Hello Thomas,

Could you please verify that the issue could be observer with the latest version of the Telerik UI for ASP.NET. If you do I would appreciate if you can replicate the issue in a small runnable sample and send it to us for further investigation.

Regards,
Kostadin
Telerik by Progress
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
0
Julien
Top achievements
Rank 1
answered on 08 Sep 2017, 03:32 PM

Hi,

I'm having the same issue.

Telerik version : 2017.2.711.45

Exporting to Html Excel

0
Lars
Top achievements
Rank 1
answered on 13 Mar 2019, 11:10 AM

Has this ever been fixed? Because I am getting the same headers when exporting to Excel from the grid in version 2019.1.215.45:

DateSorted ascSorted desc TypeSorted ascSorted desc DescriptionSorted ascSorted desc Paid valueSorted ascSorted desc Market valueSorted ascSorted desc Discount%Sorted ascSorted desc

 

0
Attila Antal
Telerik team
answered on 18 Mar 2019, 10:14 AM
Hi Lars,

The issue seems to be available even with the latest version of Telerik controls. For a workaround, please visit the Bug item at When sort a grid with LightWeight render mode and export to Excel Biff format the sort expression is added to the header cells and check out the comments section.

Kind regards,
Attila Antal
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Vakul
Top achievements
Rank 1
answered on 13 May 2020, 06:04 AM

Hi Team,

I am getting issue with headers where Sorted AscSorted Desc are appending with headers while exporting. I have used OnCommand="OnGridCommand" client event in RadGrid.

If i remove this event then it works fine, but using this causing above issue. Please help on this.

0
Attila Antal
Telerik team
answered on 14 May 2020, 10:51 AM

Hi Vakul,

Please visit the Bug Report I have shared above and check its Comment section to see the workaround for this problem.

Kind regards,
Attila Antal
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Vakul
Top achievements
Rank 1
answered on 19 May 2020, 07:34 AM

Attila, Thanks for the Reply.

 

I have checked the workaround you have provided in the link for same problem. It works with the grid headers, But causing issue with the GridColumnGroup used in the group. The headers with group columns works fine, but fails at GridColumnGroup level.

- Sorted ascSorted desc are showing in GridColumnGroup child headers.

- Using GridColumnGroup in the grid is causing another issue. In export, headers used after GridColumnGroup are not showing correct.

 

Please find attachment as below:

0
Attila Antal
Telerik team
answered on 19 May 2020, 08:15 AM

Hi Vakul,

Thank you for the screenshot and additional clarification. Those from the screenshot are MultiColumnHeaders and I assumed you were having this problem with the Grouping functionality. Can you please share the Grid markup as well? I would like to take a look at it.

Kind Regards,
Attila Antal
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Vakul
Top achievements
Rank 1
answered on 19 May 2020, 01:39 PM

Hi Attila,
Thanks for the Quick reply. Yes, I am using Multi Columns.Headers. I was not able to attach file with zip or txt. So, I am pasting the code here.

 

<telerik:RadGrid ID="radGridScoreResults" runat="server" AllowSorting="True" GridLines="Both" RenderMode="Lightweight"  AllowMultiRowEdit="false" AllowMultiRowSelection="false" AutoGeneScoreColumns="false" AllowPaging="True"  OnNeedDataSource="radGridScoreResults_NeedDataSource" OnItemCommand="radGridScoreResults_ItemCommand" OnItemDataBound="radGridScoreResults_ItemDataBound"
    OnPageSizeChanged="radGridScoreResults_PageSizeChanged" OnPageIndexChanged="radGridScoreResults_PageIndexChanged" OnPreRender="radGridScoreResults_PreRender">
    <PagerStyle Mode="NextPScoreNumericAndAdvanced" AlwaysVisible="true" />
    <MasterTableView AllowMultiColumnSorting="False" CommandItemDisplay="Top" DataKeyNames="Score_Components_Model_Id, Score_Components_User_Id"
        HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" ItemStyle-HorizontalAlign="Left" AllowPaging="True" AllowCustomPaging="true"
        ItemStyle-VerticalAlign="Middle" Name="Detail" CssClass="divitem" ItemStyle-Height="21px" AlternatingItemStyle-Height="21px" Width="100%">
        <ColumnGroups>
            <telerik:GridColumnGroup Name="ghdrMinScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Min Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrRecScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Rec Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrFinalScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Final Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrComponentScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Component Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
        </ColumnGroups>
        <Columns>
            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdCHK" Visible="true">
                <ItemStyle Width="30px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="30px" Wrap="True" HorizontalAlign="Center" />
                <HeaderTemplate>
                    <asp:CheckBox ID="chk1" runat="server" onclick='javascript:SelectAllCheckboxesFromWorkFlowGrid(this, "radGridScoreResults");' />
                </HeaderTemplate>
                <ItemTemplate>
                    <asp:CheckBox ID="chk2" runat="server" onclick="javascript:SelectChildCheckBoxes();" />
                </ItemTemplate>
                <HeaderStyle Width="30px" HorizontalAlign="Center" />
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources: Score, DOW%>" Resizable="false"
                SortExpression="DOW" UniqueName="ghdrAddDOW">
                <ItemStyle Width="100px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="100px" Wrap="True" />
                <ItemTemplate>
                    <asp:Label ID="lblDOW" runat="server" Text='<%# GetDayOfWeekName(Convert.ToString(Eval("DOW"))) %>'
                        ToolTip='<%# GetDayOfWeekName(Convert.ToString(Eval("DOW"))) %>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
 
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false"
                SortExpression="Model_Min_Score" UniqueName="ghdrModelMinScore" ColumnGroupName="ghdrMinScore">
                <ItemStyle Width="80px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblModelMinScore" runat="server" Text='<%# ClientUtil.GetUserFormattedScore(Eval("Model_Min_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Min_Score" UniqueName="ghdrUserMinScoreExp" ColumnGroupName="ghdrMinScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblUserMinScoreExp" runat="server"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Min_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Min_Score" UniqueName="ghdrUserMinScore" ColumnGroupName="ghdrMinScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <telerik:RadNumericTextBox ID="txtUserMinScore" runat="server" Width="100%" EnabledStyle-HorizontalAlign="Right"
                        NumberFormat-DecimalDigits="2" MaxLength="13" MinValue="0" MaxValue="999999999.99" Enabled='<%#Eval("Use_Min_Charge") %>'
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Min_Score"))%>' ClientEvents-OnValueChanged="GetUserMinRecScores">
                        <%-- AutoPostBack="true" OnTextChanged="txtUserMinScore_TextChanged"--%>
                    </telerik:RadNumericTextBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
 
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false"
                SortExpression="Model_Rec_Score" UniqueName="ghdrModelRecScore" ColumnGroupName="ghdrRecScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblModelRecScore" runat="server" Text='<%# ClientUtil.GetUserFormattedScore(Eval("Model_Rec_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Rec_Score" UniqueName="ghdrUserRecScoreExp" ColumnGroupName="ghdrRecScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblUserRecScoreExp" runat="server"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Rec_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Rec_Score" UniqueName="ghdrUserRecScore" ColumnGroupName="ghdrRecScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <telerik:RadNumericTextBox ID="txtUserRecScore" runat="server" Width="100%" EnabledStyle-HorizontalAlign="Right"
                        NumberFormat-DecimalDigits="2" MaxLength="13" MinValue="0" MaxValue="999999999.99"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Rec_Score"))%>' ClientEvents-OnValueChanged="GetUserMinRecScores">
                    </telerik:RadNumericTextBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
 
            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdModelChk" HeaderText="Use Model">
                <ItemStyle Width="60px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="60px" Wrap="True" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:CheckBox ID="chk10" runat="server"  />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdModelChkExp" HeaderText="Use Model" Visible="false">
                <ItemStyle Width="60px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="60px" Wrap="True" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblUseModel" runat="server" Text='<%# Eval("Use_Model") %>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Score Band" Resizable="false" SortExpression="Sort_Expression"
                UniqueName="ghdrScoreBandcolorName" Visible="false">
                <ItemStyle Width="80px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblcolorName" runat="server" Text='<%# Eval("Color_Name")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_BAND %>" Resizable="false" SortExpression="Sort_Expression"
                UniqueName="ghdrScoreBandcolorCode">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center" CssClass="NoHoverSelected"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblcolorCode" runat="server" Text='<%# Eval("Color_Code")%>' ToolTip='<%# Eval("Color_Name")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
 
            <telerik:GridTemplateColumn HeaderText="Is Default Score" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrIsDefaultScore" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblIsDefaultScore" runat="server" Text='<%# Eval("Is_Scored_Enabled")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrFinalModelScoreExp" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblFinalModelSc" runat="server" Text='<%# Eval("Final_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrFinalModelScore" ColumnGroupName="ghdrFinalScore">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFinalModelScore" ForeColor="black" Text='<%#Eval("Final_Model_Score")%>'
                        runat="server" CommandName="ghdrFinalScore"
                        CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false" SortExpression="Final_User_Score"
                UniqueName="ghdrFinalUserScoreExp" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblFinalUserSc" runat="server" Text='<%# Eval("Final_User_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false" SortExpression="Final_User_Score"
                UniqueName="ghdrFinalUserScore" ColumnGroupName="ghdrFinalScore">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFinalUserScore" ForeColor="black" Text='<%#Eval("Final_User_Score")%>'
                        runat="server" CommandName="ghdrFinalScore"
                        CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
 
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_DENSITY %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Density_Model_Score" UniqueName="ghdrRelDensityModelScoreExp" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeDenModelScore" runat="server" Text='<%# Eval("Relative_Density_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_DENSITY %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Density_Model_Score" UniqueName="ghdrRelDensityModelScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeDensityScore" ForeColor="black" Text='<%#Eval("Relative_Density_Model_Score")%>' Enabled='<%# Eval("Is_Scored_Enabled")%>'
                        runat="server" CommandName="RelDensityModel" ToolTip='<%# Eval("Relative_Density_Model_Scale")%>' CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Project" Resizable="false" SortExpression="Score"
                UniqueName="ghdrRelScoreModelScoreExp" Visible="false" ColumnGroupName="ghdrComponentScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeScoreModelScore" runat="server" Text='<%# Eval("Relative_Score_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Project" Resizable="false" SortExpression="Relative_Score_Model_Score"
                UniqueName="ghdrRelScoreModelScore" ColumnGroupName="ghdrComponentScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeScoreScore" ForeColor="black" Text='<%#Eval("Relative_Score_Model_Score")%>'
                        runat="server" CommandName="RelScoremodel" ToolTip='<%#Eval("Relative_Score_Model_Scale")%>'
                        CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, YIELD %>" Resizable="false" SortExpression="Yield_Model_Score"
                UniqueName="ghdrYieldModelScore" ColumnGroupName="ghdrComponentScore" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblComponentYield" runat="server" Text='<%# Eval("Yield_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, PAYMENT %>" Resizable="false" SortExpression="Payment_Model_Score"
                UniqueName="ghdrPaymentModelScoreExp" ColumnGroupName="ghdrComponentScore" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblPaymentModelSc" runat="server" Text='<%# Eval("Payment_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_USAGE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Usage_Model_Score" UniqueName="ghdrRelUsageModelScoreExp" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeUsgeModelScore" runat="server" Text='<%# Eval("Relative_Usage_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_USAGE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Usage_Model_Score" UniqueName="ghdrRelUsageModelScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeUsageModelScore" ForeColor="black" Text='<%#Eval("Relative_Usage_Model_Score")%>'
                        runat="server" CommandName="RelAllotmentUsageModel" ToolTip='<%#Eval("Relative_Usage_Model_Scale")%>'
                        CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, FLT_MKT_SHARE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Flight_Market_Share_Model_Score" UniqueName="ghdrFMSModelScoreExp" Visible="false">
                <ItemStyle Width="90px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="90px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblFMSModelScore" runat="server" Text='<%# Eval("Flight_Market_Share_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, FLT_MKT_SHARE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Flight_Market_Share_Model_Score" UniqueName="ghdrFMSModelScore" Visible="true">
                <ItemStyle Width="115px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="115px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFMSModelScr" ForeColor="black" Text='<%#Eval("Flight_Market_Share_Model_Score")%>'
                        runat="server" CommandName="FMS" ToolTip="Details" CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
        <EditFormSettings>
            <EditColumn UniqueName="EditCommandColumn1">
            </EditColumn>
        </EditFormSettings>
        <CommandItemTemplate>
            <table style="height: 3px;">
                <tr>
                    <td>
                        <asp:LinkButton ID="lbExportToExcel" Class="link margin_right_nav" runat="server" OnClick="btnExportToExcel_Click" ToolTip="<%$ Resources:Common , EXPORT_EXCEL %>" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_excel.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbExportToPDF" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , EXPORT_PDF %>" OnClick="btnExportToPDF_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_pdf.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbExportToCSV" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , EXPORT_CSV %>" OnClick="btnExportToCSV_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_csv.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbPrint" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , PRINT %>" OnClick="btnPrint_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/print.png">
                        </asp:LinkButton>
                    </td>
                </tr>
            </table>
        </CommandItemTemplate>
        <EditFormSettings>
            <EditColumn Visible="false">
            </EditColumn>
        </EditFormSettings>
    </MasterTableView>
    <ClientSettings AllowColumnHide="True" AllowColumnsReorder="False" ReorderColumnsOnClient="False"
        EnableRowHoverStyle="true">
        <Selecting AllowRowSelect="True" />
        <Scrolling AllowScroll="true" UseStaticHeaders="True" />
        <ClientEvents OnGridCreated="radGrid_OnGridCreated" OnCommand="OnGridCommand" />
    </ClientSettings>
    <ExportSettings>
        <Pdf AllowPrinting="true" PageWidth="450mm" PageHeight="210mm" Title="Report Title" ForceTextWrap="true"
            PageFooterMargin="10mm" PageHeaderMargin="10mm" PageLeftMargin="10mm" PageRightMargin="10mm" />
    </ExportSettings>
</telerik:RadGrid>
<telerik:RadGrid ID="radGridScoreResults" runat="server" AllowSorting="True" GridLines="Both" RenderMode="Lightweight"
    AllowMultiRowEdit="false" AllowMultiRowSelection="false" AutoGeneScoreColumns="false" AllowPaging="True"
    OnNeedDataSource="radGridScoreResults_NeedDataSource" OnItemCommand="radGridScoreResults_ItemCommand" OnItemDataBound="radGridScoreResults_ItemDataBound"
    OnPageSizeChanged="radGridScoreResults_PageSizeChanged" OnPageIndexChanged="radGridScoreResults_PageIndexChanged" OnPreRender="radGridScoreResults_PreRender">
    <PagerStyle Mode="NextPScoreNumericAndAdvanced" AlwaysVisible="true" />
    <MasterTableView AllowMultiColumnSorting="False" CommandItemDisplay="Top" DataKeyNames="Score_Components_Model_Id, Score_Components_User_Id"
        HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" ItemStyle-HorizontalAlign="Left" AllowPaging="True" AllowCustomPaging="true"
        ItemStyle-VerticalAlign="Middle" Name="Detail" CssClass="divitem" ItemStyle-Height="21px" AlternatingItemStyle-Height="21px" Width="100%">
        <ColumnGroups>
            <telerik:GridColumnGroup Name="ghdrMinScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Min Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrRecScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Rec Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrFinalScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Final Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup Name="ghdrComponentScore" HeaderStyle-HorizontalAlign="Center"
                HeaderStyle-VerticalAlign="Top" HeaderText="Component Score">
                <HeaderStyle Height="8px" />
            </telerik:GridColumnGroup>
        </ColumnGroups>
        <Columns>
            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdCHK" Visible="true">
                <ItemStyle Width="30px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="30px" Wrap="True" HorizontalAlign="Center" />
                <HeaderTemplate>
                    <asp:CheckBox ID="chk1" runat="server" onclick='javascript:SelectAllCheckboxesFromWorkFlowGrid(this, "radGridScoreResults");' />
                </HeaderTemplate>
                <ItemTemplate>
                    <asp:CheckBox ID="chk2" runat="server" onclick="javascript:SelectChildCheckBoxes();" />
                </ItemTemplate>
                <HeaderStyle Width="30px" HorizontalAlign="Center" />
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources: Score, DOW%>" Resizable="false"
                SortExpression="DOW" UniqueName="ghdrAddDOW">
                <ItemStyle Width="100px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="100px" Wrap="True" />
                <ItemTemplate>
                    <asp:Label ID="lblDOW" runat="server" Text='<%# GetDayOfWeekName(Convert.ToString(Eval("DOW"))) %>'
                        ToolTip='<%# GetDayOfWeekName(Convert.ToString(Eval("DOW"))) %>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
 
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false"
                SortExpression="Model_Min_Score" UniqueName="ghdrModelMinScore" ColumnGroupName="ghdrMinScore">
                <ItemStyle Width="80px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblModelMinScore" runat="server" Text='<%# ClientUtil.GetUserFormattedScore(Eval("Model_Min_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Min_Score" UniqueName="ghdrUserMinScoreExp" ColumnGroupName="ghdrMinScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblUserMinScoreExp" runat="server"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Min_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Min_Score" UniqueName="ghdrUserMinScore" ColumnGroupName="ghdrMinScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <telerik:RadNumericTextBox ID="txtUserMinScore" runat="server" Width="100%" EnabledStyle-HorizontalAlign="Right"
                        NumberFormat-DecimalDigits="2" MaxLength="13" MinValue="0" MaxValue="999999999.99" Enabled='<%#Eval("Use_Min_Charge") %>'
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Min_Score"))%>' ClientEvents-OnValueChanged="GetUserMinRecScores">
                        <%-- AutoPostBack="true" OnTextChanged="txtUserMinScore_TextChanged"--%>
                    </telerik:RadNumericTextBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
 
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false"
                SortExpression="Model_Rec_Score" UniqueName="ghdrModelRecScore" ColumnGroupName="ghdrRecScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblModelRecScore" runat="server" Text='<%# ClientUtil.GetUserFormattedScore(Eval("Model_Rec_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Rec_Score" UniqueName="ghdrUserRecScoreExp" ColumnGroupName="ghdrRecScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblUserRecScoreExp" runat="server"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Rec_Score"))%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false"
                SortExpression="User_Rec_Score" UniqueName="ghdrUserRecScore" ColumnGroupName="ghdrRecScore">
                <ItemStyle Width="70px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <telerik:RadNumericTextBox ID="txtUserRecScore" runat="server" Width="100%" EnabledStyle-HorizontalAlign="Right"
                        NumberFormat-DecimalDigits="2" MaxLength="13" MinValue="0" MaxValue="999999999.99"
                        Text='<%# ClientUtil.GetUserFormattedScore(Eval("User_Rec_Score"))%>' ClientEvents-OnValueChanged="GetUserMinRecScores">
                    </telerik:RadNumericTextBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
 
            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdModelChk" HeaderText="Use Model">
                <ItemStyle Width="60px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="60px" Wrap="True" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:CheckBox ID="chk10" runat="server"  />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn Resizable="true" UniqueName="ghrdModelChkExp" HeaderText="Use Model" Visible="false">
                <ItemStyle Width="60px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="60px" Wrap="True" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblUseModel" runat="server" Text='<%# Eval("Use_Model") %>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Score Band" Resizable="false" SortExpression="Sort_Expression"
                UniqueName="ghdrScoreBandcolorName" Visible="false">
                <ItemStyle Width="80px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblcolorName" runat="server" Text='<%# Eval("Color_Name")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_BAND %>" Resizable="false" SortExpression="Sort_Expression"
                UniqueName="ghdrScoreBandcolorCode">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center" CssClass="NoHoverSelected"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblcolorCode" runat="server" Text='<%# Eval("Color_Code")%>' ToolTip='<%# Eval("Color_Name")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
 
            <telerik:GridTemplateColumn HeaderText="Is Default Score" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrIsDefaultScore" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblIsDefaultScore" runat="server" Text='<%# Eval("Is_Scored_Enabled")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrFinalModelScoreExp" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblFinalModelSc" runat="server" Text='<%# Eval("Final_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, MODEL %>" Resizable="false" SortExpression="Final_Model_Score"
                UniqueName="ghdrFinalModelScore" ColumnGroupName="ghdrFinalScore">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFinalModelScore" ForeColor="black" Text='<%#Eval("Final_Model_Score")%>'
                        runat="server" CommandName="ghdrFinalScore"
                        CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false" SortExpression="Final_User_Score"
                UniqueName="ghdrFinalUserScoreExp" ColumnGroupName="ghdrFinalScore" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblFinalUserSc" runat="server" Text='<%# Eval("Final_User_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, USER %>" Resizable="false" SortExpression="Final_User_Score"
                UniqueName="ghdrFinalUserScore" ColumnGroupName="ghdrFinalScore">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFinalUserScore" ForeColor="black" Text='<%#Eval("Final_User_Score")%>'
                        runat="server" CommandName="ghdrFinalScore"
                        CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
 
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_DENSITY %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Density_Model_Score" UniqueName="ghdrRelDensityModelScoreExp" Visible="false">
                <ItemStyle Width="70px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="70px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeDenModelScore" runat="server" Text='<%# Eval("Relative_Density_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_DENSITY %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Density_Model_Score" UniqueName="ghdrRelDensityModelScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeDensityScore" ForeColor="black" Text='<%#Eval("Relative_Density_Model_Score")%>' Enabled='<%# Eval("Is_Scored_Enabled")%>'
                        runat="server" CommandName="RelDensityModel" ToolTip='<%# Eval("Relative_Density_Model_Scale")%>' CssClass="underline_color">
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Project" Resizable="false" SortExpression="Score"
                UniqueName="ghdrRelScoreModelScoreExp" Visible="false" ColumnGroupName="ghdrComponentScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeScoreModelScore" runat="server" Text='<%# Eval("Relative_Score_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Project" Resizable="false" SortExpression="Relative_Score_Model_Score"
                UniqueName="ghdrRelScoreModelScore" ColumnGroupName="ghdrComponentScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeScoreScore" ForeColor="black" Text='<%#Eval("Relative_Score_Model_Score")%>'
                        runat="server" CommandName="RelScoremodel" ToolTip='<%#Eval("Relative_Score_Model_Scale")%>'
                        CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, YIELD %>" Resizable="false" SortExpression="Yield_Model_Score"
                UniqueName="ghdrYieldModelScore" ColumnGroupName="ghdrComponentScore" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblComponentYield" runat="server" Text='<%# Eval("Yield_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, PAYMENT %>" Resizable="false" SortExpression="Payment_Model_Score"
                UniqueName="ghdrPaymentModelScoreExp" ColumnGroupName="ghdrComponentScore" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Center"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" HorizontalAlign="Center" />
                <ItemTemplate>
                    <asp:Label ID="lblPaymentModelSc" runat="server" Text='<%# Eval("Payment_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_USAGE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Usage_Model_Score" UniqueName="ghdrRelUsageModelScoreExp" Visible="false">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblRelativeUsgeModelScore" runat="server" Text='<%# Eval("Relative_Usage_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, Score_USAGE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Relative_Usage_Model_Score" UniqueName="ghdrRelUsageModelScore">
                <ItemStyle Width="80px" Wrap="False" HorizontalAlign="Right"></ItemStyle>
                <HeaderStyle Width="80px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkRelativeUsageModelScore" ForeColor="black" Text='<%#Eval("Relative_Usage_Model_Score")%>'
                        runat="server" CommandName="RelAllotmentUsageModel" ToolTip='<%#Eval("Relative_Usage_Model_Scale")%>'
                        CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, FLT_MKT_SHARE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Flight_Market_Share_Model_Score" UniqueName="ghdrFMSModelScoreExp" Visible="false">
                <ItemStyle Width="90px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="90px" Wrap="true" />
                <ItemTemplate>
                    <asp:Label ID="lblFMSModelScore" runat="server" Text='<%# Eval("Flight_Market_Share_Model_Score")%>'></asp:Label>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="<%$ Resources:Score, FLT_MKT_SHARE %>" Resizable="false" ColumnGroupName="ghdrComponentScore"
                SortExpression="Flight_Market_Share_Model_Score" UniqueName="ghdrFMSModelScore" Visible="true">
                <ItemStyle Width="115px" Wrap="False"></ItemStyle>
                <HeaderStyle Width="115px" Wrap="true" />
                <ItemTemplate>
                    <asp:LinkButton ID="lnkFMSModelScr" ForeColor="black" Text='<%#Eval("Flight_Market_Share_Model_Score")%>'
                        runat="server" CommandName="FMS" ToolTip="Details" CssClass="underline_color" Enabled='<%# Eval("Is_Scored_Enabled")%>'>
                    </asp:LinkButton>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
        <EditFormSettings>
            <EditColumn UniqueName="EditCommandColumn1">
            </EditColumn>
        </EditFormSettings>
        <CommandItemTemplate>
            <table style="height: 3px;">
                <tr>
                    <td>
                        <asp:LinkButton ID="lbExportToExcel" Class="link margin_right_nav" runat="server" OnClick="btnExportToExcel_Click" ToolTip="<%$ Resources:Common , EXPORT_EXCEL %>" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_excel.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbExportToPDF" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , EXPORT_PDF %>" OnClick="btnExportToPDF_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_pdf.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbExportToCSV" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , EXPORT_CSV %>" OnClick="btnExportToCSV_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/export_to_csv.png">
                        </asp:LinkButton>
                        <asp:LinkButton ID="lbPrint" Class="link margin_right_nav" runat="server" ToolTip="<%$ Resources:Common , PRINT %>" OnClick="btnPrint_Click" ForeColor="White" valign="middle">
                            <img style="vertical-align: middle; border: none;" src="<%=RootUrl%>inc/img-gen/print.png">
                        </asp:LinkButton>
                    </td>
                </tr>
            </table>
        </CommandItemTemplate>
        <EditFormSettings>
            <EditColumn Visible="false">
            </EditColumn>
        </EditFormSettings>
    </MasterTableView>
    <ClientSettings AllowColumnHide="True" AllowColumnsReorder="False" ReorderColumnsOnClient="False"
        EnableRowHoverStyle="true">
        <Selecting AllowRowSelect="True" />
        <Scrolling AllowScroll="true" UseStaticHeaders="True" />
        <ClientEvents OnGridCreated="radGrid_OnGridCreated" OnCommand="OnGridCommand" />
    </ClientSettings>
    <ExportSettings>
        <Pdf AllowPrinting="true" PageWidth="450mm" PageHeight="210mm" Title="Report Title" ForceTextWrap="true"
            PageFooterMargin="10mm" PageHeaderMargin="10mm" PageLeftMargin="10mm" PageRightMargin="10mm" />
    </ExportSettings>
</telerik:RadGrid>

 

Thanks

Vakul

0
Attila Antal
Telerik team
answered on 22 May 2020, 12:16 PM

Hi Vakul,

Thank you for sharing the markup, we managed to replicate the problem. Since the structure of the MultiColumn header is different from the basic structure, the workaround provided in the bug article will not work and we are unable to provide one at this time.

Kind regards,
Attila Antal
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Vakul
Top achievements
Rank 1
answered on 06 Aug 2020, 04:51 AM

Hi Attila Antal,

When we can get this fix. Any update on MultiColumn header export issue ?

 

Regards,

Vakul

0
HrMeibom
Top achievements
Rank 2
answered on 05 Oct 2020, 11:57 AM

Hi Telerik Support,

As many others, I'm also experiencing the same issue, now using the latest shiny version of Telerik.Web.UI.dll (version 2020.2.617). The issue exists for both Excel and PDF exports.
Please, Telerik Support staff, could you give an update about this issue? When can we expect it to be fixed?

Looking forward hearing from you.

Best regards,

Jannik

0
HrMeibom
Top achievements
Rank 2
answered on 05 Oct 2020, 12:10 PM

Just a few supplementing details.

  • The issue exists for both RenderMode="Lightweight" and RenderMode="Auto".
  • For Excel, I'm exporting in .xlsx format.
  • The issue started after implementing support for showing the RadAjaxLoadingPanel1, by following the solution presented here: https://www.telerik.com/support/code-library/show-loading-panel-when-exporting-radgrid
  • Specifically, the introduction of this code snippet in the OnItemCommand event:

    if (e.CommandName.StartsWith("Export"))
    {
    if (!String.IsNullOrEmpty(Request["_downloadToken"]))
    {
    Response.Cookies.Add(new HttpCookie("_downloadToken", Request["_downloadToken"]));
    System.Threading.Thread.Sleep(5000);
    }
    }

I hope this may help identifying the issue.

0
Attila Antal
Telerik team
answered on 05 Oct 2020, 12:23 PM

Hi HrMeibom,

Thank you for sharing your feedback. We are aware of the issue and the cause, but the developer team has their roadmap scheduled ahead. As popularity increases for this particular bug, its priority is changing, therefore, we may take this issue and process it earlier than planned. We can't provide an ETA for the fix at the moment.

Thank you for your understanding and patience!

Regards,
Attila Antal
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
Roger
Top achievements
Rank 1
answered on 20 Jan 2021, 04:14 PM
Has it been fixed in newest version? If not, I would be happy to vote for it.
0
Attila Antal
Telerik team
answered on 25 Jan 2021, 10:56 AM

Hi Roger,

I am afraid this issue has not been fixed yet. Items with the status "Unplanned" are waiting in the queue and will be processed as soon as our developers finish the ones they have planned on their roadmap. Once an item is being worked on, its status will change to "In Development" and an ETA will be shared.

Please feel free to Vote up for the public item at: When sort a grid with LightWeight render mode and export to Excel Biff format the sort expression is added to the header cells

The more votes an item received, will increase the popularity and thus changing its priority.

Regards,
Attila Antal
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Grid
Asked by
Ruchi
Top achievements
Rank 1
Answers by
Nils C.
Top achievements
Rank 1
Ruchi
Top achievements
Rank 1
Kostadin
Telerik team
David
Top achievements
Rank 1
Elena
Top achievements
Rank 1
Thomas
Top achievements
Rank 1
Julien
Top achievements
Rank 1
Lars
Top achievements
Rank 1
Attila Antal
Telerik team
Vakul
Top achievements
Rank 1
HrMeibom
Top achievements
Rank 2
Roger
Top achievements
Rank 1
Share this question
or