FlexReportDesigner with SQLite

FlexReportDesigner with SQLite

Posted by: connellyj on 11 January 2018, 7:05 am EST

• 

  connellyj

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 January 2018, 7:05 am EST

  I am trying to use a SQLite datasource. I have installed the 32-bit ADO.net provider for SQLite (sqlite-netFx46-setup-bundle-x86-2015-1.0.106.0.exe). But in the 32-bit FlexReportDesigner the SQLite Data Provider is greyed out. I have been using SQLite in my Visual Studio application so it is working on my machine. Is there something else I need to do for the FlexReportDesigner ?

• 

  Pragati.Kaushik

  

  • Post Options:
  • Link
    Copy

  Posted 11 January 2018, 8:57 pm EST

  Hi,

  In order to resolve this issue, I would request you to follow the steps given below:

  1. Uninstall current version of System.Data.SQLite.
  2. Reboot the system.
  3. Download sqlite from:
     
     https://system.data.sqlite.org/downloads/1.0.103.0/sqlite-netFx40-setup-bundle-x64-2010-1.0.103.0.exe
  4. Install it, please note, during installation ensure that “install assemblies into gac” option is checked.
  5. On 64bit system you have two machine config files:
     
     C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config and C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config​
     
     find the below mentioned tag of both the files.

  
  <system.data>
          <DbProviderFactories>
                   <!--add tag here-->
          </DbProviderFactories>
  </system.data>​
  
  

  and add this option:

  
  <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite"                type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.103.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
  
  

  It will enable you to use SQLite in FlexReport.

  ~Pragati

• 

  connellyj

  • Post Options:
  • Link
    Copy

  Posted 15 January 2018, 1:19 am EST

  Awesome! Thanks, it works.

  Now… My solution is 11 VB.net projects using .net 4.5 and x86 . The reporting is all done in one of the projects. I am trying to migrate from C1Report to C1FlexReport. I have added all the references listed in the documentation and I have deleted references to C1Reports. My toolbox does include C1FlexReport, C1FlexViewer, C1FlexViewerPane, and C1FlexViewerDialog. I can add the C1FlexReport but none of the others will drop on my form.

  These are my C1 references:
  
  
  
  Did I miss something? is there a step to the process that I missed?
  
  Thanks!

• 

  Pragati.Kaushik

  

  • Post Options:
  • Link
    Copy

  Posted 15 January 2018, 8:58 pm EST

  Hi,

  I am glad to know that it worked.
  
  Your question has been answered here:
  
  https://www.grapecity.com/en/forums/winforms-edition/trouble-adding-c1flexviewe

  ~Pragati