RadGrid Export error -- No data exported

[Anil]

Hi,
I am using a RadGrid that has another RadGrid as item template. Finally Grid contains RadTextBox as ItemTemplate.

I want to export the top grid with all its children data. But no data is exported and an error "Unable to cast object of type 'Telerik.Web.UI.GridTFoot' to type 'Telerik.Web.UI.GridTableView'." occurs. 

<

 

 

telerik:radgrid id="gvCategory" runat="server" headerstyle-wrap="false" allowpaging="false"  

allowsorting="false" autogeneratecolumns="false" gridlines="None" showheader="false" onexcelmlexportstylescreated="gvCategory_ExcelMLExportStylesCreated" onexcelmlexportrowcreated="gvCategory_ExcelMLExportRowCreated">  

<MasterTableView DataKeyNames="CatId,CatName">
<Columns>

<telerik:GridTemplateColumn ItemStyle-HorizontalAlign ="Center"> 

<ItemTemplate >
<telerik:RadGrid ID="gvQuestions" HeaderStyle-HorizontalAlign="Left" OnItemDataBound ="gvQuestions_ItemDataBound" GridLines="None" runat="server" AllowPaging="false" AllowSorting="false" AutoGenerateColumns ="false" Width="100%" BorderStyle ="None">

<MasterTableView DataKeyNames ="QuestionId,OptionId,ScoringLogicTypeId,QuestionName">

<Columns>

<telerik:GridBoundColumn UniqueName="Attributes" DataField="QuestionName" Visible ="True" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Middle" ItemStyle-Width ="75%" ItemStyle-BorderStyle

="None">

 

</telerik:GridBoundColumn>
<telerik:GridTemplateColumn UniqueName="Options" ItemStyle-HorizontalAlign ="Left" ItemStyle-Font-Size="8" ItemStyle-Width="10%" ItemStyle-BorderStyle ="None">
<ItemTemplate >

<asp:Panel ID="pnOptions" runat="server" Width ="100%">
<asp:Label ID="lblOptions" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Option") %> '> </asp:Label >

</asp:Panel >

</ItemTemplate >

</telerik:GridTemplateColumn >
<telerik:GridTemplateColumn UniqueName="Matrix" ItemStyle-HorizontalAlign ="Left" ItemStyle-Width="10%" ItemStyle-BorderStyle ="None">
<ItemTemplate >
<asp:Panel ID="pnMatrix" runat="server" Width ="100%">  

<telerik:RadTextBox Enabled="false" Font-Bold="true" ID="txtXMin" runat ="server" CssClass="textBox" Visible="True" Width="30px" Text='<%# DataBinder.Eval(Container.DataItem, "XMin") %>' />

&nbsp;&nbsp;  

<telerik:RadTextBox Enabled="false" Font-Bold="true" ID="txtXMax" runat ="server" CssClass="textBox" Visible="True" Width="30px" Text='<%# DataBinder.Eval(Container.DataItem, "XMax") %>' />&nbsp;&nbsp;

</asp:Panel >
</ItemTemplate >  

</telerik:GridTemplateColumn >  

</Columns >

</MasterTableView >
</telerik:radgrid >

 

 

 

 

[Daniel]

Hello Anil,

I'm afraid it is not possible to export nested RadGrids when using ExcelML format. I recommend that you use hierarchy or HTML format instead.

Kind regards,
Daniel
the Telerik team

[Anil]

Hi,

Thank u very much for ur response.
I used hierarchy grid approach. But as my inner grid data is not directly related on parent grid data so i am not able to  specify value for datakeyfield and masterkeyfield in ParentTableRelation section.
Please reply!!!!!!!!!!!!!!!!!!!
My Grid HTML is :

 

 

<telerik:RadGrid ID="gvCategory" runat="server" AllowPaging="false" AllowSorting="false"

                                AutoGenerateColumns="false" GridLines="None">

                                <MasterTableView DataKeyNames="CatId,CatName" Name="Category" Width="100%">

                                    <DetailTables>

                                        <telerik:GridTableView DataKeyNames="ScoringLogicTypeId,ScoringLogicTypeName" Width="100%"

                                            HierarchyDefaultExpanded="true" Name="ScoringLogicType">

                                            <DetailTables>

                                                <telerik:GridTableView Width="100%" DataKeyNames="ScoringLogicTypeId,RuleId" HierarchyDefaultExpanded="true"

                                                    Name="Rules">

                                                    <DetailTables>

                                                        <telerik:GridTableView Name="gvQuestions" Width="100%" DataKeyNames="QuestionId,OptionId,ScoringLogicTypeId,QuestionName,ParentQid,ChildQid,XQID,YQID">

                                                            <Columns>

                                                                <telerik:GridBoundColumn UniqueName="SNO" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="center"

                                                                    ItemStyle-VerticalAlign="Top" Visible="True" ItemStyle-Width="5%" ItemStyle-BorderStyle="None">

                                                                </telerik:GridBoundColumn>

                                                                <telerik:GridBoundColumn UniqueName="Attributes" DataField="QuestionName" Visible="True"

                                                                    ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Middle" ItemStyle-Width="75%"

                                                                    ItemStyle-BorderStyle="None">

                                                                </telerik:GridBoundColumn>

                                                                <telerik:GridTemplateColumn UniqueName="Options" ItemStyle-HorizontalAlign="Left"

                                                                    ItemStyle-Font-Size="8" ItemStyle-Width="10%" ItemStyle-BorderStyle="None">

                                                                    <ItemTemplate>

                                                                        <asp:Panel ID="pnOptions" runat="server" Width="100%">

                                                                            <asp:Label ID="lblOptions" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "OptionName") %>'>

                                                                            </asp:Label>

                                                                        </asp:Panel>

                                                                    </ItemTemplate>

                                                                </telerik:GridTemplateColumn>

                                                                <telerik:GridTemplateColumn UniqueName="Matrix" ItemStyle-HorizontalAlign="Left"

                                                                    ItemStyle-Width="10%" ItemStyle-BorderStyle="None">

                                                                    <ItemTemplate>

                                                                        <asp:Panel ID="pnMatrix" runat="server" Width="100%">

                                                                            <telerik:RadTextBox Enabled="false" Font-Bold="true" ID="txtXMin" runat="server"

                                                                                CssClass="textBox" Visible="True" Width="30px" Text='<%# DataBinder.Eval(Container.DataItem, "XMin") %>' />&nbsp;&nbsp;

                                                                            <telerik:RadTextBox Enabled="false" Font-Bold="true" ID="txtXMax" runat="server"

                                                                                CssClass="textBox" Visible="True" Width="30px" Text='<%# DataBinder.Eval(Container.DataItem, "XMax") %>' />&nbsp;&nbsp;

                                                                            <telerik:RadTextBox Enabled="false" Font-Bold="true" ID="txtYMin" runat="server"

                                                                                CssClass="textBox" Visible="True" Width="30px" Text='<%# DataBinder.Eval(Container.DataItem, "YMin") %>' />&nbsp;&nbsp;

                                                                            <telerik:RadTextBox Enabled="false" Font-Bold="true" ID="txtYMax" runat="server"

                                                                                CssClass="textBox" Visible="True" Width="30px" Text='<%# DataBinder.Eval(Container.DataItem, "YMax") %>' />

                                                                        </asp:Panel>

                                                                    </ItemTemplate>

                                                                </telerik:GridTemplateColumn>

                                                                <telerik:GridTemplateColumn UniqueName="WieghtedEffort" ItemStyle-HorizontalAlign="Left"

                                                                    ItemStyle-Width="10%" ItemStyle-BorderStyle="None">

                                                                    <ItemTemplate>

                                                                        <asp:Panel ID="pnWieghtedEffort" runat="server" Width="100%">

                                                                            <asp:Table ID="Table1" runat="server">

                                                                                <asp:TableRow>

                                                                                    <asp:TableCell VerticalAlign="Top">

                                                                                        <telerik:RadTextBox ID="txtLowerRange" Font-Bold="true" Enabled="false" runat="server"

                                                                                            CssClass="textBox" Visible="True" Width="30px" Text='<%# DataBinder.Eval(Container.DataItem, "LowerRange") %>' />

                                                                                        <asp:Label ID="lblempty" runat="server" Width="50px"></asp:Label>

                                                                                    </asp:TableCell>

                                                                                    <asp:TableCell VerticalAlign="Top">

                                                                                        <telerik:RadTextBox ID="txtUpperRange" Font-Bold="true" Enabled="false" runat="server"

                                                                                            CssClass="textBox" Visible="True" Width="30px" Text='<%# DataBinder.Eval(Container.DataItem, "UpperRange") %>' />

                                                                                    </asp:TableCell>

                                                                                </asp:TableRow>

                                                                            </asp:Table>

                                                                        </asp:Panel>

                                                                    </ItemTemplate>

                                                                </telerik:GridTemplateColumn>

                                                                <telerik:GridTemplateColumn UniqueName="Score" ItemStyle-Width="10%" ItemStyle-BorderStyle="None"

                                                                    ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Bottom">

                                                                    <ItemTemplate>

                                                                        <asp:Table ID="tb1" runat="server">

                                                                            <asp:TableRow>

                                                                                <asp:TableCell VerticalAlign="top">

                                                                                    <telerik:RadTextBox ID="txtScore" runat="server" CssClass="textBox" Width="30px"

                                                                                        Text='<%# DataBinder.Eval(Container.DataItem, "Score") %>' />

                                                                                </asp:TableCell>

                                                                            </asp:TableRow>

                                                                        </asp:Table>

                                                                    </ItemTemplate>

                                                                </telerik:GridTemplateColumn>

                                                                <telerik:GridTemplateColumn UniqueName="Wieghtage" ItemStyle-HorizontalAlign="Left"

                                                                    ItemStyle-Width="10%" ItemStyle-BorderStyle="None">

                                                                    <ItemTemplate>

                                                                        <asp:Panel ID="pnWieghtage" runat="server" Width="100%">

                                                                            <telerik:RadTextBox ID="txtWeightage" runat="server" CssClass="textBox" Visible="True"

                                                                                Width="30px" Text='<%# DataBinder.Eval(Container.DataItem, "Weightage") %>' />

                                                                        </asp:Panel>

                                                                    </ItemTemplate>

                                                                </telerik:GridTemplateColumn>

                                                            </Columns>

                                                        </telerik:GridTableView>

                                                    </DetailTables>

                                                </telerik:GridTableView>

                                            </DetailTables>

                                        </telerik:GridTableView>

                                    </DetailTables>

                                </MasterTableView>

                            </telerik:RadGrid>