Declined
Last Updated: 03 Nov 2014 09:38 by Elena
virender
Created on: 27 Dec 2012 15:40
Category: Grid
Type: Bug Report
0
RadGrid Showing two column but don't know from where it showing data
hi,

I have radgrid ,its showing two others column but in database view its only exists, Bold column not exists in view. 

I attached output of radgrid.

View's Column
---------------------
 ,[StartDate]      ,[EndDate]      ,[DepartmentName]      ,[LabourRate]      ,[BillingRate]      ,[AgencyRate]      ,[FirstName]      ,[LastName]
 ,[Description]      ,[ManagerFirst]   ,[ManagerLast]     ,[WeekEnding]    ,[Hours]    ,[RateType]  ,[TimesheetStatus]  ,[TimesheetID]

---------------------


<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <h1>Current Contractors</h1>
    <br/>
        <telerik:RadButton ID="RadButton1" runat="server" onclick="RadButton1_Click" 
        Text="Previous">
    </telerik:RadButton>
    <telerik:RadButton ID="RadButton2" runat="server" onclick="RadButton2_Click" 
        Text="Next">
    </telerik:RadButton>
    <br/>
    <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" 
        CellSpacing="0" DataSourceID="ObjectDataSource1" GridLines="None" 
        AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" 
        ExportSettings-FileName="Payroll Report" ExportSettings-ExportOnlyData="False" 
        ExportSettings-HideStructureColumns="True" ExportSettings-IgnorePaging="True" 
        ExportSettings-OpenInNewWindow="True" 
         
 >
<MasterTableView DataKeyNames="Name,StartDate,EndDate,DepartmentName,LabourRate,FirstName,LastName,Description,ManagerFirst,ManagerLast,WeekEnding,RateType,TimesheetStatus" 
            DataSourceID="ObjectDataSource1" CommandItemDisplay="Top"
            CommandItemSettings-ShowExportToCsvButton="True" CommandItemSettings-ShowExportToExcelButton="True" CommandItemSettings-ShowExportToPdfButton="True"  CommandItemSettings-ShowExportToWordButton="True" CommandItemSettings-ShowAddNewRecordButton="False" CommandItemSettings-ShowRefreshButton="False" CommandItemStyle-HorizontalAlign="Left"
  
            >
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>

<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>

    <Columns>
                <telerik:GridBoundColumn DataField="ContractorName" FilterControlWidth="20px" 
            FilterControlAltText="Filter ContractorName column" HeaderText="Contractor" 
            ReadOnly="True" SortExpression="FirstName" UniqueName="ContractorName"  >
        </telerik:GridBoundColumn>

        
        <telerik:GridBoundColumn DataField="Description" 
            FilterControlAltText="Filter Description column" HeaderText="Job" FilterControlWidth="20px" 
            ReadOnly="True" SortExpression="Description" UniqueName="Description">
        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="ManagerName" 
            FilterControlAltText="Filter ManagerName column" HeaderText="Manager" FilterControlWidth="20px" 
            ReadOnly="True" SortExpression="ManagerFirst" UniqueName="ManagerName"  >
        </telerik:GridBoundColumn>


      

       
        <telerik:GridBoundColumn DataField="AgencyRate" DataType="System.Decimal" FilterControlWidth="20px" DataFormatString="{0:C}"
            FilterControlAltText="Filter AgencyRate column" HeaderText="Agency Rate" 
            SortExpression="AgencyRate" UniqueName="AgencyRate">
        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="LabourRate" DataType="System.Decimal" FilterControlWidth="20px" DataFormatString="{0:C}"
            FilterControlAltText="Filter LabourRate column" HeaderText="Labour Rate" 
            ReadOnly="True" SortExpression="LabourRate" UniqueName="LabourRate">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="BillingRate" DataType="System.Decimal" FilterControlWidth="20px" DataFormatString="{0:C}" 
            FilterControlAltText="Filter BillingRate column" HeaderText="Billing Rate" 
            SortExpression="BillingRate" UniqueName="BillingRate">
        </telerik:GridBoundColumn>


       <telerik:GridBoundColumn DataField="StartDate" DataType="System.DateTime" FilterControlWidth="20px" DataFormatString="{0:dd/MM/yyyy}"
            FilterControlAltText="Filter StartDate column" HeaderText="Start" 
            ReadOnly="True" SortExpression="StartDate" UniqueName="StartDate">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="DepartmentName" 
            FilterControlAltText="Filter DepartmentName column" HeaderText="Department" FilterControlWidth="20px" 
            ReadOnly="True" SortExpression="DepartmentName" UniqueName="DepartmentName"  >
        </telerik:GridBoundColumn>
        
  <telerik:GridBoundColumn DataField="Name" FilterControlWidth="20px" 
            FilterControlAltText="Filter Name column" HeaderText="Name" ReadOnly="True" 
            SortExpression="Name" UniqueName="Name" >
        </telerik:GridBoundColumn>        

        <telerik:GridBoundColumn DataField="Hours" DataType="System.Int32" FilterControlWidth="20px" 
            FilterControlAltText="Filter Hours column" HeaderText="Hours" 
            SortExpression="Hours" UniqueName="Hours">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="RateType" FilterControlWidth="20px" 
            FilterControlAltText="Filter RateType column" HeaderText="RateType" 
            ReadOnly="True" SortExpression="RateType" UniqueName="RateType">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="TimesheetStatus" FilterControlWidth="20px" 
            FilterControlAltText="Filter TimesheetStatus column" 
            HeaderText="Status" ReadOnly="True" SortExpression="TimesheetStatus" 
            UniqueName="TimesheetStatus">
        </telerik:GridBoundColumn>
    </Columns>

<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
</MasterTableView>

<FilterMenu EnableImageSprites="False"></FilterMenu>
    </telerik:RadGrid>
   

      <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
        SelectMethod="GetPayrollReport" TypeName="Business.PayrollReportList"  
                SortParameterName="sortBy"
        >
          <SelectParameters>
            <asp:SessionParameter SessionField="WeekEnding" DbType="DateTime" Name="WeekEnding" />
        </SelectParameters>
    </asp:ObjectDataSource>
</asp:Content>
Attached Files:
1 comment
Elena
Posted on: 03 Nov 2014 09:38
Please use the support ticketing system for similar reports. This channel is only for bug reports and feature requests.