This is a migrated thread and some comments may be shown as answers.

Export to PDF - Borders

8 Answers 275 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Richard asked on 10 Aug 2014, 08:27 PM

radgridexport.jpg

I'm struggling with borders on my Grid export to pdf. I have a grid that contains 3 detail tables. My biggest problem is that the 2nd and 3rd detail grids are not exporting with borders. The first detail grid exports with a border. I've tried changing all settings, and tried applying the borders in the code-behind to no avail. I'm also unable to remove borders. I tried setting the BorderType to "NoBorders", but the output still contains borders. Is there an issue with multiple detail tables? I've attached a sample export.

Here's my grid definition:

<telerik:RadGrid ID="CDMGrid" runat="server"

AllowPaging="True"

AllowSorting="true"

PageSize="25"

AutoGenerateColumns="false" Skin="Office2007"

OnNeedDataSource="CDMGrid_NeedDataSource"

OnItemDataBound="CDMGrid_ItemDataBound"

OnPreRender="CDMGrid_PreRender"

OnDetailTableDataBind="CDMGrid_DetailTableDataBind"

Height="657">

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

<Pdf PageHeight="210mm" PageWidth="297mm" DefaultFontFamily="Arial Unicode MS" PageTopMargin="25mm" BorderStyle="Thin" BorderColor="#666666" BorderType="AllBorders" />

</ExportSettings>

<PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="True" />

<MasterTableView TableLayout="Fixed" DataKeyNames="ServiceCode, HospRegn, TechnicalDesc" Name="MasterTableView">

<Columns>

<telerik:GridBoundColumn UniqueName="HospRegn" DataField="HospRegn" HeaderText="Region" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="60" />

<telerik:GridBoundColumn UniqueName="ServiceCode" DataField="ServiceCode" HeaderText="Svc Code" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="80" />

<telerik:GridBoundColumn UniqueName="GeneralDesc" DataField="GeneralDesc" HeaderText="General Description" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Left" ItemStyle-Font-Size="11px" />

<telerik:GridBoundColumn UniqueName="TechnicalDesc" DataField="TechnicalDesc" HeaderText="Technical Description" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Left" Visible="false" />

<telerik:GridNumericColumn NumericType="Currency" UniqueName="Price1" DataField="Price1" HeaderText="Current Price" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="85" />

<telerik:GridBoundColumn UniqueName="SvcTypeDesc" DataField="SvcTypeDesc" HeaderText="Svc Type" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="100" />

<telerik:GridBoundColumn UniqueName="InsCdStr" DataField="InsCdStr" HeaderText="Ins Cd" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="140" />

<telerik:GridBoundColumn UniqueName="GLKeyStr" DataField="GLKeyStr" HeaderText="GL Key" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="70" />

<telerik:GridDateTimeColumn UniqueName="InactiveDate" DataField="InactiveDate" HeaderText="Inactive Date" HeaderStyle-HorizontalAlign="Center" DataFormatString="{0:d}" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="95" />

</Columns>

<DetailTables>

<telerik:GridTableView AllowPaging="false" AutoGenerateColumns="false" DataKeyNames="" Name="PriceDetail" Width="100%" Font-Size="11px">

<Columns>

<telerik:GridBoundColumn UniqueName="FormulaCode" DataField="FormulaCode" HeaderText="Formula Code" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" />

<telerik:GridNumericColumn NumericType="Currency" UniqueName="Price1" DataField="Price1" HeaderText="Price 1" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="70" />

<telerik:GridNumericColumn NumericType="Currency" UniqueName="Price2" DataField="Price2" HeaderText="Price 2" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="70" />

<telerik:GridNumericColumn NumericType="Currency" UniqueName="Price3" DataField="Price3" HeaderText="Price 3" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="70" />

<telerik:GridNumericColumn NumericType="Currency" UniqueName="Price4" DataField="Price4" HeaderText="Price 4" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="70" />

<telerik:GridBoundColumn DataFormatString="0.00" UniqueName="UnitAmt1" DataField="UnitAmt1" HeaderText="Unit Amt 1" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="70" />

<telerik:GridBoundColumn DataFormatString="0.00" UniqueName="UnitAmt2" DataField="UnitAmt2" HeaderText="Unit Amt 2" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="70" />

<telerik:GridNumericColumn NumericType="Currency" UniqueName="MinPrice" DataField="MinPrice" HeaderText="Min Price" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="70" />

<telerik:GridNumericColumn NumericType="Currency" UniqueName="MaxPrice" DataField="MaxPrice" HeaderText="Max Price" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="70" />

<telerik:GridDateTimeColumn UniqueName="EffectiveDate" DataField="EffectiveDate" HeaderText="Effective Date" HeaderStyle-HorizontalAlign="Center" DataFormatString="{0:d}" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="94" />

</Columns>

</telerik:GridTableView>

<telerik:GridTableView AllowPaging="false" AutoGenerateColumns="false" DataKeyNames="" Name="ProcedureDetail" Width="100%" Font-Size="11px">

<Columns>

<telerik:GridTemplateColumn UniqueName="Filler" />

<telerik:GridBoundColumn UniqueName="SegTypeInd" DataField="SegTypeInd" HeaderText="Seg Type" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="100" />

<telerik:GridBoundColumn UniqueName="ThirdPartyIndStr" DataField="ThirdPartyIndStr" HeaderText="Third Party Ind" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="140" />

<telerik:GridBoundColumn UniqueName="Code" DataField="Code" HeaderText="Code" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="70" />

</Columns>

</telerik:GridTableView>

<telerik:GridTableView AllowPaging="false" AutoGenerateColumns="false" DataKeyNames="" Name="CostCenterDetail" Width="100%" Font-Size="11px" BackColor="#fafdc9">

<Columns>

<telerik:GridTemplateColumn HeaderText="Technical Description" UniqueName="TechnicalDesc" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" ItemStyle-BackColor="#fafdc9" HeaderStyle-Width="250" >

<ItemTemplate>

<div style="padding-right: 16px;">

<asp:Label ID="TechnicalDescLabel" runat="server" Text='<%# Eval("TechnicalDesc")%>' />

</div>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Allowable Cost Centers" UniqueName="AllowableCostCenters" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Right" ItemStyle-BackColor="#fafdc9">

<ItemTemplate>

<div style="padding-right: 16px;">

<asp:Label ID="AllowableCostCentersLabel" runat="server" Text='<%# Eval("CostCenters")%>' />

</div>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<PagerStyle AlwaysVisible="True" />

</MasterTableView>

<ClientSettings>

<Scrolling UseStaticHeaders="true" AllowScroll="true" SaveScrollPosition="True" ScrollHeight="100" />

<Selecting AllowRowSelect="False" />

</ClientSettings>

</telerik:RadGrid>

8 Answers, 1 is accepted

answered on 11 Aug 2014, 12:32 PM

radgridexport.jpg

Thanks Princy. For some reason, the Master grid and first detail grid exported with borders without setting the GridLines property (as in my original attachment). I added the GridLines="Both" to the 2nd and 3rd detail tables and it does indeed add the borders. However, the borders appear thicker than the rest of the grid (please see new attachment). Is there a way I can modify these in the code-behind? I tried adding the following, but it has no effect:

foreach (GridDataItem item in CDMGrid.Items)

{

if (item.OwnerTableView.Name == "ProcedureDetail")

{

GridTableView detailTableView = item.OwnerTableView as GridTableView;

detailTableView.BorderWidth = Unit.Pixel(1);

}