Issue in RadGrid Export to Excel functionality

23 posts, 1 answers
  1. Ruchi
    Ruchi avatar
    54 posts
    Member since:
    Apr 2012

    Posted 21 Nov 2015 Link to this post

    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);

  2. Answer
    Nils C.
    Nils C. avatar
    41 posts
    Member since:
    Oct 2009

    Posted 06 Jan 2016 Link to this post

    Hi there.

    Did you find a solution for this yet?

    We are facing the same issue..

  3. Ruchi
    Ruchi avatar
    54 posts
    Member since:
    Apr 2012

    Posted 08 Jan 2016 in reply to Nils C. Link to this post

    Hi Nils,

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

     

    Thanks,

    Ruchi Patel

  4. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 11 Jan 2016 Link to this post

    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
  5. Ruchi
    Ruchi avatar
    54 posts
    Member since:
    Apr 2012

    Posted 14 Jan 2016 in reply to Kostadin Link to this post

    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
  6. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 19 Jan 2016 Link to this post

    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
  7. David
    David avatar
    15 posts
    Member since:
    Aug 2006

    Posted 20 Jan 2016 in reply to Ruchi Link to this post

    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

  8. David
    David avatar
    15 posts
    Member since:
    Aug 2006

    Posted 21 Jan 2016 in reply to David Link to this post

    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", "");
     
        }
     
    }

  9. Elena
    Elena avatar
    2 posts
    Member since:
    Oct 2012

    Posted 21 Mar 2016 Link to this post

    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!
  10. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 24 Mar 2016 Link to this post

    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.
  11. Elena
    Elena avatar
    2 posts
    Member since:
    Oct 2012

    Posted 24 Mar 2016 in reply to Kostadin Link to this post

    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.

  12. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 29 Mar 2016 Link to this post

    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.
  13. Thomas
    Thomas avatar
    1 posts
    Member since:
    Jan 2016

    Posted 15 Sep 2016 Link to this post

    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?

  14. Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 20 Sep 2016 Link to this post

    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.
  15. Julien
    Julien avatar
    9 posts
    Member since:
    Jun 2016

    Posted 08 Sep 2017 Link to this post

    Hi,

    I'm having the same issue.

    Telerik version : 2017.2.711.45

    Exporting to Html Excel

  16. Lars
    Lars avatar
    1 posts
    Member since:
    Aug 2011

    Posted 13 Mar 2019 in reply to Kostadin Link to this post

    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

     

  17. Attila Antal
    Admin
    Attila Antal avatar
    514 posts

    Posted 18 Mar 2019 Link to this post

    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.
  18. Vakul
    Vakul avatar
    3 posts
    Member since:
    Oct 2014

    Posted 13 May Link to this post

    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.

  19. Attila Antal
    Admin
    Attila Antal avatar
    514 posts

    Posted 14 May Link to this post

    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.
  20. Vakul
    Vakul avatar
    3 posts
    Member since:
    Oct 2014

    Posted 19 May in reply to Attila Antal Link to this post

    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:

  21. Attila Antal
    Admin
    Attila Antal avatar
    514 posts

    Posted 19 May Link to this post

    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.
  22. Vakul
    Vakul avatar
    3 posts
    Member since:
    Oct 2014

    Posted 19 May in reply to Attila Antal Link to this post

    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

  23. Attila Antal
    Admin
    Attila Antal avatar
    514 posts

    Posted 22 May Link to this post

    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.
Back to Top