ActiveReports and SQLite db

ActiveReports and SQLite db

Posted by: epf_ddol on 14 September 2017, 7:16 pm EST

• 

  epf_ddol

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 7:16 pm EST

  [activereports_archive]We are working on a project developed in WPF with Visual Studio 2015 (.NET framework 4.6) and SQLite database connection.

  I would like to know if it is possible to work with ActiveReports v11 using SQLite db?
  
  If so, how to configure the connection to the DataSource? Any .net examples?

  Thanks in advanced[/activereports_archive]

• 

  abdiasm

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 7:16 pm EST

  [activereports_archive]Yes, you can very much use ActiveReports with Sqlite db. To use Sqldb with ActiveReports, you can set the DataSource Provider to DataSet provider and provide the data in the LocateDataSource event at runtime in an RDL report. Kindly take a look at the DataSetDataSource demo application which gets installed at the following location: \Documents\GrapeCity Samples\ActiveReports 11\Page Reports And RDL Reports\Data\DataSetDataSource

  This demo shows how to set the datasource of the report at runtime to a Dataset. You could get data from the Sqlite db in a DataSet and then assign it to the report.

  The RDL report type in ActiveReports supports data from Multiple tables. You can find more information about RDL reports from the following link: http://arhelp.grapecity.com/webhelp/AR11/index.html#RDL.html[/activereports_archive]

• 

  robert

  • Post Options:
  • Link
    Copy

  Posted 26 January 2018, 4:08 pm EST

  The above had nothing to show how to connect SQLite in code for AR11