Sams Teach Yourself .Net in 21 Days

By Jason Beres

• Table of Contents
  • Copyright
  • About the Author
  • About the Technical Editor
  • Acknowledgments
  • We Want to Hear from You
  • Introduction
  • Week 1: At a Glance
  • Day 1. Introduction to the Microsoft .NET Framework
  • Day 2. Introduction to Visual Studio .NET
  • Day 3. Writing Windows Forms Applications
  • Day 4. Deploying Windows Forms Applications
  • Day 5. Writing ASP.NET Applications
  • Day 6. Deploying ASP.NET Applications
  • Day 7. Exceptions, Debugging, and Tracing
  • Week 1. In Review
  • Week 2: At a Glance
  • Day 8. Core Language Concepts in Visual Basic .NET and C#
  • Day 9. Using Namespaces in .NET
  • Day 10. Accessing Data with ADO.NET
  • Day 11. Understanding Visual Database Tools
  • Day 12. Accessing XML in .NET
  • Day 13. XML Web Services in .NET
  • Day 14. Components and .NET
  • Week 2. In Review
  • Week 3: At a Glance
  • Day 15. Writing International Applications
  • Day 16. Using Macros in Visual Studio .NET
  • Day 17. Automating Visual Studio .NET
  • Day 18. Using Crystal Reports
    • Why Use Crystal Reports?
    • Creating a Windows Forms Report
    • Using the Windows Forms Report Viewer
    • How to Programmatically Load a Report
    • Printing a Report Without the Viewer Control
    • Exporting a Report Programmatically
    • Viewing Reports in Web Forms
    • Summary
    • Q&A
    • Quiz
    • Exercises
  • Day 19. Understanding Microsoft Application Center Test
  • Day 20. Using Visual SourceSafe
  • Day 21. Object Role Modeling with Visio
  • Week 3. In Review

Exporting a Report Programmatically

Another useful feature is the ability to export a report document without the end user viewing it first and then clicking the Export button on the toolbar. To do this, you use the ExportOptions collection of the ReportDocument class to set properties on what you want to export and how it should be exported. The code in Listing 18.3 exports a report file to a PDF file and saves it to disk.

Example 18.3. Exporting a Report with Code Using the Export Method

Private Sub button1_Click(sender As Object, e As System.EventArgs)

   ' The path/location where the exported file will be saved
   Dim exportFilePath As String = "c:\Report1.pdf"

   ' Create an instance of the untyped report object
   oRpt = New ReportDocument()

   ' Load the report from disk
   oRpt.Load(reportFile)

   ' Set the options for saving the exported file to disk
   oDest = New DiskFileDestinationOptions()
   oDest.DiskFileName = exportFilePath

   ' Set the exporting information
   oExport = oRpt.ExportOptions

   ' Set the destination options
   oExport.DestinationOptions = oDest

   ' Set the location, this can be:
   ' DiskFile, ExchangeFolder, MicrosoftMail or NoDestination
   oExport.ExportDestinationType = ExportDestinationType.DiskFile

   ' Set the Export type, this can be:
   ' PDF, Excel, Word Doc, RTF Doc,
   ' HTML 3.2, HTML 4.0 or CrystalReport
   oExport.ExportFormatType = ExportFormatType.PortableDocFormat

   ' Call the Export method to export the report
   oRpt.Export()
   MessageBox.Show("Report Exported!")
End Sub

   private void button1_Click(object sender, System.EventArgs e)
   {

      // The path/location where the exported file will be saved
      string exportFilePath = "c:\\Report1.pdf";

      // Create an instance of the untyped report object
      oRpt = new ReportDocument();

      // Load the report from disk
      oRpt.Load(reportFile);

      // Set the options for saving the exported file to disk
      oDest = new DiskFileDestinationOptions();
      oDest.DiskFileName = exportFilePath;

      // Set the exporting information
      oExport = oRpt.ExportOptions;

      // Set the destination options
      oExport.DestinationOptions = oDest;

      // Set the location, this can be:
      // DiskFile, ExchangeFolder, MicrosoftMail or NoDestination
      oExport.ExportDestinationType = ExportDestinationType.DiskFile;

      // Set the Export type, this can be:
      // PDF, Excel, Word Doc, RTF Doc,
      // HTML 3.2, HTML 4.0 or CrystalReport
      oExport.ExportFormatType = ExportFormatType.PortableDocFormat;

      // Call the Export method to export the report
      oRpt.Export();
      MessageBox.Show("Report Exported!");

   }
}

In the commented code in Listing 18.3, you can see the various options for the ExportFormatType and the ExportDestinationType for the report. These are the same properties that you can set in the viewer control.

Share This