{"id":758,"date":"2008-01-04T19:58:12","date_gmt":"2008-01-05T02:58:12","guid":{"rendered":"http:\/\/members.crystalreportsbook.com\/crystal-reports-xi\/19-9-exporting-to-pdf-rtf-word\/"},"modified":"2010-11-17T18:48:59","modified_gmt":"2010-11-18T01:48:59","slug":"19-9-exporting-to-pdf-rtf-word","status":"publish","type":"post","link":"http:\/\/www.crystalreportsonlinetraining.com\/training\/19-9-exporting-to-pdf-rtf-word\/","title":{"rendered":"19.09 Exporting to PDF, RTF, Word"},"content":{"rendered":"

Formatting for PDF, RTF, and Word Documents<\/h2>\n

Exporting a report to PDF, RTF or Word gives you the option to specify the page range. You can set the starting and ending page or simply print out the entire report. Note that all pages must be consecutively numbered. For example, you can’t export the first few pages of a report and the last few pages of a report. Table 19-7 shows the properties used for setting the page range.<\/p>\n

Table 19-7. PdfRtfWordFormatOptions Properties.<\/b><\/p>\n\n\n\n\n\n
Property<\/th>\nDescription<\/th>\n<\/tr>\n
FirstPageNumber<\/td>\nThe first page number to export<\/td>\n<\/tr>\n
LastPageNumber<\/td>\nThe last page number to export<\/td>\n<\/tr>\n
UsePageRange<\/td>\nBoolean that enables\/disables the use of page ranges<\/td>\n<\/tr>\n<\/table>\n

When exporting to Word, the process automatically inserts a footer at the bottom of each page that shows “Powered by Crystal” and the Crystal Decisions logo. If you want a continuous flow of data and you don’t want these page footers appearing in your spreadsheet, you have to open the document afterwards and clean it up manually. There is no way to keep this from happening prior to the export. See Figure 19-4 for an example.<\/caution>
\n
\n
\n <\/img>
\n <\/a>
\n Figure 19-4. An exported Word document with the Crystal icon.<\/b>
\n Listing 19-5. Set the export formatting to PDF<\/code_Caption>
\n Public Sub SetFormatPdfRtfWord(ByRef MyReport As CrystalDecisions.CrystalReports.Engine.ReportDocument, ByVal UsePageRange As Boolean, ByVal FirstPageNumber As Integer, ByVal LastPageNumber As Integer)<\/code>
\n 'Change the next line if you want the format to be RTF or Word<\/code>
\n MyReport.ExportOptions.ExportFormatType = _<\/code>
\n CrystalDecisions.[Shared].ExportFormatType.PortableDocFormat<\/code>
\n 'The following lines stay the same regardless of formatting<\/code>
\n Dim Options As New CrystalDecisions.Shared.PdfRtfWordFormatOptions<\/code>
\n Options.UsePageRange = UsePageRange<\/code>
\n If UsePageRange Then<\/code>
\n Options.FirstPageNumber = FirstPageNumber<\/code>
\n Options.LastPageNumber = LastPageNumber<\/code>
\n End If<\/code>
\n MyReport.ExportOptions.FormatOptions = Options<\/code>
\n End Sub<\/code><\/p>\n

The listing first sets the format type to PDF. If you want to export to RTF or Word, then change this line to be the appropriate enumeration needed. After setting the format type, create an options object and set the page range. If all the pages are going to be exported, then set the UsePageRange property to False. Otherwise, to print page ranges set it to True and also set the FirstPageNumber and LastPageNumber properties.<\/p>\n","protected":false},"excerpt":{"rendered":"

Formatting for PDF, RTF, and Word Documents Exporting a report to PDF, RTF or Word gives you the option to specify the page range. You can set the starting and ending page or simply print out the entire report. Note that all pages must be consecutively numbered. For example, you can’t export the first few […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,2],"tags":[],"class_list":["post-758","post","type-post","status-publish","format-standard","hentry","category-chapter-19-exporting-and-deploying-reports","category-crystal-reportsnet-2003","entry"],"_links":{"self":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/comments?post=758"}],"version-history":[{"count":1,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/758\/revisions"}],"predecessor-version":[{"id":1671,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/posts\/758\/revisions\/1671"}],"wp:attachment":[{"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/media?parent=758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/categories?post=758"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.crystalreportsonlinetraining.com\/training\/wp-json\/wp\/v2\/tags?post=758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}