How to merge the column using telerik table?

[Sudha]

Hi all,

I want to design the  report table like wise 
 

  Name    id                    Menuitem                    description              price
                                menuname    Code
  aa         2                   Orange       Occ                mfhff                     21576

[Princy]

Hi,

I guess you want to use multi-column headers,here is an example on multi-column headers.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" ShowGroupPanel="true" AllowSorting="true"
    DataSourceID="SqlDataSource1" AllowPaging="true" PageSize="30" AutoGenerateColumns="false">
    <ClientSettings AllowColumnsReorder="true" AllowDragToGroup="true" ReorderColumnsOnClient="true">
        <Scrolling AllowScroll="true" UseStaticHeaders="true"></Scrolling>
        <Resizing AllowColumnResize="true" EnableRealTimeResize="true" />
    </ClientSettings>
    <GroupingSettings ShowUnGroupButton="true"></GroupingSettings>
    <MasterTableView>
        <ColumnGroups>
            <telerik:GridColumnGroup HeaderText="Product Details" Name="ProductDetails" HeaderStyle-HorizontalAlign="Center">
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup HeaderText="Location" Name="Location">
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup HeaderText="Category" Name="Category" ParentGroupName="ProductDetails">
            </telerik:GridColumnGroup>
            <telerik:GridColumnGroup HeaderText="Order Details" Name="OrderDetails" ParentGroupName="ProductDetails"
                HeaderStyle-HorizontalAlign="Center">
            </telerik:GridColumnGroup>
        </ColumnGroups>
        <Columns>
            <telerik:GridBoundColumn UniqueName="SupplierName" DataField="SupplierName" HeaderText="Supplier Name">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn UniqueName="Address" DataField="Address" ColumnGroupName="Location"
                HeaderText="Address">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn UniqueName="City" DataField="City" ColumnGroupName="Location"
                HeaderText="City">
            </telerik:GridBoundColumn>
            <telerik:GridNumericColumn UniqueName="ID" DataField="ID" ColumnGroupName="Category"
                HeaderText="ID">
            </telerik:GridNumericColumn>
            <telerik:GridBoundColumn UniqueName="CategoryName" DataField="CategoryName" ColumnGroupName="Category"
                HeaderText="Name">
            </telerik:GridBoundColumn>
            <telerik:GridNumericColumn UniqueName="Freight" DataField="Freight" ColumnGroupName="OrderDetails"
                HeaderText="Freight">
            </telerik:GridNumericColumn>
            <telerik:GridDateTimeColumn UniqueName="OrderDate" DataField="OrderDate" ColumnGroupName="OrderDetails"
                HeaderText="Date">
            </telerik:GridDateTimeColumn>
            <telerik:GridBoundColumn UniqueName="OrderAddress" DataField="OrderAddress" ColumnGroupName="OrderDetails"
                HeaderText="Address">
            </telerik:GridBoundColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:Northwind_newConnectionString3 %>"
    ProviderName="System.Data.SqlClient" SelectCommand="SELECT pdc.ProductID as ProductID, s.CompanyName as SupplierName, pdc.CategoryID as ID, pdc.CategoryName as CategoryName,
            pdc.ProductName as ProductName, pdc.QuantityPerUnit as Quantity, o.Freight as Freight, o.OrderDate as OrderDate,
        o.ShipAddress as OrderAddress, pdc.UnitPrice as Price, s.City as City, s.Address as Address
FROM Suppliers s
INNER JOIN (SELECT p.ProductID as ProductID, p.SupplierID as SupplierID, p.ProductName as ProductName,
                    p.QuantityPerUnit as QuantityPerUnit, p.UnitPrice  as UnitPrice, od.OrderID as OrderID, c.CategoryID as CategoryID, c.CategoryName as CategoryName
                FROM Products p
            INNER JOIN [Order Details] od ON p.ProductID = od.ProductID INNER JOIN Categories c on c.CategoryID=p.CategoryID
                WHERE od.OrderID in
                (SELECT TOP(3) od1.OrderID
                    FROM [Order Details] od1
                    WHERE od1.ProductID=od.ProductID)
            ) pdc on pdc.SupplierID=s.SupplierID
INNER JOIN Orders o on o.OrderID=pdc.OrderID
ORDER BY pdc.ProductID" runat="server"></asp:SqlDataSource>