Export to PDF with RADGrid hireachy

[Asra]

Hi All,

             Can any onw pls let me know the code that is used to export TO PDF on the RadGrid with the child items.

Regards,
Asra

[Pavlina]

Hi Asra,

I am sending you a simple runnable application that demonstrates the needed approach. Give it a try and let me know if you have other questions or problems.

Kind regards,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Asra]

Hi Pavlina ,

Thnx for sending me the code.

The code is actually not working for me. Iam binding the Grid in the Code-behind.  Iam getting this kind of error:
Telerik.Web.Apoc.ApocException: internal-destination or external-destination must be specified in basic-link
  at Telerik.Web.Apoc.Fo.Flow.BasicLink.Layout(Area area)

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. 

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Can you pls tell me it is giving me the error.

Regards,
Asra

[Pavlina]

Hi Asra,

I followed your scenario in order to replicate the issue but to no avail.
Please find attached a simple runnable application which demonstrates the needed approach. Give it a try and see if it works for you. 

Best wishes,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Mallikharjun Mulagundla]

Hi Paulina,

I have taken your code(Pragrammatic created HierarchyGrid) and Run the application.
-> Don't expnad any row. Once Click on Export to PDF, writing properly into PDF file without any errors
-> Expand any row, Click on Export to PDF, giving floowing error
clicking on the "Export to Excel" 

System.SystemException: At least one of minimum, optimum, or maximum IPD must be specified on table.
  at Telerik.Web.Apoc.ApocDriver.FireApocError(String message)
  at Telerik.Web.Apoc.Fo.Flow.Table.SetIPD(Boolean bHasProportionalUnits, Int32 maxAllocIPD)
  at Telerik.Web.Apoc.Fo.Flow.Table.CalcFixedColumnWidths(Int32 maxAllocationWidth)
  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)

Please help me in resolving this issue.

Thanks

[Pavlina]

Hello Mallikharjun,

I followed you scenario in order to replicate the error but to no avail. Please examine the attached video and let me know if I am leaving something out while testing.

Regards,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Heath Corbin]

I get the same error as those above when trying to export a radgrid to pdf.  The error I get is "At least one of minimum, optimum, or maximum IPD must be specified on table.".  If you set Internet Explorer to Compatibility Mode, or use Internet Explorer 7, you will get this error too.

[Heath Corbin]

To clarify, the error will not be throw if you are using Chrome, Firefox, or IE 8.  This is only in IE 8 with Compatibility Mode turned on, and IE 7.

[Pavlina]

Hello Heath,

Could you please post your markup here so we can examine it?

Regards,
Pavlina
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.

[Stephen Gray]

Hi

I also had this error. I set a width property on the table as shown below and everything worked fine.

<table width="100">

<colgroup>

<col />

<col />

</colgroup>

<tr>

<td>

</td> <td> </td>

</tr> </table>

When I remove this width property again I get the following error.

System.SystemException: At least one of minimum, optimum or maximum IPD must be specified on table.

Is anybody still having this issue ? Anyway setting a width property on the table seems to work although I'd like to know what causes the error. Ill see if i can find more info on the underlying methods.

[Heath Corbin]

Thanks for the suggestion Stephen, however that did not fix the problem for me.

Here is my markup:

 <table width="100">

   <tr>

       <td>

           <p>

           <asp:LinkButton ID="btnExportAllEnrollments" runat="server"  Visible="false" CssClass="button" OnClick="ExportAllEnrollments" />

           </p> 

       </td>

   </tr>

   <tr>

   <td>

       <telerik:radgrid id="RadGrid1" CssClass="RadGrid" Visible="True" skin="Telerik" EnableEmbeddedSkins="false" AutoGenerateColumns="False" runat="server"

               AllowPaging="True" AllowSorting="True" GridLines="none" PagerStyle-Mode="NextPrevAndNumeric"  >

               <ExportSettings OpenInNewWindow="true" ExportOnlyData="true"  IgnorePaging="false" Pdf-AllowPrinting="true"   ></ExportSettings>

               <MasterTableView ShowHeadersWhenNoRecords="False">

               <RowIndicatorColumn UniqueName="RowIndicator" Visible="False">

               <HeaderStyle Width="20px"></HeaderStyle>

               </RowIndicatorColumn>

               <ItemStyle CssClass="RadGridItem" />

               <AlternatingItemStyle CssClass="RadGridAlternatingItem" />

               <HeaderStyle HorizontalAlign="Left" CssClass="RadGridHeader"></HeaderStyle>

               <EditFormSettings>

               <EditColumn UniqueName="EditCommandColumn"></EditColumn>

               </EditFormSettings>

               <ExpandCollapseColumn ButtonType="ImageButton" UniqueName="ExpandColumn" Visible="False">

               <HeaderStyle Width="19px"></HeaderStyle>

               </ExpandCollapseColumn>

               <Columns>

                   <telerik:GridBoundColumn UniqueName="ID" DataField="EnrollmentID" SortExpression="EnrollmentID"

                       AllowSorting="true" Visible="false">

                                   </telerik:GridBoundColumn>

                                  <telerik:GridBoundColumn UniqueName="CourseID" DataField="CourseID" SortExpression="CourseID"

                       AllowSorting="true" Visible="false">

                                  </telerik:GridBoundColumn>                           

                                  <telerik:GridBoundColumn UniqueName="CourseName" HeaderButtonType="TextButton" 

                                       DataField="CourseName" HeaderText="Course Name" SortExpression="CourseName">

                                </telerik:GridBoundColumn>            

           </Columns>

            <DetailTables>

               <telerik:GridTableView DataMember="Enrollment" GridLines="None" Caption="Enrollment Details">

               <PagerStyle Height="20px" Mode="NumericPages" CssClass="GridPager"></PagerStyle>

               <HeaderStyle CssClass="RadGridHeader"></HeaderStyle>

               <ItemStyle CssClass="RadGridItem"  HorizontalAlign="left"></ItemStyle>

               <AlternatingItemStyle CssClass="RadGridAlternatingItem" HorizontalAlign="left"></AlternatingItemStyle>

               <RowIndicatorColumn UniqueName="RowIndicator">

               <HeaderStyle Width="30px"></HeaderStyle>

               </RowIndicatorColumn>

               <Columns>

               <telerik:GridBoundColumn UniqueName="LastAccessDate" HeaderButtonType="TextButton"

                                        DataField="LastAccessDate" HeaderText="Last Access Date" SortExpression="LastAccessDate" DataFormatString="{0:d}">

                                    </telerik:GridBoundColumn>

                                    <telerik:GridBoundColumn UniqueName="EnrollmentTime" HeaderButtonType="TextButton"

                                        DataField="EnrollmentTime" HeaderText="Time in Enrollment" SortExpression="EnrollmentTime">

                                    </telerik:GridBoundColumn>                                    

               </Columns>

               <EditFormSettings>

               <EditColumn UniqueName="EditCommandColumn"></EditColumn>

               </EditFormSettings>

               <ExpandCollapseColumn Visible="False" UniqueName="ExpandColumn">

               <HeaderStyle Width="19px"></HeaderStyle>

               </ExpandCollapseColumn>

               </telerik:GridTableView>

               <telerik:GridTableView DataMember="Assessments"  AllowPaging="false" GridLines="None" Caption="Assessments" >

               <PagerStyle Height="20px" Mode="NumericPages" CssClass="GridPager"></PagerStyle>

               <HeaderStyle CssClass="RadGridHeader"></HeaderStyle>

               <ItemStyle CssClass="RadGridItem"  HorizontalAlign="left"></ItemStyle>

               <AlternatingItemStyle CssClass="RadGridAlternatingItem" HorizontalAlign="left"></AlternatingItemStyle>

               <RowIndicatorColumn UniqueName="RowIndicator">

               <HeaderStyle Width="30px"></HeaderStyle>

               </RowIndicatorColumn>

               <Columns>

                   <telerik:GridTemplateColumn>

                                    <HeaderTemplate>

                                        <asp:LinkButton ID="btnExportTableView1" runat="server" Text="Export" CssClass="button" OnClick="ExportEnrollment" />

                                    </HeaderTemplate>

                                    </telerik:GridTemplateColumn>

               <telerik:GridBoundColumn UniqueName="AssessmentName" HeaderButtonType="TextButton"

                                        DataField="AssessmentName" HeaderText="Assessment Name" SortExpression="AssessmentName">

                                    </telerik:GridBoundColumn>

                                    <telerik:GridBoundColumn UniqueName="LastAttemptStart" HeaderButtonType="TextButton"

                                        DataField="LastAttemptStart" HeaderText="Start Date" SortExpression="LastAttemptStart" >

                                    </telerik:GridBoundColumn>

                                    <telerik:GridBoundColumn UniqueName="LastAttemptEnd" HeaderButtonType="TextButton"

                                        DataField="LastAttemptEnd" HeaderText="End Date" SortExpression="LastAttemptEnd" >

                                    </telerik:GridBoundColumn>

                                    <telerik:GridBoundColumn UniqueName="EnrollmentAssessmentStateName" HeaderButtonType="TextButton"

                                        DataField="EnrollmentAssessmentStateName" HeaderText="Status" SortExpression="EnrollmentAssessmentStateName">

                                    </telerik:GridBoundColumn>

                                    <telerik:GridTemplateColumn HeaderText="Grade">

                                        <ItemTemplate>

                                            <%# this.GetGradeDisplay((string)DataBinder.Eval(Container.DataItem, "PercentGradeDisplay"),

                                                                     (int)DataBinder.Eval(Container.DataItem, "EnrollmentAssessmentStateID")) %>

                                        </ItemTemplate>

                                    </telerik:GridTemplateColumn>

                                     <telerik:GridBoundColumn UniqueName="PercentageCompleted" HeaderButtonType="TextButton"

                                        DataField="PercentageCompleted" HeaderText="Course Completion" SortExpression="EnrollmentTime">

                                    </telerik:GridBoundColumn>                                    

               </Columns>

               <EditFormSettings>

               <EditColumn UniqueName="EditCommandColumn"></EditColumn>

               </EditFormSettings>

               <ExpandCollapseColumn Visible="False" UniqueName="ExpandColumn">

               <HeaderStyle Width="19px"></HeaderStyle>

               </ExpandCollapseColumn>

               </telerik:GridTableView>

               </DetailTables>

               </MasterTableView>

               <FilterMenu NotSelectedImageUrl="~/RadControls/Grid/Skins/Default/NotSelectedMenu.gif" HoverBackColor="LightSteelBlue"

               HoverBorderColor="Navy" SelectColumnBackColor="Control" SelectedImageUrl="~/RadControls/Grid/Skins/Default/SelectedMenu.gif"

               TextColumnBackColor="Window"></FilterMenu>

               <GroupHeaderItemStyle CssClass="RadGridAlternatingItem" VerticalAlign="Middle"></GroupHeaderItemStyle>

               <GroupPanel Visible="False">

               <PanelItemsStyle CssClass="GroupPanelItem"></PanelItemsStyle>

               <PanelStyle CssClass="GroupPanel"></PanelStyle>

               </GroupPanel>

                </telerik:radgrid>

   </td>

</tr>

</table>

[Pavlina]

Hi Heath,

In order to avoid this error you should define width to your GridTableViews. An example is shown below:
ASPX:

<MasterTableView ShowHeadersWhenNoRecords="False">
            <DetailTables>
               <telerik:GridTableView DataMember="Enrollment" GridLines="None" Caption="Enrollment Details" Width="100%">
.......................

I hope this helps.

Best wishes,
Pavlina
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.

[Nicolaï]

It did help me..! Width for detailtables and pdf works again! Thanks!

[Radha]

 

Hi Pavlina,
       Here in the below code i'm adding footer to e.rawhtml dynamically that's when it is throwing  like:
Please can anybody help on this.
  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)

Code  Snippet:
protected void grdReport_PdfExporting(object source, GridPdfExportingArgs e)

 

{

 

string strfooter =

"<table width='100px'><colgroup><col /><col /></colgroup><tr><td></td><td></td><td></td><td></td><td><span style='font-Names:Verdana;font-weight:bold;'>Branch Totals</span></td><td></td><td></td>" +

 

 

"<td><span style='font-Names:Verdana;font-weight:bold;'>With in</span><br /><span style='font-Names:Verdana;font-weight:bold;'>Branch</span></td>"+

 

 

"<td><span style='font-Names:Verdana;font-weight:bold;'>To Outside</span><br /><span style='font-Names:Verdana;font-weight:bold;'>Branch</span></td></tr><tr>"+

 

 

"<td></td> <td></td><td></td><td></td><td></td><td><span style='font-Names:Verdana;font-weight:bold'>Total -Recruited</span></td>"+

 

 

"<td>"+(recruited.ToString()+"</td><td>"+recruited.ToString()+"</td><td>"+recruited.ToString()+"</td></tr><tr>"+

 

 

"<td></td> <td></td><td></td><td></td><td></td><td><span style='font-Names:Verdana;font-weight:bold;'>Total -Referred</span></td>"+

 

 

"<td>"+(referred.ToString()+" </td><td>"+referred.ToString()+"</td>"+

 

 

"<td>"+referred.ToString()+"</td></tr><tr><td></td> <td></td><td></td><td></td><td></td><td><span style='font-Names:Verdana;font-weight:bold;'>Total -Direct Placement</span></td>"+

 

 

"<td>"+WithinBranch.ToString()+" </td><td>"+WithinBranch.ToString()+" </td><td>"+directToOutside.ToString()+"</td></tr>"+

 

 

"<tr><td># -indicates activity is to an outside branch</td> <td></td><td></td><td></td><td></td><td><span style='font-Names:Verdana;font-weight:bold'>Total Count of New Starts for specified period</span></td>"+

 

 

"<td>"+directWithinBranch.ToString()+" </td><td></td><td></td></tr></table>";

 

e.RawHTML =

"<left><img alt='test' style='height:20px;width:100px;' src='~/images/Volt.jpg'/></left><center style='font-family:Verdana;font-weight:bold'>" + lblReportTitle.Text + "<br />" + "</center>" + e.RawHTML + strfooter;

 

 

}

[Radha]

I found a solution for my earlier post.

Need to Set couple of <col /><col /> for the each <td></td> count in one row. 
For Example:
"<table width='100px'><colgroup><col /><col /><col /><col /><col /><col /><col /><col /><col /><col />
<col /><col /><col /><col /><col /><col /><col /><col /></colgroup><tr><td></td><td></td><td></td><td></td><td><span style='font-Names:Verdana;font-weight:bold;'>Branch Totals</span></td><td></td><td></td>" +

 

 

"<td><span style='font-Names:Verdana;font-weight:bold;'>With in</span><br /><span style='font-Names:Verdana;font-weight:bold;'>Branch</span></td>"+

 

 

"<td><span style='font-Names:Verdana;font-weight:bold;'>To Outside</span><br /><span style='font-Names:Verdana;font-weight:bold;'>Branch</span></td></tr></table>

In my above example i have 9 pairs of <td>'s ,so i added 9*2 = 18 <col /> then it worked perfectly for me.