FlexReport - Data Source .CSV file

FlexReport - Data Source .CSV file

Posted by: davidmorr on 8 November 2018, 4:08 pm EST

• 

  davidmorr

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 November 2018, 4:08 pm EST

  I’m converting some old VB 6 programs to VB.NET and upgrading the reports to FlexReport’s. I started creating the report definition and was selecting the datasource. I chose OLE DB Providers, but there’s no way to select a .csv file as the data table. How can I do this? Or do I have to save the data into a SQL, MSAccess, etc. type table?

• 

  Pragati.Kaushik

  

  • Post Options:
  • Link
    Copy

  Posted 13 November 2018, 1:01 am EST

  Hi,

  There is no direct way to bind a report to the csv file in designer. However, you can save the data in MS Access or SQL Server databases and then, use any of them as data source for the report.

  If you want to bind the report to the csv file programmatically, you can load the file in a DataTable instance and then, use this datatable as the datasource of the report. Please refer the following documentation link for more information on this:
  
  http://help.grapecity.com/componentone/NetHelp/FlexReport/webframe.html#UsingDataTableObjectasDataSource.html

  Thanks,
  
  Pragati

• 

  davidmorr

  • Post Options:
  • Link
    Copy

  Posted 13 November 2018, 2:46 pm EST

  Thank you. I’m aware of the workarounds for this, but I was hoping this would work with csv files. We have tons of programs that use this method. My plan B was to create SQL tables for all these files, which I was trying to avoid.

• 

  Pragati.Kaushik

  

  • Post Options:
  • Link
    Copy

  Posted 14 November 2018, 3:00 am EST

  Hi,

  I am sorry but there is no direct way.

  ~Pragati