Plain Text is a format that opens in Notepad or Microsoft Excel depending on the file extension you use in the filePath parameter of the Export method. Use the extension .txt to open files in Notepad, or use .csv to open comma separated value files in Excel. The Text export filter has a number of useful properties that allow you to control your output. You can set the properties either in code using the TextExport object after adding reference to MESCIUS.ActiveReports.Export.Xml package in your project.
Property | Valid Values | Description |
---|---|---|
Encoding | System.Text.ASCIIEncoding (default), System.Text.UnicodeEncoding, System.Text.UTF7Encoding, or System.Text.UTF8Encoding | This property can only be set in code. Enter an enumerated system encoding value to use for character encoding. |
PageDelimiter | String | Enter a character or sequence of characters to mark the end of each page. |
QuotationMode |
|
Specifies whether to add double quotes to the exported data.
|
|
Char | Enter a character to use as quotation mark in the exported text file. Only fields with delimiter characters are quoted. |
SuppressEmptyLines | True (default) or False | Set to False if you want to keep empty lines in the exported text file. Otherwise, white space is removed. |
TextDelimiter | String | Enter a character or sequence of characters to mark the end of each text field. This is mainly for use with CSV files that you open in Excel. |
Usage:
Does not support anything but plain fields and labels:
Use the following steps to export reports through Text export filters.
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() ' Export the report in Text format. Dim TextExport1 As New GrapeCity.ActiveReports.Export.Xml.Section.TextExport() TextExport1.Export(rpt.Document, Application.StartupPath + "\TextExpt.txt") |
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(); // Export the report in Text format. GrapeCity.ActiveReports.Export.Xml.Section.TextExport TextExport1 = new GrapeCity.ActiveReports.Export.Xml.Section.TextExport(); TextExport1.Export(rpt.Document, Application.StartupPath + "\\TextExpt.txt"); |