Export to PDF Scaling

11 posts, 0 answers
  1. Chuck
    Chuck avatar
    17 posts
    Member since:
    Oct 2018

    Posted 31 Oct 2018 Link to this post

    Is there a way to Export a RadGrid to PDF and have the PDF content fill more of the page? I have an output set for Letter Landscape. Here is the setup i'm using in the ItemCommand event.

     

                    grdScoreCardDashboard.ExportSettings.Pdf.BorderType = GridPdfSettings.GridPdfBorderType.AllBorders
                    grdScoreCardDashboard.ExportSettings.OpenInNewWindow = True
                    grdScoreCardDashboard.ExportSettings.IgnorePaging = True
                    grdScoreCardDashboard.ExportSettings.Pdf.PageHeight = Unit.Parse("162mm")
                    grdScoreCardDashboard.ExportSettings.Pdf.PageWidth = Unit.Parse("600mm")
                    grdScoreCardDashboard.ExportSettings.Pdf.PageRightMargin = Unit.Parse("10mm")
                    grdScoreCardDashboard.ExportSettings.Pdf.PageLeftMargin = Unit.Parse("10mm")
                    grdScoreCardDashboard.ExportSettings.Pdf.Title = "Score Card"
                    grdScoreCardDashboard.ExportSettings.Pdf.PaperSize = GridPaperSize.Letter
                    grdScoreCardDashboard.ExportSettings.FileName = String.Format("ScoreCardOutput-{0}", DateTime.Now.ToString("yyyyMMddhhmmss"))
                    grdScoreCardDashboard.ExportSettings.Pdf.AllowPrinting = True
                    grdScoreCardDashboard.ExportSettings.Pdf.AllowModify = True
                    grdScoreCardDashboard.ExportSettings.Pdf.AllowCopy = True
                    grdScoreCardDashboard.ExportSettings.ExportOnlyData = False
                    grdScoreCardDashboard.ExportSettings.Pdf.FontType = Telerik.Web.Apoc.Render.Pdf.FontType.Embed

  2. Tsvetomir
    Admin
    Tsvetomir avatar
    197 posts

    Posted 02 Nov 2018 Link to this post

    Hi Chuck,

    I have created a sample project using the provided export settings. As to my observations, the RadGrid control is fitting the exported pdf file. 

    Could you elaborate in further details on the specific scenario you are willing to achieve? This would help me to deliver a more clear-cut solution.

    Kind regards,
    Tsvetomir
    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.
  3. Chuck
    Chuck avatar
    17 posts
    Member since:
    Oct 2018

    Posted 06 Nov 2018 in reply to Tsvetomir Link to this post

    Sorry, I should have included a copy of the output. Looking to scale the output both vertically and horizontally.

     

  4. Chuck
    Chuck avatar
    17 posts
    Member since:
    Oct 2018

    Posted 06 Nov 2018 in reply to Chuck Link to this post

    attachment
  5. Tsvetomir
    Admin
    Tsvetomir avatar
    197 posts

    Posted 07 Nov 2018 Link to this post

    Hi Chuck,

    Thank you for providing those additional details along with a screenshot. 

    Here is one example you can make the grid fit the whole PDF page. In the PreRender event, when exporting apply 100% width for the grid.
    protected void RadGrid1_PreRender(object sender, EventArgs e)
    {
        if (RadGrid1.IsExporting)
        {
            RadGrid1.Width = Unit.Percentage(100);
        }
    }

    You will also need to eliminate the additional space consumed by the page margins. To do that, you can set the PDF page margins accordingly.

    #C - code behind
    protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
    {
        RadGrid1.ExportSettings.Pdf.PageLeftMargin = Unit.Point(-1);
        RadGrid1.ExportSettings.Pdf.PageRightMargin = Unit.Point(-1);
        RadGrid1.ExportSettings.Pdf.PageTopMargin = Unit.Point(-2);
        RadGrid1.ExportSettings.Pdf.PageBottomMargin = Unit.Point(-2);
    }

    It can be set in the markup as well, but I believe that you would like to keep the whole export configuration in the code behind. Nevertheless, the ExportSettings tag should be as follows:

    <ExportSettings>
        <Pdf  PageBottomMargin="0" PageLeftMargin="0" PageRightMargin="0" PageTopMargin="0"></Pdf>
    </ExportSettings>

    Attached, you can find out how the exported file looks like. It is up to your needs how you would configure the margins. 

    Let me know if this is not the exact scenario you are willing to achieve. I would be happy to dig deeper and provide a clear-cut answer based on any additional information you provide me with.

    Kind regards,
    Tsvetomir
    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.
  6. Chuck
    Chuck avatar
    17 posts
    Member since:
    Oct 2018

    Posted 08 Nov 2018 in reply to Tsvetomir Link to this post

    Thank you Tsvetomir,

    That suggestion forced the data to appear on a single page, but I was hoping for a bit more vertical scalling to improve readability. I've attached a preview of the PDF output and you can see the dimensions of the output compared to the page.

  7. Tsvetomir
    Admin
    Tsvetomir avatar
    197 posts

    Posted 12 Nov 2018 Link to this post

    Hi Chuck,

    The properties mentioned in my previous response can be modified according to your needs. As per the attached screenshot, I have used the declaration you have provided and I added the margin properties. 

    Attached to my response, you can find a fully runnable project which demonstrates how the grid occupies the whole page in the exported PDF file.

    Check it out and see what are the crucial differences between the two. If the issue persists, please provide further details on the matter. Sharing the grid declaration would be helpful in troubleshooting the issue.


    Kind regards,
    Tsvetomir
    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.
  8. Chuck
    Chuck avatar
    17 posts
    Member since:
    Oct 2018

    Posted 12 Nov 2018 in reply to Tsvetomir Link to this post

    Followed your guidance line for line but didn't change the export. I have attached the aspx markup within is the grid setup (grdScoreCardDashboard). It's the last tab.

    <%@ Page title="ScoreCard" Language="vb" AutoEventWireup="false" MasterPageFile="~/Common/Site_General.Master" CodeBehind="ScoreCardEntry.aspx.vb" Inherits="ChemtradeGlobalData.ScoreCardEntry" %>
    <%@ Register Src="../UserControls/ctlStatus.ascx"TagName="ctlStatus" TagPrefix="uc1" %> 
    <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
        <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server"  Skin="Default"/>
        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" UpdateInitiatorPanelsOnly="true" ClientEvents-OnRequestStart="requestStart" DefaultLoadingPanelID="RadAjaxLoadingPanel1">
            <AjaxSettings>
                <telerik:AjaxSetting AjaxControlID="cmdLoad">
                    <UpdatedControls> 
                                 
                        <telerik:AjaxUpdatedControl ControlID="usrStatus" />
                        <telerik:AjaxUpdatedControl ControlID="grdScoreCard" />
                        <telerik:AjaxUpdatedControl ControlID="grdEHSMonthlyStats"/>
                        <telerik:AjaxUpdatedControl ControlID="grdScoreCardTitles"/>
                        <telerik:AjaxUpdatedControl ControlID="grdScoreCardFormulaEntry"/>
                    </UpdatedControls>
                </telerik:AjaxSetting>
                <telerik:AjaxSetting AjaxControlID="cmdRun1">
                    <UpdatedControls> 
                                 
                        <telerik:AjaxUpdatedControl ControlID="grdScoreCardDashboard"/>
                    </UpdatedControls>
                </telerik:AjaxSetting>
            </AjaxSettings>
        </telerik:RadAjaxManager>
        <table width="760" cellpadding="2" cellspacing="2" frame="void" border="0" style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px;">
      <tr>
       <td align="left">
                    <uc1:ctlStatus id="usrStatus" runat="server"></uc1:ctlStatus>
        <asp:ValidationSummary id="ValidationSummary1" runat="server" ShowSummary="True" ShowMessageBox="False" CssClass="EditValidatorSummary"></asp:ValidationSummary>
       </td>
      </tr>
            <tr>
                <td id="controlSection" runat="server">
                    <table  cellpadding="2" cellspacing="2" frame="void" border="0">
                        <tr>
          <td align="left" class="EditItemLabel">Location:</td>
          <td align="left"><asp:DropDownList ID="lstLocation" runat="server" CssClass="SmallInput"></asp:DropDownList>
          </td>
         </tr>
                        <tr>
                            <td>Month/Year (MMYYYY)</td>    
                            <td><asp:DropDownList ID="lstMonthYear" runat="server" CssClass="SmallInput"></asp:DropDownList></td>
                            <td></td>
                        </tr>
                        <tr><td></td><td></td></tr>
                            <tr valign="bottom" height="10" align="left">
                <td  height="10" align="left" style="PADDING-RIGHT: 20px; PADDING-BOTTOM: 10px"> 
                                <asp:button id="cmdLoad" runat="server"  Text="Load" CommandName="Load" CssClass="LargeInput" ToolTip="Click to Load ScoreCard"></asp:button>
                            </td>
                                <td height="10" align="left" style="PADDING-RIGHT: 20px; PADDING-BOTTOM: 10px"> 
                                <asp:button id="cmdSaveStatus" Enable="false" runat="server"  Text="Close Month" CommandName="Close" CssClass="LargeInput" ToolTip="Click to Close ScoreCard"></asp:button>
                            </td>
               </tr>
                            <tr valign="bottom" height="10" align="left">
                <td colspan="2" height="10" align="left" style="PADDING-RIGHT: 20px; PADDING-BOTTOM: 10px"> 
                                <asp:Label ID="lbScoreCardStatus" Visible="false" runat="server" ForeColor="White" BackColor="Red" Text="   Score Card is Closed"></asp:Label>           
                            </td>
               </tr>
                    </table>
                </td>
            </tr>
        </table>
        <p></p>
        <p></p><hr />
        <asp:Panel ID="pnlAdvanced" runat="server">
         <telerik:RadTabStrip
                ID="radTabStrip"
                runat="server"
                Skin="Vista"
                MultiPageID="RadMultiMainPage"
                SelectedIndex="3" 
                Align="Justify"
                ReorderTabsOnSelect="True"
                OnTabClick="radTabStrip_TabClick"
                Width="1000px">
                    <Tabs>
                        <telerik:RadTab Text="EHS Monthly Stats"></telerik:RadTab>
                        <telerik:RadTab Text="Score Card" ></telerik:RadTab>
                        <telerik:RadTab Text="Title Maintenance"></telerik:RadTab>
                        <telerik:RadTab Text="Formula Maintenance" Selected="True"></telerik:RadTab>
                        <telerik:RadTab Text="Period Cost Maintenance" Width="500px"></telerik:RadTab>
                        <telerik:RadTab Text="Scorecard Dashboard"></telerik:RadTab>
                    </Tabs>
                    </telerik:RadTabStrip>
                <telerik:RadMultiPage ID="RadMultiMainPage" runat="server" SelectedIndex="3">
                    <telerik:RadPageView ID="tabEHSMonthlyStats" runat="server">
                            <fieldset><legend id="Legend2" runat="server"></legend>
                            <telerik:RadGrid ID="grdEHSMonthlyStats"
                                AutoGenerateColumns="False"
                                AllowMultiRowEdit="true"
                                runat="server"
                                PageSize="15"
                                EnableLinqExpressions="False"
                                AllowAutomaticInserts="True"
                                AlwaysVisible="True"  
                                ShowStatusBar="true"
                                MasterTableView-EditMode="InPlace">
                                                        
                                <AlternatingItemStyle BackColor="#00CCFF" />
                                <ClientSettings>
                                    <Selecting AllowRowSelect="true" />
                                </ClientSettings>
                                <MasterTableView CommandItemDisplay="Top" DataKeyNames="SortOrder" EditMode="Batch" BatchEditingSettings-OpenEditingEvent="None" CommandItemStyle-HorizontalAlign="NotSet" runat="server" EditFormSettings-EditFormType="AutoGenerated" EnableNoRecordsTemplate="true" ShowHeadersWhenNoRecords="true">                               
                                        <NoRecordsTemplate>
                                            <div>No Score Cards found - Please select criteria</div>
                                        </NoRecordsTemplate>
                                        <CommandItemTemplate>                                       
                                            <asp:Button ID="btnSave" Text="Save Items" runat="server" BackColor="Yellow" CommandName="UpdateCommandName" ToolTip="Save all entered Values." Height="40" />    
                                            <asp:Button ID="btnCancel" Text="Cancel" runat="server" Visible="false" CommandName="CancelCommandName"/>                                
                                        </CommandItemTemplate>
                                        <CommandItemSettings                                                                       
                                            ExportToExcelText="Excel"
                                            RefreshText="Refresh"
                                            ShowAddNewRecordButton="false"
                                            ShowExportToExcelButton="false"
                                            ShowRefreshButton="true">
                                        </CommandItemSettings>
                                    <Columns>                                       
                                        <telerik:GridTemplateColumn HeaderText="Title" SortExpression="Title" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" ItemStyle-Width="250px" >
                                            <ItemTemplate>
                                                <asp:Label ID="lbTitle" runat="server" ReadOnly="true" Text='<%# Eval("Title")%>'></asp:Label>  
                                            </ItemTemplate>
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="IsTitle" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="False">
                                            <ItemTemplate>
                                                <asp:TextBox ID="IsTitle" runat="server" Text='<%# Eval("IsTitle")%>' ></asp:TextBox>
                                            </ItemTemplate>
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="Current Month" SortExpression="" ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left" ItemStyle-Width="75px">
                                            <ItemTemplate>
                                                <asp:Label ID="lblOpenMonth" runat="server" Text='<%# Eval("Jan")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtCurrentMonth" runat="server" Text='<%# Bind("Jan")%>'  CssClass="SmallInput" MaxLength="10"></asp:TextBox>
                                            </EditItemTemplate>
                                            <InsertItemTemplate>
                                                <asp:TextBox ID="txtCurrentMonthInsert" runat="server" Text='<%# Bind("Jan")%>'  CssClass="SmallInput" MaxLength="10" ReadOnly="False" ></asp:TextBox>
                                            </InsertItemTemplate>
                                        </telerik:GridTemplateColumn>                                                                                                           
                                    </Columns>    
                                </MasterTableView>
                                <PagerStyle Mode="NextPrevAndNumeric" />
                            </telerik:RadGrid>
                            </fieldset>
                    </telerik:RadPageView>
        <telerik:RadPageView ID="tabScoreCard" runat="server" >
                            <fieldset><legend id="lgdScoreCard" runat="server"></legend>
                            <telerik:RadGrid ID="grdScoreCard"
                                AutoGenerateColumns="False"
                                runat="server"
                                PageSize="15"
                                EnableLinqExpressions="False">
                                <AlternatingItemStyle BackColor="#00CCFF" />
                                <ClientSettings>
                                    <Selecting AllowRowSelect="true" />
                                </ClientSettings>
                                <MasterTableView CommandItemDisplay="Top" DataKeyNames="SortOrder" EditMode="InPlace">
                                        <NoRecordsTemplate>
                                            <div>No Score Cards found for selected criteria</div>
                                        </NoRecordsTemplate>
                                        <CommandItemSettings               
                                            AddNewRecordText=""
                                            ExportToExcelText="Excel"
                                            RefreshText="Refresh"
                                            ShowAddNewRecordButton="false"
                                            ShowExportToExcelButton="true"
                                            ShowRefreshButton="true">
                                        </CommandItemSettings>
                                    <Columns>                                       
                                        <telerik:GridTemplateColumn HeaderText="Title" SortExpression="Title" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="txtTitle" runat="server" ReadOnly="true" Text='<%# Eval("Title")%>' Width="300px"></asp:Label>  
                                            </ItemTemplate>
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="IsTitle" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="False">
                                            <ItemTemplate>
                                                <asp:TextBox ID="IsTitle" runat="server" Text='<%# Eval("IsTitle")%>' ></asp:TextBox>
                                            </ItemTemplate>
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="Jan" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblJanuary" runat="server" Text='<%# Eval("Jan")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtJan" runat="server" Text='<%# Bind("Jan")%>'  CssClass="SmallInput" MaxLength="5"></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="Feb" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblFeb" runat="server" Text='<%# Eval("Feb")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtFeb" runat="server" Text='<%# Bind("Feb")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>  
                                        <telerik:GridTemplateColumn HeaderText="Mar" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblMarch" runat="server" Text='<%# Eval("Mar")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtMarch" runat="server" Text='<%# Bind("Mar")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="Apr" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblApril" runat="server" Text='<%# Eval("Apr")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtApril" runat="server" Text='<%# Bind("Apr")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>  
                                        <telerik:GridTemplateColumn HeaderText="May" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblMay" runat="server" Text='<%# Eval("May")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtMay" runat="server" Text='<%# Bind("May")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="Jun" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblJun" runat="server" Text='<%# Eval("Jun")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtJun" runat="server" Text='<%# Bind("Jun")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>  
                                        <telerik:GridTemplateColumn HeaderText="Jul" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblJul" runat="server" Text='<%# Eval("Jul")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtJul" runat="server" Text='<%# Bind("Jul")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="Aug" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblAug" runat="server" Text='<%# Eval("Aug")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtAug" runat="server" Text='<%# Bind("Aug")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>                                          
                                        <telerik:GridTemplateColumn HeaderText="Sept" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblSept" runat="server" Text='<%# Eval("Sep")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtSept" runat="server" Text='<%# Bind("Sep")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>                                         
                                        <telerik:GridTemplateColumn HeaderText="Oct" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblOct" runat="server" Text='<%# Eval("Oct")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtOct" runat="server" Text='<%# Bind("Oct")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="Nov" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblNov" runat="server" Text='<%# Eval("Nov")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtNov" runat="server" Text='<%# Bind("Nov")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>  
                                        <telerik:GridTemplateColumn HeaderText="Dec" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblDec" runat="server" Text='<%# Eval("Dec")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtDec" runat="server" Text='<%# Bind("Dec")%>'  CssClass="SmallInput" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>    
                                        <telerik:GridTemplateColumn HeaderText="Total" SortExpression="" ItemStyle-VerticalAlign="Top" Visible="false" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblIsManual" runat="server" Text='<%# Eval("IsManual")%>' Visible="false" ></asp:Label>
                                            </ItemTemplate>
                                        </telerik:GridTemplateColumn>                                                                       
                                        <telerik:GridTemplateColumn HeaderText="Total" SortExpression="" ItemStyle-VerticalAlign="Top" Visible="false" >
                                            <ItemTemplate>
                                                <asp:Label ID="lblTotal" runat="server" Text='<%# Eval("Dec")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtTotal" runat="server" Text='<%# Bind("Dec")%>'  CssClass="SmallInput" Visible="false" ReadOnly="true" ></asp:TextBox>
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn UniqueName="colUpdateButtons" Visible="true">
                                            <ItemTemplate>
                                                <asp:LinkButton ID="btnEdit" runat="server" Text="Edit" CommandName="Edit" tooltip="Click to edit Line Values" ></asp:LinkButton>                                                                              
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:LinkButton ID="btnUpdate" runat="server" Text="Accept" CommandName="Update" tooltip="Click to edit Line Values"></asp:LinkButton>                                                                                                                                                                                    
                                            </EditItemTemplate>
                                        </telerik:GridTemplateColumn>                                                                                                            
                                        </Columns>    
                                </MasterTableView>
                                <PagerStyle Mode="NextPrevAndNumeric" />
                            </telerik:RadGrid>
                            </fieldset>
        </telerik:RadPageView>
                    <telerik:RadPageView ID="tabTitleEntry" runat="server">
                            <fieldset><legend id="LegendTitleEntry" runat="server"></legend>
                            <telerik:RadGrid
                                ID="grdScoreCardTitles"
                                AutoGenerateColumns="False"
                                runat="server"
                                PageSize="75"
                                EnableLinqExpressions="False"
                                AllowAutomaticInserts="True"
                                MasterTableView-EditMode="InPlace"
                                RenderMode="Lightweight"
                                AllowAutomaticUpdates="true"
                                AllowAutomaticDeletes="true"
                                AllowSorting="True"
                                AllowPaging="True"
                                AllowMultiRowSelection="True"
                                AllowMultiRowEdit="True"
                                >
                                <AlternatingItemStyle BackColor="#00CCFF" />
                                <ClientSettings>
                                    <Selecting AllowRowSelect="true" />
                                </ClientSettings>
                                <MasterTableView CommandItemDisplay="Top" DataKeyNames="SortOrder" BatchEditingSettings-OpenEditingEvent="None" CommandItemStyle-HorizontalAlign="NotSet" runat="server" EditFormSettings-EditFormType="AutoGenerated">
                                        <NoRecordsTemplate>
                                            <div>No Score Cards found for selected criteria</div>
                                        </NoRecordsTemplate>
                                        <BatchEditingSettings OpenEditingEvent="None" />
                                        <CommandItemTemplate>
                                            <asp:Button ID="btnAddNew" Text="Add new item" runat="server" CommandName="InitInsert" />
                                            <asp:Button ID="btnSave" Text="Save Items" runat="server" CommandName="UpdateCommandName" />    
                                            <asp:Button ID="btnCancel" Text="Cancel" runat="server" CommandName="CancelCommandName"/>                                
                                        </CommandItemTemplate>
                                        <CommandItemSettings               
                                                            AddNewRecordText="Add New Title"
                                                            ExportToExcelText="Excel"
                                                            RefreshText="Refresh"
                                                            ShowAddNewRecordButton="true"
                                                            ShowExportToExcelButton="true"
                                                            ShowRefreshButton="true">
                                        </CommandItemSettings>
                                    <Columns>  
                                        <telerik:GridTemplateColumn HeaderText="SortOrder" SortExpression="" ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left">
                                            <ItemTemplate>
                                                <asp:Label ID="lblSortOrder" runat="server" Text='<%# Eval("SortOrder")%>' ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtSortOrder" runat="server" Text='<%# Bind("SortOrder")%>'  CssClass="SmallInput" MaxLength="5"></asp:TextBox>
                                            </EditItemTemplate>
                                            <InsertItemTemplate>
                                                <asp:TextBox ID="txtSortOrderInsert" runat="server" Text='<%# Bind("SortOrder")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False" ></asp:TextBox>
                                            </InsertItemTemplate>
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>                                                                          
                                        <telerik:GridTemplateColumn HeaderText="Title" SortExpression="Title" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                            <ItemTemplate>
                                                <asp:Label ID="lbTitle" runat="server" ReadOnly="true" Text='<%# Eval("Title")%>' min-width="100%" min-height="100%" width="100%"></asp:Label>  
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtTitle" runat="server" Text='<%# Bind("Title")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False" min-width="100%" min-height="100%" width="100%"></asp:TextBox>
                                            </EditItemTemplate>
                                            <InsertItemTemplate>
                                                <asp:TextBox ID="txtTitleInsert" runat="server" Text='<%# Bind("Title")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False" min-width="100%" min-height="100%" width="100%"></asp:TextBox>
                                            </InsertItemTemplate>
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="IsTitle" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True">
                                            <ItemTemplate>
                                                <asp:DropDownList ID="lstIsTitle" runat="server"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                    <asp:ListItem style="background-color:green" Text="Row" Value="0" Selected=true></asp:ListItem>
                                                    <asp:ListItem style="background-color:yellow" Text="Title" Value="1"></asp:ListItem>
                                                    <asp:ListItem style="background-color:red" Text="Hide" Value="2"></asp:ListItem>
                                                </asp:DropDownList>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:DropDownList ID="lstIsTitleEdit" runat="server"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                    <asp:ListItem style="background-color:green" Text="Row" Value="0" Selected=true></asp:ListItem>
                                                    <asp:ListItem style="background-color:yellow" Text="Title" Value="1"></asp:ListItem>
                                                    <asp:ListItem style="background-color:red" Text="Hide" Value="2"></asp:ListItem>
                                                </asp:DropDownList>
                                            </EditItemTemplate>
                                            <InsertItemTemplate>
                                                <asp:DropDownList ID="IsTitleInsert" runat="server"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                    <asp:ListItem style="background-color:green" Text="Row" Value="0" Selected=true></asp:ListItem>
                                                    <asp:ListItem style="background-color:yellow" Text="Title" Value="1"></asp:ListItem>
                                                    <asp:ListItem style="background-color:red" Text="Hide" Value="2"></asp:ListItem>
                                                </asp:DropDownList>
                                            </InsertItemTemplate>
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="IsManual" SortExpression="IsManual" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True">
                                            <ItemTemplate>
                                                <asp:DropDownList ID="lstIsManual" runat="server"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px" ToolTip="Do you wish to have this Title Displayed in the EHS Monthly Stats Tab">
                                                    <asp:ListItem  Text="-Select-" Value="-1"></asp:ListItem>
                                                    <asp:ListItem  Text="No" Value="0" ></asp:ListItem>
                                                    <asp:ListItem  Text="Yes" Value="1"></asp:ListItem>
                                                </asp:DropDownList>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:DropDownList ID="lstIsManualEdit" runat="server"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                    <asp:ListItem  Text="-Select-" Value="-1"></asp:ListItem>
                                                    <asp:ListItem  Text="No" Value="0" ></asp:ListItem>
                                                    <asp:ListItem  Text="Yes" Value="1"></asp:ListItem>
                                                </asp:DropDownList>
                                            </EditItemTemplate>
                                            <InsertItemTemplate>
                                                <asp:DropDownList ID="IstIsManualInsert" runat="server"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                    <asp:ListItem  Text="-Select-" Value="-1"></asp:ListItem>
                                                    <asp:ListItem  Text="No" Value="0" ></asp:ListItem>
                                                    <asp:ListItem  Text="Yes" Value="1"></asp:ListItem>
                                                </asp:DropDownList>
                                            </InsertItemTemplate>
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>

                                        <telerik:GridTemplateColumn HeaderText="Title Tooltip"  ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True">
                                            <ItemTemplate>
                                                <asp:TextBox ID="lstToolTip" runat="server" Text='<%# Bind("TitleToolTip")%>' CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="175px" ToolTip="The text contained here will be displayed once the users mouse is hovered over Title." Rows="3" TextMode="MultiLine" />
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="lstToolTipEdit" runat="server" Text='<%# Bind("TitleToolTip")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="175px" ToolTip="The text contained here will be displayed once the users mouse is hovered over Title." Rows="3" TextMode="MultiLine" />
                                            </EditItemTemplate>
                                            <InsertItemTemplate>
                                                <asp:TextBox ID="IstToolTipInsert" runat="server" Text='<%# Bind("TitleToolTip")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="175px" ToolTip="The text contained here will be displayed once the users mouse is hovered over Title." Rows="3" TextMode="MultiLine" />                                           
                                            </InsertItemTemplate>
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn UniqueName="colUpdateButtons" Visible="true">
                                            <InsertItemTemplate>
                                                <asp:LinkButton ID="btnAcceptAll" runat="server" Text="Accept for All" CommandName="AcceptAll" tooltip="Click to accept Line Values at all Locations" ></asp:LinkButton>  
                                                <asp:LinkButton ID="btnAcceptPer" runat="server" Text="Accept for " CommandName="Accept" tooltip="Click to accept Line Values for this Location" ></asp:LinkButton> 
                                                <asp:LinkButton ID="btnCancel" runat="server" Text="Cancel" CommandName="CancelCommandName" tooltip="Click to Cancel"></asp:LinkButton>                                                                                                                                                                                    
                                            </InsertItemTemplate>
                                        </telerik:GridTemplateColumn>                                                                                                                                              
                                    </Columns>    
                                </MasterTableView>
                                <PagerStyle Mode="NextPrevAndNumeric" />
                                <FilterMenu RenderMode="Lightweight">
                                </FilterMenu>
                                <HeaderContextMenu RenderMode="Lightweight">
                                </HeaderContextMenu>
                            </telerik:RadGrid>
                            </fieldset>
                    </telerik:RadPageView>           
                    <telerik:RadPageView ID="tabScoreCardFormulaEntry" runat="server">
                        <fieldset><legend id="LegendScoreCardFormulaEntry" runat="server"></legend>
                        <telerik:RadGrid
                            ID="grdScoreCardFormulaEntry"
                            AutoGenerateColumns="False"
                            runat="server"
                            PageSize="75"
                            EnableLinqExpressions="False"
                            AllowAutomaticInserts="True"
                            MasterTableView-EditMode="InPlace"
                            RenderMode="Lightweight"
                            AllowAutomaticUpdates="true"
                            AllowAutomaticDeletes="true"
                            AllowSorting="True"
                            AllowPaging="True"
                            AllowMultiRowSelection="True"
                            AllowMultiRowEdit="True"                     
                            >
                            <AlternatingItemStyle BackColor="#00CCFF" />
                            <ClientSettings>
                                <Selecting AllowRowSelect="true" />
                            </ClientSettings>
                            <MasterTableView CommandItemDisplay="Top" DataKeyNames="SortOrder, LocationCode" BatchEditingSettings-OpenEditingEvent="None" CommandItemStyle-HorizontalAlign="NotSet" runat="server" EditFormSettings-EditFormType="AutoGenerated" >
                                    <NoRecordsTemplate>
                                        <div>No Score Cards found for selected criteria</div>
                                    </NoRecordsTemplate>
                                    <CommandItemTemplate>
                                        <%--<asp:Button ID="btnAddNew" Text="Add new item" runat="server" CommandName="InitInsert" />--%>
                                        <asp:Button ID="btnSave" Text="Save Items" runat="server" CommandName="UpdateCommandName" />    
                                        <%--<asp:Button ID="btnCancel" Text="Cancel" runat="server" CommandName="CancelCommandName"/>   --%>                             
                                    </CommandItemTemplate>
                                    <CommandItemSettings               
                                                        AddNewRecordText="Add New Formula"
                                                        ExportToExcelText="Excel"
                                                        RefreshText="Refresh"
                                                        ShowAddNewRecordButton="true"
                                                        ShowExportToExcelButton="true"
                                                        ShowRefreshButton="true">
                                    </CommandItemSettings>
                                <Columns>  
                                    <telerik:GridTemplateColumn HeaderText="SortOrder" SortExpression="" ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left">
                                        <ItemTemplate>
                                            <asp:Label ID="lblSortOrder" runat="server" Text='<%# Eval("SortOrder")%>' width="50px" ></asp:Label>
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtSortOrder" runat="server" Text='<%# Bind("SortOrder")%>'  CssClass="SmallInput" width="50px" MaxLength="5"></asp:TextBox>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="txtSortOrderInsert" runat="server" Text='<%# Bind("SortOrder")%>'  CssClass="SmallInput" width="50px" MaxLength="5" ReadOnly="False" ></asp:TextBox>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>   
                                                                                                              
                                    <telerik:GridTemplateColumn HeaderText="Formula Name" SortExpression="Title" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>
                                            <asp:Label ID="lbFormulaName" runat="server" ReadOnly="true" Text='<%# Eval("Name")%>' width="50%"></asp:Label>  
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtFormulaName" runat="server" Text='<%# Bind("Name")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False"  width="100%"></asp:TextBox>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="txtFormulaNameInsert" runat="server" Text='<%# Bind("Name")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False"  width="100%"></asp:TextBox>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="Location" SortExpression="Location" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>                                           
                                            <asp:DropDownList ID="lbLocation" runat="server" DataValueField="LocationCode"  DataTextField="Location"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="100%"/>                                                                                  
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:DropDownList ID="lstLocationEdit" runat="server" DataValueField="LocationCode" DataTextField="Location"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="100%"/>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:DropDownList ID="lstLocationInsert" runat="server" DataValueField="LocationCode" DataTextField="Location"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="100%"/>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="Expression" SortExpression="Expression" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>
                                            <asp:Label ID="lbExpression" runat="server" ReadOnly="true" Text='<%# Eval("Expression")%>'  width="100%"></asp:Label>  
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtExpression" runat="server" Text='<%# Bind("Expression")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False"  width="100%"></asp:TextBox>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="txtExpressionInsert" runat="server" Text='<%# Bind("Expression")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False" min-width="100%" min-height="100%" width="100%"></asp:TextBox>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="Level 1" SortExpression="Level1" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>
                                            <asp:Label ID="lbLevel1Label" runat="server" ReadOnly="true" Text='<%# Eval("Level1Label")%>'  width="100%"></asp:Label>  
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtLevel1Label" runat="server" Text='<%# Bind("Level1Label")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False"  width="100%"></asp:TextBox>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="txtLevel1LabelInsert" runat="server" Text='<%# Bind("Level1Label")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False" min-width="100%" min-height="100%" width="100%"></asp:TextBox>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="Level 1 Color" SortExpression="Level1Color" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>                                           
                                            <asp:DropDownList ID="lbLevel1Color" runat="server" DataValueField="Level1Color"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                <asp:ListItem style="background-color:white" Text="-Select-" Value="" Selected=true></asp:ListItem>
                                                <asp:ListItem style="background-color:green" Text="Green" Value="Green" ></asp:ListItem>
                                                <asp:ListItem style="background-color:yellow" Text="Yellow" Value="Yellow"></asp:ListItem>
                                                <asp:ListItem style="background-color:red" Text="Red" Value="Red"></asp:ListItem>
                                                <asp:ListItem style="background-color:Gray" Text="Gray" Value="Gray"></asp:ListItem>
                                            </asp:DropDownList>                                            
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:DropDownList ID="lstLevel1Color" runat="server" DataValueField="Level1Color"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                <asp:ListItem style="background-color:white" Text="-Select-" Value="" Selected=true></asp:ListItem>
                                                <asp:ListItem style="background-color:green" Text="Green" Value="Green" ></asp:ListItem>
                                                <asp:ListItem style="background-color:yellow" Text="Yellow" Value="Yellow"></asp:ListItem>
                                                <asp:ListItem style="background-color:red" Text="Red" Value="Red"></asp:ListItem>
                                                <asp:ListItem style="background-color:Gray" Text="Gray" Value="Gray"></asp:ListItem>
                                            </asp:DropDownList>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:DropDownList ID="lstLevel1ColorInsert" runat="server"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                <asp:ListItem style="background-color:white" Text="-Select-" Value="" Selected=true></asp:ListItem>
                                                <asp:ListItem style="background-color:green" Text="Green" Value="Green"></asp:ListItem>
                                                <asp:ListItem style="background-color:yellow" Text="Yellow" Value="Yellow"></asp:ListItem>
                                                <asp:ListItem style="background-color:red" Text="Red" Value="Red"></asp:ListItem>
                                                <asp:ListItem style="background-color:Gray" Text="Gray" Value="Gray"></asp:ListItem>
                                            </asp:DropDownList>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="Level 1 Expression" SortExpression="Level1Lower" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>
                                            <asp:Label ID="lbLevel1Lower" runat="server" ReadOnly="true" Text='<%# Eval("Level1Lower")%>'  width="50%"></asp:Label>  
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtLevel1Lower" runat="server" Text='<%# Bind("Level1Lower")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False"  width="50%"></asp:TextBox>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="txtLevel1LowerInsert" runat="server" Text='<%# Bind("Level1Lower")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False"  width="50%"></asp:TextBox>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="Level 2" SortExpression="Level2" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>
                                            <asp:Label ID="lbLevel2Label" runat="server" ReadOnly="true" Text='<%# Eval("Level2Label")%>'  width="100%"></asp:Label>  
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtLevel2Label" runat="server" Text='<%# Bind("Level2Label")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False"  width="100%"></asp:TextBox>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="txtLevel2LabelInsert" runat="server" Text='<%# Bind("Level2Label")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False" width="50%"></asp:TextBox>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="Level 2 Color" SortExpression="Level2Color" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>                                           
                                            <asp:DropDownList ID="lbLevel2Color" runat="server" DataValueField="Level2Color"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                <asp:ListItem style="background-color:white" Text="-Select-" Value="" Selected=true></asp:ListItem>
                                                <asp:ListItem style="background-color:green" Text="Green" Value="Green"></asp:ListItem>
                                                <asp:ListItem style="background-color:yellow" Text="Yellow" Value="Yellow"></asp:ListItem>
                                                <asp:ListItem style="background-color:red" Text="Red" Value="Red"></asp:ListItem>
                                                <asp:ListItem style="background-color:Gray" Text="Gray" Value="Gray"></asp:ListItem>
                                            </asp:DropDownList>
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:DropDownList ID="lstLevel2Color" runat="server" DataValueField="Level2Color"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                <asp:ListItem style="background-color:white" Text="-Select-" Value="" Selected=true></asp:ListItem>
                                                <asp:ListItem style="background-color:green" Text="Green" Value="Green"></asp:ListItem>
                                                <asp:ListItem style="background-color:yellow" Text="Yellow" Value="Yellow"></asp:ListItem>
                                                <asp:ListItem style="background-color:red" Text="Red" Value="Red"></asp:ListItem>
                                                <asp:ListItem style="background-color:Gray" Text="Gray" Value="Gray"></asp:ListItem>
                                            </asp:DropDownList>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:DropDownList ID="lstLevel2ColorInsert" runat="server"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="75px">
                                                <asp:ListItem style="background-color:white" Text="-Select-" Value="" Selected=true></asp:ListItem>
                                                <asp:ListItem style="background-color:green" Text="Green" Value="Green"></asp:ListItem>
                                                <asp:ListItem style="background-color:yellow" Text="Yellow" Value="Yellow"></asp:ListItem>
                                                <asp:ListItem style="background-color:red" Text="Red" Value="Red"></asp:ListItem>
                                                <asp:ListItem style="background-color:Gray" Text="Gray" Value="Gray"></asp:ListItem>
                                            </asp:DropDownList>                                       
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="Level 2 Expression" SortExpression="Level2Lower" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>
                                            <asp:Label ID="lbLevel2Lower" runat="server" ReadOnly="true" Text='<%# Eval("Level2Lower")%>'  width="50%"></asp:Label>  
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtLevel2Lower" runat="server" Text='<%# Bind("Level2Lower")%>'  CssClass="SmallInput"  ReadOnly="False"  width="50%"></asp:TextBox>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="txtLevel2LowerInsert" runat="server" Text='<%# Bind("Level2Lower")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False" width="50%"></asp:TextBox>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>


                                    <telerik:GridTemplateColumn UniqueName="colUpdateButtons" Visible="true">
                                        <InsertItemTemplate>
                                            <asp:LinkButton ID="btnAcceptAll" runat="server" Text="Accept" CommandName="AcceptAll" tooltip="Click to accept Line Values at all Locations" ></asp:LinkButton>                                           
                                            <asp:LinkButton ID="btnCancel" runat="server" Text="Cancel" CommandName="CancelCommandName" tooltip="Click to Cancel"></asp:LinkButton>                                                                                                                                                                                    
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>                                                                                                                                              
                                </Columns>    
                            </MasterTableView>
                            <PagerStyle Mode="NextPrevAndNumeric" />
                        </telerik:RadGrid>
                        </fieldset>
                    </telerik:RadPageView>                           
                    <telerik:RadPageView ID="tabCostEntry" runat="server">
                        <table width="50%" >
                            <tr>
                                <td align="Left"><asp:Label ID="lbCurrentMonthYear"  runat="server" Text="Current Month/Year:"></asp:Label></td> 
                                <td align="left">
                                    <asp:DropDownList ID="lstCurrentMonthYear" runat="server" CssClass="SmallInput"></asp:DropDownList>
                                </td>
                                <td align="Left"><asp:button id="btnCurrentCosts" runat="server"  Text="Load Costs" CommandName="cmdGetCosts" CssClass="LargeInput" ToolTip="Click to Load Current Month\Year Financial Costs"></asp:button></td>
                            </tr>
                        </table>
                        <fieldset><legend id="LegendCostEntry" runat="server"></legend>
                        <telerik:RadGrid
                            ID="grdScoreCardCost"
                            AutoGenerateColumns="False"
                            runat="server"
                            PageSize="75"
                            EnableLinqExpressions="False"
                            AllowAutomaticInserts="True"
                            MasterTableView-EditMode="InPlace"
                            RenderMode="Lightweight"
                            AllowAutomaticUpdates="true"
                            AllowAutomaticDeletes="true"
                            AllowSorting="True"
                            AllowPaging="True"
                            AllowMultiRowSelection="False"
                            AllowMultiRowEdit="True"
                            Width="500px"
                            >
                            <AlternatingItemStyle BackColor="#00CCFF" />
                            <ClientSettings>
                                <Selecting AllowRowSelect="true" />
                            </ClientSettings>
                            <MasterTableView CommandItemDisplay="Top" DataKeyNames="LocalSortOrder,LocationCode,Year,Month" BatchEditingSettings-OpenEditingEvent="None" CommandItemStyle-HorizontalAlign="NotSet" runat="server" EditFormSettings-EditFormType="AutoGenerated">
                                    <NoRecordsTemplate>
                                        <div>No Score Cards found for selected criteria</div>
                                    </NoRecordsTemplate>
                                    <BatchEditingSettings OpenEditingEvent="None" />
                                    <CommandItemTemplate>
                                        <asp:Button ID="btnAddNew" Text="Add new item" runat="server" CommandName="InitInsert" />
                                        <asp:Button ID="btnSave" Text="Save Items" runat="server" CommandName="UpdateCommandName" />    
                                        <asp:Button ID="btnCancel" Text="Cancel" runat="server" CommandName="CancelCommandName"/>                                
                                    </CommandItemTemplate>
                                    <CommandItemSettings               
                                                        AddNewRecordText="Add New Title"
                                                        ExportToExcelText="Excel"
                                                        RefreshText="Refresh"
                                                        ShowAddNewRecordButton="true"
                                                        ShowExportToExcelButton="true"
                                                        ShowRefreshButton="true">
                                    </CommandItemSettings>
                                <Columns>  
                                        <telerik:GridTemplateColumn HeaderText="Sequence" SortExpression="" ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left" DataType="System.Double" >
                                            <ItemTemplate>
                                                <asp:Label ID="lbLocalSortOrder" runat="server" Text='<%# Eval("LocalSortOrder")%>' Width="50px" ></asp:Label>
                                            </ItemTemplate>
                                            <EditItemTemplate>
                                                <asp:TextBox ID="txtLocalSortOrder" runat="server" Text='<%# Bind("LocalSortOrder")%>'  CssClass="SmallInput" MaxLength="5" Width="50px"></asp:TextBox>
                                            </EditItemTemplate>
                                            <InsertItemTemplate>
                                                <asp:TextBox ID="txtLocalSortOrderInsert" runat="server" Text='<%# Bind("LocalSortOrder")%>'  CssClass="SmallInput" MaxLength="100" ReadOnly="False"  Width="50px"></asp:TextBox>
                                            </InsertItemTemplate>
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>                                
                                                                                                                                     
                                                                                                 
                                    <telerik:GridTemplateColumn HeaderText="Location" SortExpression="Location" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>
                                            <asp:Label ID="lbCostLocation" runat="server" Text='<%# Eval("LocationCode")%>' Width="150px"  DataValueField = "LocationCode" DataTextField = "Location" ></asp:Label>
                                        </ItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:DropDownList ID="lstLocationCostInsert" runat="server"  CssClass="SmallInput" MaxLength="100" ReadOnly="False" Width="150px" DataValueField = "LocationCode" DataTextField = "Location"/>
                                        </InsertItemTemplate>                                
                                    </telerik:GridTemplateColumn>
                                    <telerik:GridTemplateColumn HeaderText="Month Cost" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>
                                            <asp:Label ID="lbMonthCost" runat="server" Text='<%# Eval("MonthCost")%>' ></asp:Label>
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtMonthCost" runat="server" Text='<%# Bind("MonthCost")%>'  CssClass="SmallInput" ></asp:TextBox>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="txtMonthCostInsert" runat="server" Text='<%# Bind("MonthCost")%>'  CssClass="SmallInput" ></asp:TextBox>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>  
                                    <telerik:GridTemplateColumn HeaderText="YTD Value" SortExpression="" ItemStyle-VerticalAlign="Top" >
                                        <ItemTemplate>
                                            <asp:Label ID="lbYTDCost" runat="server" Text='<%# Eval("YTDCost")%>' ></asp:Label>
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox ID="txtYTDCost" runat="server" Text='<%# Bind("YTDCost")%>'  CssClass="SmallInput" ></asp:TextBox>
                                        </EditItemTemplate>
                                        <InsertItemTemplate>
                                            <asp:TextBox ID="txtYTDCostInsert" runat="server" Text='<%# Bind("YTDCost")%>'  CssClass="SmallInput" ></asp:TextBox>
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>    
                                    <telerik:GridTemplateColumn UniqueName="colUpdateButtons" Visible="true">
                                        <InsertItemTemplate>
                                            <asp:LinkButton ID="btnAcceptAll" runat="server" Text="Accept" CommandName="AcceptAll" tooltip="Click to accept Line Values" ></asp:LinkButton>  
                                            <asp:LinkButton ID="btnCancel" runat="server" Text="Cancel" CommandName="CancelCommandName" tooltip="Click to Cancel"></asp:LinkButton>                                                                                                                                                                                    
                                        </InsertItemTemplate>
                                    </telerik:GridTemplateColumn>                                                                                                                                                                                
                                                                                                                                                
                                </Columns>    
                            </MasterTableView>
                            <PagerStyle Mode="NextPrevAndNumeric" />
                            <FilterMenu RenderMode="Lightweight">
                            </FilterMenu>
                            <HeaderContextMenu RenderMode="Lightweight">
                            </HeaderContextMenu>
                        </telerik:RadGrid>
                        </fieldset>
                </telerik:RadPageView>               
                    <telerik:RadPageView ID="tabScoreCardDashboard" runat="server">
                       
                        <table width="100%" >
                            <tr>
                                <td align="right"><asp:Label ID="lbCompany"  runat="server" Text="Business:" OnSelectedIndexChanged="lbCompany_SelectedIndexChanged"></asp:Label> </td>
                                <td align="left"><asp:DropDownList ID="lstCompany" Enabled="False" AutoPostBack="true" runat="server" CssClass="SmallInput" Width="150px" OnSelectedIndexChanged="lstCompany_SelectedIndexChanged"></asp:DropDownList></td>
                                <td align="right"><asp:Label ID="lbRegionalManager"  runat="server" Text="Regional Manager:" ></asp:Label> </td>  
                                <td align="left"><asp:DropDownList ID="lstRegionalManager" Enabled="True" AutoPostBack="true" runat="server" CssClass="SmallInput" Width="150px" OnSelectedIndexChanged="lbRegionalManager_SelectedIndexChanged"></asp:DropDownList></td>
                                <td align="right"><asp:Label ID="lbLocation"  runat="server" Text="Plant Location:"></asp:Label> </td> 
                                <td align="left"><asp:DropDownList ID="lstLocation1" runat="server" CssClass="SmallInput" Width="150px" ></asp:DropDownList></td>
                                <td align="right"><asp:Label ID="lbParamDate"  runat="server" Text="Thru Date:"></asp:Label></td> 
                                <td valign="middle"><asp:DropDownList ID="lstReportRunDate" runat="server" CssClass="SmallInput"></asp:DropDownList></td>
                                <td align="Left"><asp:button id="btnRun" runat="server"  Text="Run" CommandName="RunReport" CssClass="LargeInput" ToolTip="Click to Run ScoreCard Dashboard"></asp:button></td>
                            </tr>
                        </table>
                       

                        <fieldset><legend id="Legend1" runat="server"></legend>     
                            <telerik:RadGrid
                                ID="grdScoreCardDashboard"
                                AutoGenerateColumns="False"
                                runat="server"
                                PageSize="75"
                                ShowStatusBr="True"                           
                                EnableLinqExpressions="False"
                                AllowAutomaticInserts="True"
                                MasterTableView-EditMode="InPlace"
                                RenderMode="Lightweight"
                                AllowAutomaticUpdates="true"
                                AllowAutomaticDeletes="true"
                                AllowSorting="True"
                                AllowPaging="True"
                                AllowMultiRowSelection="True"
                                AllowMultiRowEdit="True"
                                ExportSettings-HideStructureColumns="True">
                                <AlternatingItemStyle BackColor="#00CCFF" />
                                <ClientSettings>
                                    <Selecting AllowRowSelect="true" />
                                </ClientSettings>
                                <MasterTableView CommandItemDisplay="Top" DataKeyNames="DisplayName" BatchEditingSettings-OpenEditingEvent="None" CommandItemStyle-HorizontalAlign="NotSet" runat="server" EditFormSettings-EditFormType="AutoGenerated" EnableNoRecordsTemplate="true" ShowHeadersWhenNoRecords="true" >
                                    <NoRecordsTemplate>
                                        <div>No Score Cards found for selected criteria</div>
                                    </NoRecordsTemplate>
                                   
                                    <ColumnGroups>
                                            <%--Top Level--%>
                                            <telerik:GridColumnGroup Name="Region" HeaderText="" HeaderStyle-HorizontalAlign="Center"   >
                                                <HeaderStyle BackColor="#95B3D7" HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="EECount" HeaderText="" HeaderStyle-HorizontalAlign="Center"   >
                                                <HeaderStyle BackColor="#95B3D7" HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="Safety" HeaderText="Safety" HeaderStyle-HorizontalAlign="Center" >
                                                <HeaderStyle BackColor="#95B3D7" HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="Environment" HeaderText="Environment"  HeaderStyle-HorizontalAlign="Center"  >
                                                <HeaderStyle BackColor="#95B3D7" HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="Financial" HeaderText="Financial" HeaderStyle-HorizontalAlign="Center" >
                                                <HeaderStyle BackColor="#95B3D7" HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="Quality" HeaderText="Quality" HeaderStyle-HorizontalAlign="Center" >
                                                <HeaderStyle BackColor="#95B3D7" HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="OperationalExcellence" HeaderText="Operational Excellence" HeaderStyle-HorizontalAlign="Center" >
                                                <HeaderStyle BackColor="#95B3D7" HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <%--Region--%>
                                            <telerik:GridColumnGroup Name="RegionBlank1" HeaderText="" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Region" />
                                            <telerik:GridColumnGroup Name="RegionColumn" HeaderText="Regions" HeaderStyle-HorizontalAlign="Center" ParentGroupName="RegionBlank1" />
                                            <%--EE Count--%>
                                            <telerik:GridColumnGroup Name="EECountBlank" HeaderText="" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Region" />
                                       
                                            <%-- Safety--%>
                                            <telerik:GridColumnGroup Name="Lagging" HeaderText="Lagging" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Safety"/>
          
                                            <telerik:GridColumnGroup Name="Leading" HeaderText="Leading" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Safety"  />
                                           
                                           
                                            <telerik:GridColumnGroup Name="OIR" HeaderText="OIR" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Lagging" />
                                            <telerik:GridColumnGroup Name="LCPMV" HeaderText="Life Critical Procedures Major Violations" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Lagging" />
                                               
                                           
                                            <telerik:GridColumnGroup Name="NMIR" HeaderText="NMIR" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Leading" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="CACR" HeaderText="Corrective Actions Completion Rate %" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Leading" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="EEP" HeaderText="EE Participation" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Leading" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="NOI" HeaderText="# of injuries per 100 employees 1.0 max. Green" HeaderStyle-HorizontalAlign="Center" ParentGroupName="OIR" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="0YR" HeaderText="0/yr green" HeaderStyle-HorizontalAlign="Center" ParentGroupName="LCPMV" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="NMPE" HeaderText="# of near misses per 100 employees 64 min. Green" HeaderStyle-HorizontalAlign="Center" ParentGroupName="NMIR" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="AIC" HeaderText="% of Action Items completed by target date 80 min. Green" HeaderStyle-HorizontalAlign="Center" ParentGroupName="CACR" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="EEPPQ" HeaderText="75% min. EE Participation per Quarter Green" HeaderStyle-HorizontalAlign="Center" ParentGroupName="EEP" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <%--Environment--%>
                                            <telerik:GridColumnGroup Name="SpillRedBlank" HeaderText="" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Environment" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="SpillRed" HeaderText="Spill Reduction" HeaderStyle-HorizontalAlign="Center" ParentGroupName="SpillRedBlank" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="SpillLevel" HeaderText="# of Level I & II spills" HeaderStyle-HorizontalAlign="Center" ParentGroupName="SpillRed" >

                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>

                                            <%--Financial--%>
                                            <telerik:GridColumnGroup Name="PeriodCostBlank" HeaderText="" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Financial" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="PeriodCost" HeaderText="Period Cost %" HeaderStyle-HorizontalAlign="Center" ParentGroupName="PeriodCostBlank" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="PeriodCostAccum" HeaderText="Period Costs accumulated vs. plan 100 max. Green" HeaderStyle-HorizontalAlign="Center" ParentGroupName="PeriodCost" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <%--Quality--%>
                                            <telerik:GridColumnGroup Name="QNMBlank" HeaderText="" HeaderStyle-HorizontalAlign="Center" ParentGroupName="Quality" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="QNM" HeaderText="Quality Near Misses (QNM)" HeaderStyle-HorizontalAlign="Center" ParentGroupName="QNMBlank" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="QNMM" HeaderText="Quality Near Misses 4 min/month Green" HeaderStyle-HorizontalAlign="Center" ParentGroupName="QNM" >

                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>

                                            <%--Operational Excelence--%>
                                            <telerik:GridColumnGroup Name="OEBlank" HeaderText="" HeaderStyle-HorizontalAlign="Center" ParentGroupName="OperationalExcellence" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="OEE" HeaderText="OEE/Plant Availability %" HeaderStyle-HorizontalAlign="Center" ParentGroupName="OEBlank" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="PMComp" HeaderText="PM Compliance Efficiency %" HeaderStyle-HorizontalAlign="Center" ParentGroupName="OEBlank" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="OEEDown" HeaderText="% on stream time (excluding planned downtime) 98% min. Green" HeaderStyle-HorizontalAlign="Center" ParentGroupName="OEE" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                            <telerik:GridColumnGroup Name="PMCompPer" HeaderText="# of PM's completed in month/Scheduled in month 95 min. Green" HeaderStyle-HorizontalAlign="Center" ParentGroupName="PMComp" >
                                                <HeaderStyle HorizontalAlign="Center" />
                                            </telerik:GridColumnGroup>
                                        </ColumnGroups>
                                        <BatchEditingSettings OpenEditingEvent="None" />
                                        <HeaderStyle Width="102px" />
                                    <CommandItemTemplate>
                                              <div  style="padding: 5px 5px; align-content: center">
                                                Create Output : 
                                                <asp:LinkButton ID="btnExcelSinNumbers" runat="server" CommandName="ExcellSinNumber" ><img style="border:0px;vertical-align:middle;" alt="" src="Images/ExcelSinNumbers.ico" width="25" height="25" /> Excel without Numbers</asp:LinkButton> 
                                                  <asp:Label ID="sepFirst" runat="server">|  </asp:Label>
                                                  <asp:LinkButton ID="btnExcelExport" runat="server" CommandName="ExcellExport" ><img style="border:0px;vertical-align:middle;" alt="" src="Images/ExcelConNumbers.ico"  width="25" height="25"/> Excel</asp:LinkButton>
                                                <asp:Label ID="sepSecond" runat="server">|  </asp:Label>
                                                  <asp:LinkButton ID="btnPDFSinNumbers" runat="server" CommandName="PDFSinNumber"><img style="border:0px;vertical-align:middle;" alt="" src="Images/pdf-file.png"  width="25" height="25"/> PDF without Numbers</asp:LinkButton> 
                                                  <asp:Label ID="sepThird" runat="server">|  </asp:Label>
                                                  <asp:LinkButton ID="btnPDFExport" runat="server" CommandName="PDFExport"><img style="border:0px;vertical-align:middle;" alt="" src="Images/pdf-file.png"  width="25" height="25" /> PDF</asp:LinkButton> 
                                            </div>
                                    </CommandItemTemplate>
                                    <Columns>  
                                        <telerik:GridTemplateColumn HeaderText="" SortExpression="" ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left" ColumnGroupName="RegionColumn" HeaderStyle-Width="150px">
                                            <ItemTemplate>
                                                <asp:Label ID="lblRegion" runat="server" Text='<%# Eval("DisplayName")%>' Width="100%" ></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="150px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn HeaderText="#EE" SortExpression="" ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left" ColumnGroupName="EECountBlank" HeaderStyle-Width="15px">
                                            <ItemTemplate>
                                                <asp:Label ID="lblEE" runat="server" Text='<%# Eval("EECount")%>' Width="100%" ></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="15px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn UniqueName="lbCol1M" HeaderText="M" SortExpression="M" ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left" ColumnGroupName="NOI" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                                                <asp:Label ID="lbCol1M" runat="server" Text='<%# Eval("Col1M")%>'  Width="100%" ></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>                                                                          
                                        <telerik:GridTemplateColumn UniqueName="lbCol1YTD" HeaderText="YTD" SortExpression="Title" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top"  ColumnGroupName="NOI" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                                                <asp:Label ID="lbCol1YTD" runat="server" ReadOnly="true" Text='<%# Eval("Col1YTD")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>  
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn UniqueName="lbCol2M" HeaderText="M" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="0YR" HeaderStyle-Width="75px">
                                            <ItemTemplate>                                                  
                                                <asp:Label ID="lbCol2M" runat="server" ReadOnly="true" min-width="100%" min-height="100%"  Width="100%" BackColor="Gray"></asp:Label>  
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>         
                                        <telerik:GridTemplateColumn UniqueName="lbCol2YTD" HeaderText="YTD" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="0YR" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                                                <asp:Label ID="lbCol2YTD" runat="server" ReadOnly="true" Text='<%# Eval("Col2YTD")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>  
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>    
                                       
                                        <telerik:GridTemplateColumn UniqueName="lbCol3M" HeaderText="M" SortExpression="M" ItemStyle-VerticalAlign="Top" ItemStyle-HorizontalAlign="Left" ColumnGroupName="NMPE" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                                                <asp:Label ID="lbCol3M" runat="server" Text='<%# Eval("Col3M")%>'  Width="100%" ></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>                                                                          
                                        <telerik:GridTemplateColumn UniqueName="lbCol3YTD" HeaderText="YTD" SortExpression="Title" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Top"  ColumnGroupName="NMPE" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                                                <asp:Label ID="lbCol3YTD" runat="server" ReadOnly="true" Text='<%# Eval("Col3YTD")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>  
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>
                                        <telerik:GridTemplateColumn UniqueName="lbCol4M" HeaderText="M" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="AIC" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol4M" runat="server" ReadOnly="true" Text='<%# Eval("Col4M")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>         
                                        <telerik:GridTemplateColumn UniqueName="lbCol4YTD" HeaderText="YTD" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="AIC" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol4YTD" runat="server" ReadOnly="true" Text='<%# Eval("Col4YTD")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>                                     
                                        <telerik:GridTemplateColumn UniqueName="lbCol5M" HeaderText="M" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="EEPPQ" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol5M" runat="server" ReadOnly="true" Text=' ' min-width="100%" min-height="100%"  Width="100%" BackColor="Gray"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>         
                                        <telerik:GridTemplateColumn UniqueName="lbCol5YTD" HeaderText="QTD" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="EEPPQ" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol5YTD" runat="server" ReadOnly="true" Text='<%# Eval("Col5YTD")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>               
                                       
                                        <telerik:GridTemplateColumn UniqueName="lbCol6M" HeaderText="LVL I YTD" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="SpillLevel" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol6M" runat="server" ReadOnly="true" Text='<%# Eval("Col6M")%>' min-width="25%" min-height="100%" Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>         
                                        <telerik:GridTemplateColumn UniqueName="lbCol6YTD" HeaderText="LVL II YTD" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="SpillLevel" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol6YTD" runat="server" ReadOnly="true" Text='<%# Eval("Col6YTD")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>                                      
                                        
                                        <telerik:GridTemplateColumn UniqueName="lbCol7M" HeaderText="M" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="PeriodCostAccum" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol7M" runat="server" ReadOnly="true" Text='<%# Eval("Col7M")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>         
                                        <telerik:GridTemplateColumn UniqueName="lbCol7YTD" HeaderText="YTD" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="PeriodCostAccum" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol7YTD" runat="server" ReadOnly="true" Text='<%# Eval("Col7YTD")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>                                    
                                        
                                        <telerik:GridTemplateColumn UniqueName="lbCol8M" HeaderText="M" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="QNMM" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol8M" runat="server" ReadOnly="true" Text='<%# Eval("Col8M")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>         
                                        <telerik:GridTemplateColumn UniqueName="lbCol8YTD" HeaderText="YTD" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="QNMM" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol8YTD" runat="server" ReadOnly="true" Text='<%# Eval("Col8YTD")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>                                           
                                          
                                        <telerik:GridTemplateColumn UniqueName="lbCol9M" HeaderText="M" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="OEEDown" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol9M" runat="server" ReadOnly="true" Text='<%# Eval("Col9M")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>         
                                        <telerik:GridTemplateColumn UniqueName="lbCol9YTD" HeaderText="YTD" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="OEEDown" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol9YTD" runat="server" ReadOnly="true" Text='<%# Eval("Col9YTD")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>                                      
                                       
                                          
                                        <telerik:GridTemplateColumn UniqueName="lbCol10M" HeaderText="M" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="PMCompPer" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol10M" runat="server" ReadOnly="true" Text='<%# Eval("Col10M")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>         
                                        <telerik:GridTemplateColumn UniqueName="lbCol10YTD" HeaderText="YTD" SortExpression="IsTitle" ItemStyle-HorizontalAlign="Left"  ItemStyle-VerticalAlign="Top" Visible="True" ColumnGroupName="PMCompPer" HeaderStyle-Width="75px">
                                            <ItemTemplate>
                              <asp:Label ID="lbCol10YTD" runat="server" ReadOnly="true" Text='<%# Eval("Col10YTD")%>' min-width="25%" min-height="100%"  Width="100%"></asp:Label>
                                            </ItemTemplate>
                                            <HeaderStyle Width="75px" />
                                            <ItemStyle HorizontalAlign="Left" VerticalAlign="Top" />
                                        </telerik:GridTemplateColumn>      
                                                                                                                                                                                                                                                         
                                    </Columns>    
                                </MasterTableView>
                                <PagerStyle Mode="NextPrevAndNumeric" />
                                <FilterMenu RenderMode="Lightweight">
                                </FilterMenu>
                                <HeaderContextMenu RenderMode="Lightweight">
                                </HeaderContextMenu>
                            </telerik:RadGrid>                   
                       
                        </fieldset>
                   
                        </telerik:RadPageView>     
                   
                </telerik:RadMultiPage>
            </asp:Panel>
    </asp:Content>

     

     

     

  9. Attila Antal
    Admin
    Attila Antal avatar
    246 posts

    Posted 15 Nov 2018 Link to this post

    Hi Chuck,

    In order to provide you with a more accurate answer, we would require some more details on the exact scenario. It would be helpful if you could describe the steps you are trying to achieve. 

    I look forward to hearing from you.

    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.
  10. Chuck
    Chuck avatar
    17 posts
    Member since:
    Oct 2018

    Posted 15 Nov 2018 in reply to Attila Antal Link to this post

    I don't understand...Tsvetomir had asked for code, I provided.
  11. Attila Antal
    Admin
    Attila Antal avatar
    246 posts

    Posted 20 Nov 2018 Link to this post

    Hi Chuck,

    I've ran through the case again and I think I got it right now. I assume the issue you are experiencing is the margins taking too much of space and so, some of the rows are moved on the next page. The behavior you see is expected. Every element has a size, whether their dimensions are set automatically or are fixed. By looking at the latest picture you have attached, I understand that the page is very large for a small grid. There are even margins that are taking space.

    My point is that the more columns you have the bigger the chance is that the grid will be shrunk in width, and if there are margins, possibly some of the rows would not fit in one page, therefore they go on the next. If using fixed size and the total width of the grid exceeds the width of the page, some parts may be cut off.

    You can test the sample project I have attached to get a better understanding on the exporting behavior.

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