Export to Excel, Word, Pdf

[Mahendra s]

Hi 

The  export to excel, word, pdf, csv  feature works for me in the simple grid

Can someone let me know , whether the Export to Excel, Pdf, Word, CSV is really supported in the RADGrid having heirarchical structure
I get below error when try to export to PDF
 

Server Error in '/' Application.

---

System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at Telerik.Web.Apoc.Fo.Flow.TableRow.CellArray.GetNextFreeCell(Int32 colNum)
  at Telerik.Web.Apoc.Fo.Flow.TableRow.InitCellArray()
  at Telerik.Web.Apoc.Fo.Flow.TableRow.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.AbstractTableBody.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Table.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Block.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.TableCell.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.TableRow.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.AbstractTableBody.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Table.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Block.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Flow.Layout(Area area, Region region)
  at Telerik.Web.Apoc.Fo.Flow.Flow.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Pagination.PageSequence.Format(AreaTree areaTree)
  at Telerik.Web.Apoc.StreamRenderer.Render(PageSequence pageSequence)
  at Telerik.Web.Apoc.Fo.FOTreeBuilder.EndElement()
  at Telerik.Web.Apoc.Fo.FOTreeBuilder.Parse(XmlReader reader)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.SystemException: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at Telerik.Web.Apoc.Fo.Flow.TableRow.CellArray.GetNextFreeCell(Int32 colNum)
  at Telerik.Web.Apoc.Fo.Flow.TableRow.InitCellArray()
  at Telerik.Web.Apoc.Fo.Flow.TableRow.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.AbstractTableBody.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Table.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Block.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.TableCell.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.TableRow.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.AbstractTableBody.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Table.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Block.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Flow.Layout(Area area, Region region)
  at Telerik.Web.Apoc.Fo.Flow.Flow.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Pagination.PageSequence.Format(AreaTree areaTree)
  at Telerik.Web.Apoc.StreamRenderer.Render(PageSequence pageSequence)
  at Telerik.Web.Apoc.Fo.FOTreeBuilder.EndElement()
  at Telerik.Web.Apoc.Fo.FOTreeBuilder.Parse(XmlReader reader)

thanks

[Daniel]

Hello Mahendra,

RadGrid is capable to export hierarchical data to Excel, Word and PDF. As explained in the documentation, CSV format doesn't support such structure.
Please post your markup here and let me know which version of RadControls do you use?
CSV export

Best regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Mahendra s]

Hello Daniel

Thanks for your reply

I am using  Telerik RadControls for ASP.NET Ajax (2009.2.826.35)
Runtime Version =  v2.0.50727

Could you let me know the steps to implemented the export for hierarchical data

Regards
Mahendra

[Daniel]

Hello Mahendra,

I created a simplified demo for you. Please download it and let me know if you need further assistance.

Regards,
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Mahendra s]

I have tried this but it does not work

Thanks
Mahendra

[Daniel]

Hello Mahendra,

What do you mean by "it does not work"? Does it throw any error message? Can you post some more information about the problem?

Best regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Edgar]

Hi, I am using RadGrid and PFD export. But I got the exception: 

 

Server Error in '/' Application.

---

System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at Telerik.Web.Apoc.Fo.Flow.TableRow.CellArray.GetNextFreeCell(Int32 colNum)
  at Telerik.Web.Apoc.Fo.Flow.TableRow.InitCellArray()
  at Telerik.Web.Apoc.Fo.Flow.TableRow.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.AbstractTableBody.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Table.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Block.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Flow.Layout(Area area, Region region)
  at Telerik.Web.Apoc.Fo.Flow.Flow.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Pagination.PageSequence.Format(AreaTree areaTree)
  at Telerik.Web.Apoc.StreamRenderer.Render(PageSequence pageSequence)
  at Telerik.Web.Apoc.Fo.FOTreeBuilder.EndElement()
  at Telerik.Web.Apoc.Fo.FOTreeBuilder.Parse(XmlReader reader)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.SystemException: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at Telerik.Web.Apoc.Fo.Flow.TableRow.CellArray.GetNextFreeCell(Int32 colNum)
  at Telerik.Web.Apoc.Fo.Flow.TableRow.InitCellArray()
  at Telerik.Web.Apoc.Fo.Flow.TableRow.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.AbstractTableBody.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Table.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Block.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Flow.Flow.Layout(Area area, Region region)
  at Telerik.Web.Apoc.Fo.Flow.Flow.Layout(Area area)
  at Telerik.Web.Apoc.Fo.Pagination.PageSequence.Format(AreaTree areaTree)
  at Telerik.Web.Apoc.StreamRenderer.Render(PageSequence pageSequence)
  at Telerik.Web.Apoc.Fo.FOTreeBuilder.EndElement()
  at Telerik.Web.Apoc.Fo.FOTreeBuilder.Parse(XmlReader reader)


This is my RadGrid:

<

 

 

telerik:RadGrid ID="ActivitiesGrid" runat="server" EnableEmbeddedSkins ="False" Skin="DeloitteTax"

 

 

 

style="margin-right: 200px; margin-left: 10px; margin-top: 10px" AutoGenerateColumns="False" AllowPaging="True" AllowSorting="True"

 

 

 

CellSpacing="0" GridLines="None" OnItemCommand="ActivitiesGrid_ItemCommand" OnItemCreated="ActivitiesGrid_ItemCreated"

 

 

 

ShowFooter="true" FooterStyle-BackColor="White" >

 

 

 

<ExportSettings IgnorePaging="true" OpenInNewWindow="true">

 

 

 

<Pdf PageHeight="279.4mm" PageWidth="215.9mm" DefaultFontFamily="Arial Unicode MS"

 

 

 

PageBottomMargin="20mm" PageTopMargin="20mm" PageLeftMargin="20mm" PageRightMargin="20mm" Title="Series"/>

 

 

 

</ExportSettings>

 

 

 

<MasterTableView CommandItemDisplay="Top" PageSize="30" BackColor="White">

 

 

 

<CommandItemTemplate>

 

 

 

<asp:Button ID="DownloadPDF" runat="server" Width="15%" CommandName="ExportToPdf" Text="Generate PDF"/>

 

 

 

<br />

 

 

 

<br />

 

 

 

<asp:Image ID="ImageHeader" runat="server" AlternateText="Activity Guide" height="80" width="640"/>

 

 

 

<br />

 

 

 

<asp:Label ID="Label1" Text="Client: " runat="server"/>

 

 

 

<asp:Label ID="lblClient" runat="server" Font-Bold="true"/>

 

 

 

<br />

 

 

 

<asp:Label ID="Label2" Text="Responsible Tax Partner: " runat="server" />

 

 

 

<asp:Label ID="lblResponsible" runat="server" Font-Bold="true"/>

 

 

 

<br />

 

 

 

<asp:Label ID="Label3" Text="Return to be signed/electronically transmitted by: " runat="server" />

 

 

 

<asp:Label ID="lblSigned" runat="server" Font-Bold="true"/>

 

 

 

<br />

 

 

 

<br />

 

 

 

</CommandItemTemplate>

 

 

 

<Columns>

 

 

 

<telerik:GridBoundColumn DataField="SeriesName" UniqueName="K2ActName" HeaderText="Activity" HeaderStyle-ForeColor="White"/>

 

 

 

<telerik:GridBoundColumn DataField="CompletedBy" UniqueName="K2AllocatedUser" HeaderText="Completed by" HeaderStyle-ForeColor="White"/>

 

 

 

<telerik:GridBoundColumn DataField="CompletedOnMessage" UniqueName="CompletedOn" HeaderText="Date" HeaderStyle-ForeColor="White"/>

 

 

 

</Columns>

 

 

 

</MasterTableView>

 

 

 

<HeaderStyle ForeColor="#00A1DE" />

 

</

 

 

telerik:RadGrid>

 

And, in the .cs I have:

 

 

protected void ActivitiesGrid_ItemCreated(object sender, GridItemEventArgs e)

 

{

 

 

 

if (e.Item is GridFooterItem)

 

{

 

 

GridFooterItem footer = (GridFooterItem)e.Item;

 

footer[

 

"K2ActName"].ColumnSpan = ActivitiesGrid.Columns.Count;

 

 

 

 

 

footer[

 

"K2ActName"].Style["Font-Size"] = "8.5px";

 

footer[

 

"K2ActName"].Text = "some footer text for all columns;

 

}

}

Regards

[Shinu]

Hello Edgar,

Make sure that you are using Advanced data-binding using NeedDataSource event. Also check the following help documentation which explains more about exporting to pdf.
PDF export.

-Shinu.