KB-91923: Exporting a report to CSV format.

Question:

Can reports with .CSV extension be generated? I’ve tried doing so with the Export method but haven’t succeeded.

Solution:

Yes, they can. When the report has been previously set up, you can add a separator by selecting a TEXT export; to do so, use the script below.

      Set Report = Application.LoadReport("[Relatório1]")
      Set reportFilter = report.GetExportFilter("TEXT")
      reportFilter.FileName = "C:\report.csv"
      reportFilter.TextDelimiter = ","
      report.Export reportFilter

When no report has been previously created, you can generate de CSV file directly from E3Browser, via Export library .