ActiveReports 13
Exporting Reports using Export Filters
ActiveReports 13 > ActiveReports User Guide > Concepts > Exporting > Export Filters > Exporting Reports using Export Filters

ActiveReports provides various export filters that can be used to export Page, Section and Rdl Reports to the supported file formats. Here are the export formats that are included with ActiveReports:

Note: In ActiveReports, by default, the assemblies are located in the ...\Common Files\GrapeCity\ActiveReports 13 folder.

Use the following steps to export reports through export filters. These steps assume that you have already created a Windows Application and added the export controls to your Visual Studio toolbox. For more information, see Adding ActiveReports Controls.

To export a report

  1. In your project's Bin>Debug folder, place the report.rpx (Section Report) or report.rdlx (Page/Rdl Report).
  2. In the Solution Explorer, right-click the References node and select Add Reference.
  3. In the Reference Manager dialog that appears, select the following references and click OK to add them to your project.
    GrapeCity.ActiveReports.Export.Excel
    GrapeCity.ActiveReports.Export.Html
    GrapeCity.ActiveReports.Export.Image
    GrapeCity.ActiveReports.Export.Pdf
    GrapeCity.ActiveReports.Export.Word
    GrapeCity.ActiveReports.Export.Xml
  4. On the Form.cs or Form.vb, double-click the title bar to create the Form_Load event.
  5. In Form_Load event, add the following code to add a report to your project.  

    To add Page/Rdl report to your project

    Visual Basic.NET code. Paste INSIDE the Form_Load event.
    Copy Code
    ' Create a page/Rdl report.
    Dim rpt As New GrapeCity.ActiveReports.PageReport()
    ' Load the report you want to export. 
    ' For the code to work, this report must be stored in the bin\debug folder of your project.
    rpt.Load(New System.IO.FileInfo ("report.rdlx"))
    Dim MyDocument As New GrapeCity.ActiveReports.Document.PageDocument (rpt)                                      
    
    C# code. Paste INSIDE the Form_Load event.
    Copy Code
    // Create a page/Rdl report.
    GrapeCity.ActiveReports.PageReport rpt = new GrapeCity.ActiveReports.PageReport();
    // Load the report you want to export. 
    // For the code to work, this report must be stored in the bin\debug folder of your project.
    rpt.Load(new System.IO.FileInfo ("report.rdlx"));
    GrapeCity.ActiveReports.Document.PageDocument MyDocument = new GrapeCity.ActiveReports.Document.PageDocument (rpt);                
    

    To add Section report to your project

    Visual Basic.NETcode. Paste INSIDE the Form_Load event.
    Copy Code
    ' Create a Section report.
    Dim rpt As New GrapeCity.ActiveReports.SectionReport()
    ' For the code to work, report.rpx must be placed in the bin\debug folder of your project.
    Dim xtr As New System.Xml.XmlTextReader(Application.StartupPath + "\report.rpx")
    rpt.LoadLayout(xtr)
    rpt.Run()
    C# code. Paste INSIDE the Form_Load event.
    Copy Code
    // Create a Section report.
    GrapeCity.ActiveReports.SectionReport rpt = new GrapeCity.ActiveReports.SectionReport(); // For the code to work, report.rpx must be placed in the bin\debug folder of your project. System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(Application.StartupPath + "\\report.rpx"); rpt.LoadLayout(xtr); rpt.Run();
  6. Add the following code to export Page, Rdl and Section Reports to multiple format.
    This code is common for all the report types (.rpx and .rdlx). 

    To write the code in Visual Basic.NET

    Visual Basic.NET code. Paste INSIDE the Form_Load event.
    Copy Code
    ' Export the report in HTML format.
    Dim HtmlExport1 As New GrapeCity.ActiveReports.Export.Html.Section.HtmlExport()
    HtmlExport1.Export(MyDocument, Application.StartupPath + "\HTMLExpt.html")
    
    ' Export the report in PDF format.
    Dim PdfExport1 As New GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport()
    PdfExport1.Export(MyDocument, Application.StartupPath + "\PDFExpt.pdf")
    
    ' Export the report in RTF format.
    Dim RtfExport1 As New GrapeCity.ActiveReports.Export.Word.Section.RtfExport()
    RtfExport1.Export(MyDocument, Application.StartupPath + "\RTFExpt.rtf")
    
    ' Export the report in text format.
    Dim TextExport1 As New GrapeCity.ActiveReports.Export.Xml.Section.TextExport()
    TextExport1.Export(MyDocument, Application.StartupPath + "\TextExpt.txt")
    
    ' Export the report in TIFF format.
    Dim TiffExport1 As New GrapeCity.ActiveReports.Export.Image.Tiff.Section.TiffExport()
    TiffExport1.Export(MyDocument, Application.StartupPath + "\TIFFExpt.tiff")
    
    ' Export the report in Excel format.
    Dim XlsExport1 As New GrapeCity.ActiveReports.Export.Excel.Section.XlsExport()
    ' Set a file format of the exported excel file to Xlsx to support Microsoft Excel 2007 and newer versions.
    XlsExport1.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx
    XlsExport1.Export(MyDocument, Application.StartupPath + "\XLSExpt.xlsx")                                        
    

    To write the code in C#

    C# code. Paste INSIDE the Form_Load event.
    Copy Code
    // Export the report in HTML format.
    GrapeCity.ActiveReports.Export.Html.Section.HtmlExport HtmlExport1 = new GrapeCity.ActiveReports.Export.Html.Section.HtmlExport();
    HtmlExport1.Export(MyDocument, Application.StartupPath + "\\HTMLExpt.html");
    
    // Export the report in PDF format.
    GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport PdfExport1 = new GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport();
    PdfExport1.Export(MyDocument, Application.StartupPath + "\\PDFExpt.pdf");
    
    // Export the report in RTF format.
    GrapeCity.ActiveReports.Export.Word.Section.RtfExport RtfExport1 = new GrapeCity.ActiveReports.Export.Word.Section.RtfExport();
    RtfExport1.Export(MyDocument, Application.StartupPath + "\\RTFExpt.rtf");
    
    // Export the report in text format.
    GrapeCity.ActiveReports.Export.Xml.Section.TextExport TextExport1 = new GrapeCity.ActiveReports.Export.Xml.Section.TextExport();
    TextExport1.Export(MyDocument, Application.StartupPath + "\\TextExpt.txt");
    
    // Export the report in TIFF format.
    GrapeCity.ActiveReports.Export.Image.Tiff.Section.TiffExport TiffExport1 = new GrapeCity.ActiveReports.Export.Image.Tiff.Section.TiffExport();
    TiffExport1.Export(MyDocument, Application.StartupPath + "\\TIFFExpt.tiff");
    
    // Export the report in XLSX format.
    GrapeCity.ActiveReports.Export.Excel.Section.XlsExport XlsExport1 = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport();
    // Set a file format of the exported excel file to Xlsx to support Microsoft Excel 2007 and newer versions.
    XlsExport1.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx;
    XlsExport1.Export(MyDocument, Application.StartupPath + "\\XLSExpt.xlsx");                  
    
    Note: When exporting a report to .MHT file by Export filters use htmlExport.Export(Document doc, Stream outputStream);
    For more information, see HTML Export Method.
  7. Press F5 to run the application. The exported files are saved in the bin\debug folder.
    Caution: To be able to successfully compile application in Visual Studio 2012, you need to edit app.config file as follows:
    • If target framework version of the sample is 4.6.2:
      <dependentAssembly>
              <assemblyIdentity name="System.IO.Compression" culture="neutral" publicKeyToken="b77a5c561934e089"/>
              <bindingRedirect oldVersion="0.0.0.0-4.2.0.0" newVersion="4.0.0.0"/>
      </dependentAssembly>
    • If target framework version is 4.7.0 or higher:
      <dependentAssembly>
              <assemblyIdentity name="System.IO.Compression" culture="neutral" publicKeyToken="b77a5c561934e089"/>
              <bindingRedirect oldVersion="0.0.0.0-4.2.0.0" newVersion="4.2.0.0"/>
      </dependentAssembly>
See Also