Am using radgrid in which am binding my sp ... in my sp am using dynaimic pivot
Name Block Name Type 2012/1/1 2012/1/2 2012/1/3 till 31 for monthly status ....total
xyz IT dom 1 1 1 3
abc f.s dom 3 3 3 9
pqe Finance sea 4 1 2 7
how can i bind dynamic dates to rad grid please help me ..
<telerik:RadGrid ID="grdBlock" runat="server" GridLines="None" AllowFilteringByColumn="True"
AllowPaging="True" AllowSorting="True" AutoGenerateColumns="True" ShowGroupPanel="True"
PageSize="25" OnNeedDataSource="grdBlock_NeedDataSource" Skin="Office2007" OnItemCommand="grdBlock_ItemCommand">
<GroupingSettings CaseSensitive="false" />
<ExportSettings HideStructureColumns="true" IgnorePaging="true" FileName="Block"
ExportOnlyData="true" OpenInNewWindow="true">
<Excel Format="ExcelML" />
</ExportSettings>
<MasterTableView>
<Columns>
<telerik:GridTemplateColumn UniqueName="Block_Master_Id" SortExpression="Block_Master_Id"
DataField="Block_Master_Id" Visible="false">
<ItemTemplate>
<asp:Label ID="lblBlockId" runat="server" Text='<%# Bind("Block_Master_Id") %>'>
</asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn ItemStyle-HorizontalAlign="Center" UniqueName="Block_Name"
DataField="Employee_Name" HeaderText="Employee Name" ReadOnly="true" SortExpression="Employee_Name">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn ItemStyle-HorizontalAlign="Center" UniqueName="Block_Name"
DataField="Block_Name" HeaderText="Block Name" ReadOnly="true" SortExpression="Block_Name">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn ItemStyle-HorizontalAlign="Center" UniqueName="BlockType"
DataField="BlockType" HeaderText="BlockType" ReadOnly="true" SortExpression="BlockType">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>