Export to PDF from a RadGrid

I am using the data from the RadGrid here to export.

Table

Design of the Grid

  1. <divclass="row TopBar"><%--
  2. <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">--%>
  3. <telerik:RadGridID="RadGridTotalCOD"runat="server"AutoGenerateColumns="False"GroupPanelPosition="Top"AllowPaging="True"AllowFilteringByColumn="True"AllowMultiRowSelection="True"Skin="Outlook"OnItemCommand="RadGridTotalCOD_ItemCommand"OnPageIndexChanged="RadGridTotalCOD_PageIndexChanged"OnPageSizeChanged="RadGridTotalCOD_PageSizeChanged"PageSize="8"OnPdfExporting="RadGridTotalCOD_PdfExporting">
  4. <ClientSettingsEnablePostBackOnRowClick="true">
  5. <SelectingAllowRowSelect="true"/>
  6. </ClientSettings>
  7. <ExportSettingsExportOnlyData="true"Excel-Format="Html"OpenInNewWindow="true">
  8. <PdfPageHeight="210mm"PageWidth="297mm"DefaultFontFamily="Arial Unicode MS"PageTopMargin="45mm"
  9. BorderStyle="Thin"BorderColor="#666666">
  10. </Pdf>
  11. </ExportSettings>
  12. <MasterTableViewDataKeyNames="OrderId">
  13. <CommandItemSettingsShowExportToExcelButton="true"/>
  14. <Columns>
  15. <telerik:GridTemplateColumnFilterControlAltText="Filter TemplateColumn column"UniqueName="TemplateColumn"Display="true"AllowFiltering="false"ShowFilterIcon="false">
  16. <ItemTemplate><%#Container.DataSetIndex+1 %>
  17. </ItemTemplate>
  18. </telerik:GridTemplateColumn>
  19. <telerik:GridTemplateColumnFilterControlAltText="Filter TemplateColumn column"UniqueName="TemplateColumn2"Display="false"AllowFiltering="false"ShowFilterIcon="false"HeaderStyle-Width="100">
  20. <ItemTemplate>
  21. <asp:LabelID="LblOrderId"runat="server"Text='<%#Eval("OrderId") %>'>
  22. </asp:Label>
  23. </ItemTemplate>
  24. </telerik:GridTemplateColumn>
  25. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="OrderId"HeaderText="ORDER ID"DataField="OrderId"Display="false"AllowFiltering="false"ShowFilterIcon="false">
  26. <ColumnValidationSettings>
  27. <ModelErrorMessageText=""/>
  28. </ColumnValidationSettings>
  29. </telerik:GridBoundColumn>
  30. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="OrderNo"HeaderText="ORDER NO"DataField="OrderNo">
  31. <ColumnValidationSettings>
  32. <ModelErrorMessageText=""/>
  33. </ColumnValidationSettings>
  34. </telerik:GridBoundColumn>
  35. <telerik:GridDateTimeColumnFilterControlAltText="Filter column column"UniqueName="OrderDate"HeaderText="ORDER DATE"DataField="OrderDate"AllowFiltering="true"ShowFilterIcon="true"HeaderStyle-Width="150px"DataFormatString="{0:dd/MMM/yyyy}">
  36. <ColumnValidationSettings>
  37. <ModelErrorMessageText=""/>
  38. </ColumnValidationSettings>
  39. </telerik:GridDateTimeColumn>
  40. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="ApplicantName"HeaderText="APPLICANT NAME"DataField="ApplicantName"HeaderStyle-Width="150px">
  41. <ColumnValidationSettings>
  42. <ModelErrorMessageText=""/>
  43. </ColumnValidationSettings>
  44. </telerik:GridBoundColumn>
  45. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="ContactNo"HeaderText="CONTACT NO"DataField="ContactNo"AllowFiltering="true"ShowFilterIcon="true"HeaderStyle-Width="150px">
  46. <ColumnValidationSettings>
  47. <ModelErrorMessageText=""/>
  48. </ColumnValidationSettings>
  49. </telerik:GridBoundColumn>
  50. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="Email"HeaderText="EMAIL"DataField="Email"AllowFiltering="true"ShowFilterIcon="true">
  51. <ColumnValidationSettings>
  52. <ModelErrorMessageText=""/>
  53. </ColumnValidationSettings>
  54. </telerik:GridBoundColumn>
  55. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="ShippingAddress"HeaderText="SHIPPING ADDRESS"DataField="ShippingAddress"AllowFiltering="false"ShowFilterIcon="false"Display="false">
  56. <ColumnValidationSettings>
  57. <ModelErrorMessageText=""/>
  58. </ColumnValidationSettings>
  59. </telerik:GridBoundColumn>
  60. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="Pincode"HeaderText="PIN CODE"DataField="Pincode"AllowFiltering="false"ShowFilterIcon="false"Display="false">
  61. <ColumnValidationSettings>
  62. <ModelErrorMessageText=""/>
  63. </ColumnValidationSettings>
  64. </telerik:GridBoundColumn>
  65. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="CityName"HeaderText="CityName"DataField="CityName"AllowFiltering="false"ShowFilterIcon="false"Display="false">
  66. <ColumnValidationSettings>
  67. <ModelErrorMessageText=""/>
  68. </ColumnValidationSettings>
  69. </telerik:GridBoundColumn>
  70. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="StateName"HeaderText="StateName"DataField="StateName"AllowFiltering="false"ShowFilterIcon="false"Display="false">
  71. <ColumnValidationSettings>
  72. <ModelErrorMessageText=""/>
  73. </ColumnValidationSettings>
  74. </telerik:GridBoundColumn>
  75. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="CountryName"HeaderText="CountryName"DataField="CountryName"AllowFiltering="false"ShowFilterIcon="false"Display="false">
  76. <ColumnValidationSettings>
  77. <ModelErrorMessageText=""/>
  78. </ColumnValidationSettings>
  79. </telerik:GridBoundColumn>
  80. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="PaymentId"HeaderText="Payment Id"DataField="PaymentId"AllowFiltering="false"ShowFilterIcon="false"Display="false">
  81. <ColumnValidationSettings>
  82. <ModelErrorMessageText=""/>
  83. </ColumnValidationSettings>
  84. </telerik:GridBoundColumn>
  85. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="Prices"HeaderText="TOTAL AMOUNT"DataField="Prices"AllowFiltering="false"ShowFilterIcon="false">
  86. <ColumnValidationSettings>
  87. <ModelErrorMessageText=""/>
  88. </ColumnValidationSettings>
  89. </telerik:GridBoundColumn>
  90. <telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="Status"HeaderText="STATUS"DataField="Status">
  91. <ColumnValidationSettings>
  92. <ModelErrorMessageText=""/>
  93. </ColumnValidationSettings>
  94. </telerik:GridBoundColumn>
  95. <telerik:GridTemplateColumnAllowFiltering="false"ShowFilterIcon="false">
  96. <ItemTemplate>
  97. <telerik:RadButtonID="RadBtnAction"runat="server"Text="Action"Skin="Glow"CommandName="cmd_action"CommandArgument='<%#Eval("OrderId") %>'>
  98. </telerik:RadButton>
  99. </ItemTemplate>
  100. </telerik:GridTemplateColumn>
  101. </Columns>
  102. <NestedViewTemplate>
  103. <telerik:RadGridID="RadGridChild"runat="server"AutoGenerateColumns="false"GroupPanelPosition="Top"Skin="Silk">
  104. <ClientSettings>
  105. <SelectingAllowRowSelect="true"/>
  106. </ClientSettings>
  107. <MasterTableViewDataKeyNames="OrderId">
  108. <Columns>
  109. <telerik:GridTemplateColumnFilterControlAltText="Filter TemplateColumn column"UniqueName="TemplateColumn1"Display="false"AllowFiltering="false"ShowFilterIcon="false">
  110. <ItemTemplate><%#Container.DataSetIndex+1 %>
  111. </ItemTemplate>
  112. </telerik:GridTemplateColumn>
  113. <telerik:GridTemplateColumnFilterControlAltText="Filter TemplateColumn column"UniqueName="TemplateColumn3"Display="true"AllowFiltering="false"ShowFilterIcon="false">
  114. <ItemTemplate>
  115. <tablestyle="width: 100%;">
  116. <tr>
  117. <tdstyle="width: 20px;">
  118. </td>
  119. <tdstyle="width: 150px;">
  120. </td>
  121. <tdstyle="width: 2px;">
  122. </td>
  123. <tdstyle="width: 200px;">
  124. </td>
  125. <td></td>
  126. </tr>
  127. <tr>
  128. <td></td>
  129. <td>Your Application No</td>
  130. <td>:</td>
  131. <td>
  132. <asp:LabelID="LblApplicationNo"runat="server"Text='<%#Eval("ApplicationNo") %>'>
  133. </asp:Label>
  134. </td>
  135. <td></td>
  136. </tr>
  137. <tr>
  138. <td></td>
  139. <td>Order No</td>
  140. <td>:</td>
  141. <td>
  142. <asp:LabelID="LblOrderNo"runat="server"Text='<%#Eval("OrderNo") %>'>
  143. </asp:Label>
  144. </td>
  145. <td></td>
  146. </tr>
  147. <tr>
  148. <td></td>
  149. <td>Payment Mode</td>
  150. <td>:</td>
  151. <td>
  152. <asp:LabelID="LblPaymentMode"runat="server"Text='<%#Eval("PaymentMode") %>'>
  153. </asp:Label>
  154. </td>
  155. <td></td>
  156. </tr>
  157. <tr>
  158. <td></td>
  159. <tdcolspan="4">
  160. <tablestyle="width:350px; border:1px solid black;">
  161. <tr>
  162. <tdstyle="width:144px;"class="InnerTblHeadTop">Item Name
  163. </td>
  164. <tdclass="InnerTblHeadTop">
  165. </td>
  166. <tdclass="InnerTblHeadTop">Amount
  167. </td>
  168. </tr>
  169. <tr>
  170. <td>Prospectus Fees</td>
  171. <td>:</td>
  172. <td>
  173. <asp:LabelID="LblProspectusFees"runat="server"Text='<%#Eval("ProspectusFees") %>'>
  174. </asp:Label>
  175. </td>
  176. </tr>
  177. <tr>
  178. <td>EMD1</td>
  179. <td>:</td>
  180. <td>
  181. <asp:LabelID="LblEMD1"runat="server"Text='<%#Eval("EMD1") %>'>
  182. </asp:Label>
  183. </td>
  184. </tr>
  185. <tr>
  186. <tdclass="InnerTblHead">Total Amount
  187. </td>
  188. <tdclass="InnerTblHead">
  189. </td>
  190. <tdclass="InnerTblHead">
  191. <asp:LabelID="LblTotalPrice"runat="server"Text='<%#Eval("Prices") %>'>
  192. </asp:Label>
  193. </td>
  194. </tr>
  195. </table>
  196. </td>
  197. </tr>
  198. <tr>
  199. <td></td>
  200. <td>Email</td>
  201. <td>:</td>
  202. <td>
  203. <asp:LabelID="LblEmail"runat="server"Text='<%#Eval("Email") %>'>
  204. </asp:Label>
  205. </td>
  206. <td></td>
  207. </tr>
  208. <tr>
  209. <td></td>
  210. <td>Shipping Address</td>
  211. <td>:</td>
  212. <tdcolspan="2">
  213. <asp:LabelID="Label1"runat="server"Text='<%#Eval("ShippingAddress") %>'>
  214. </asp:Label>
  215. </td>
  216. </tr>
  217. <tr>
  218. <td></td>
  219. <td>City Name</td>
  220. <td>:</td>
  221. <td>
  222. <asp:LabelID="Label3"runat="server"Text='<%#Eval("CityName") %>'>
  223. </asp:Label>
  224. </td>
  225. <tdstyle="width:150px;">State Name
  226. </td>
  227. <td>:</td>
  228. <td>
  229. <asp:LabelID="Label4"runat="server"Text='<%#Eval("StateName") %>'>
  230. </asp:Label>
  231. </td>
  232. <tdstyle="width:150px;">Country Name
  233. </td>
  234. <td>:</td>
  235. <td>
  236. <asp:LabelID="Label5"runat="server"Text='<%#Eval("CountryName") %>'>
  237. </asp:Label>
  238. </td>
  239. </tr>
  240. <tr>
  241. <td></td>
  242. <td>Pincode</td>
  243. <td>:</td>
  244. <td>
  245. <asp:LabelID="Label2"runat="server"Text='<%#Eval("Pincode") %>'>
  246. </asp:Label>
  247. </td>
  248. <td></td>
  249. </tr>
  250. <tr>
  251. <td></td>
  252. <td></td>
  253. </tr>
  254. </table>
  255. <tablestyle="width:100%;">
  256. <tr>
  257. <tdstyle="width:3px;">
  258. </td>
  259. <td>Thank you, for applying in the Kencloud Partnership Program. Your Application
  260. <b><%#Eval("ApplicationNo") %>
  261. </b> has been successfully submitted
  263. <br/>
  264. and Order No.
  265. <b><%#Eval("OrderNo") %>
  266. </b>has been confirmed for the value of INR
  267. <b><%#Eval("Prices") %>
  268. </b> . The application prospectus kit along with the
  270. <br/>
  271. reciept will be dispatched to your given address shortly.
  273. </td>
  274. </tr>
  275. </table>
  276. </ItemTemplate>
  277. </telerik:GridTemplateColumn>
  278. </Columns>
  279. </MasterTableView>
  280. </telerik:RadGrid>
  281. </NestedViewTemplate>
  282. </MasterTableView>
  283. </telerik:RadGrid><%--
  284. </telerik:RadAjaxPanel>--%>
  285. </div>
Code at the .cs file

Formatting The PDF
  1. #region--Declaring Head Part
  2. for The Pdf Export--
  3. stringheaderMiddleCell = "<h2>My Contact Details </h2>";
  4. stringheaderLeftCell = "<imgsrc=\"Images/sushibar.jpg\" alt=\"sushi bar\" style=\"width:64px; height: 64px;\" />";
  5. stringfooterMiddleCell = "<?page-number?>";#
  6. endregion
  7. privatevoidExportToPdf()
  8. {#region--Export Selected Data To Pdf--
  9. try
  10. {
  11. RadGridTotalCOD.AllowPaging = true;
  12. RadGridTotalCOD.AllowFilteringByColumn = false;
  13. // loading the Grid with data
  14. LoadTotalCod();#
  15. region--Export with format removed--
  16. RadGridTotalCOD.ExportSettings.ExportOnlyData = true;
  17. RadGridTotalCOD.ExportSettings.Pdf.BorderStyle = GridPdfSettings.GridPdfBorderStyle.Thin;
  18. RadGridTotalCOD.ExportSettings.Pdf.BorderType = GridPdfSettings.GridPdfBorderType.NoBorder;
  19. RadGridTotalCOD.ExportSettings.Pdf.BorderType = GridPdfSettings.GridPdfBorderType.AllBorders;
  20. RadGridTotalCOD.ExportSettings.Pdf.PageHeader.MiddleCell.Text = headerMiddleCell;
  21. RadGridTotalCOD.ExportSettings.Pdf.PageHeader.MiddleCell.TextAlign = GridPdfPageHeaderFooterCell.CellTextAlign.Center;
  22. // RadGridTotalCOD.ExportSettings.Pdf.PageHeader.LeftCell.Text = headerLeftCell;
  23. RadGridTotalCOD.ExportSettings.Pdf.PageHeader.LeftCell.TextAlign = GridPdfPageHeaderFooterCell.CellTextAlign.Center;
  24. RadGridTotalCOD.ExportSettings.Pdf.PageFooter.MiddleCell.Text = footerMiddleCell;
  25. RadGridTotalCOD.ExportSettings.Pdf.PageFooter.MiddleCell.TextAlign = GridPdfPageHeaderFooterCell.CellTextAlign.Center;#
  26. endregion
  27. string Date = DateTime.Now.ToString("dd/MMM/yyyy");
  28. RadGridTotalCOD.ExportSettings.FileName = "Client Address " + " " + Date;#
  29. region--Making Visible false some of the column before exporting--
  30. // TemplateColumn, TemplateColumn2, OrderId, OrderNo, OrderDate, Email, Prices, Status
  31. (RadGridTotalCOD.MasterTableView.GetColumn("TemplateColumn") asGridTemplateColumn).Visible = false;
  32. (RadGridTotalCOD.MasterTableView.GetColumn("TemplateColumn") asGridTemplateColumn).Display = false;
  33. (RadGridTotalCOD.MasterTableView.GetColumn("TemplateColumn2") asGridTemplateColumn).Visible = false;
  34. (RadGridTotalCOD.MasterTableView.GetColumn("TemplateColumn2") asGridTemplateColumn).Display = false;
  35. (RadGridTotalCOD.MasterTableView.GetColumn("OrderId") asGridBoundColumn).Visible = false;
  36. (RadGridTotalCOD.MasterTableView.GetColumn("OrderId") asGridBoundColumn).Display = false;
  37. (RadGridTotalCOD.MasterTableView.GetColumn("OrderNo") asGridBoundColumn).Visible = false;
  38. (RadGridTotalCOD.MasterTableView.GetColumn("OrderNo") asGridBoundColumn).Display = false;
  39. (RadGridTotalCOD.MasterTableView.GetColumn("OrderDate") asGridBoundColumn).Visible = false;
  40. (RadGridTotalCOD.MasterTableView.GetColumn("OrderDate") asGridBoundColumn).Display = false;
  41. (RadGridTotalCOD.MasterTableView.GetColumn("Email") asGridBoundColumn).Visible = false;
  42. (RadGridTotalCOD.MasterTableView.GetColumn("Email") asGridBoundColumn).Display = false;
  43. (RadGridTotalCOD.MasterTableView.GetColumn("Prices") asGridBoundColumn).Visible = false;
  44. (RadGridTotalCOD.MasterTableView.GetColumn("Prices") asGridBoundColumn).Display = false;
  45. (RadGridTotalCOD.MasterTableView.GetColumn("Status") asGridBoundColumn).Visible = false;
  46. (RadGridTotalCOD.MasterTableView.GetColumn("Status") asGridBoundColumn).Display = false;#
  47. endregion# region--Making visible true on a Regular Basis--(RadGridTotalCOD.MasterTableView.GetColumn("ShippingAddress") asGridBoundColumn).Visible = true;
  48. (RadGridTotalCOD.MasterTableView.GetColumn("ShippingAddress") asGridBoundColumn).Display = true;
  49. (RadGridTotalCOD.MasterTableView.GetColumn("Pincode") asGridBoundColumn).Visible = true;
  50. (RadGridTotalCOD.MasterTableView.GetColumn("Pincode") asGridBoundColumn).Display = true;
  51. (RadGridTotalCOD.MasterTableView.GetColumn("CityName") asGridBoundColumn).Visible = true;
  52. (RadGridTotalCOD.MasterTableView.GetColumn("CityName") asGridBoundColumn).Display = true;
  53. (RadGridTotalCOD.MasterTableView.GetColumn("StateName") asGridBoundColumn).Visible = true;
  54. (RadGridTotalCOD.MasterTableView.GetColumn("StateName") asGridBoundColumn).Display = true;
  55. (RadGridTotalCOD.MasterTableView.GetColumn("CountryName") asGridBoundColumn).Visible = true;
  56. (RadGridTotalCOD.MasterTableView.GetColumn("CountryName") asGridBoundColumn).Display = true;#
  57. endregion
  58. // Export Only the Parent Grid Data not tHe Inner Grid
  59. RadGridTotalCOD.MasterTableView.HierarchyDefaultExpanded = false; // first level
  60. RadGridTotalCOD.MasterTableView.ExportToPdf();
  61. // Making visible true
  62. RadGridTotalCOD.AllowFilteringByColumn = true;
  63. }
  64. catch (ArgumentNullExceptionExc)
  65. {
  66. LblErrorMsg.Text = "Application Error : " + Exc.Message;
  67. }
  68. catch (InvalidCastExceptionExc)
  69. {
  70. LblErrorMsg.Text = "Application Error : " + Exc.Message;
  71. }
  72. catch (InvalidOperationExceptionExc)
  73. {
  74. LblErrorMsg.Text = "Application Error : " + Exc.Message;
  75. }
  76. catch (FormatExceptionExc)
  77. {
  78. LblErrorMsg.Text = "Application Error : " + Exc.Message;
  79. }
  80. catch (ExceptionExc)
  81. {
  82. LblErrorMsg.Text = "Application Error : " + Exc.Message;
  83. }#
  84. endregion
  85. }