SQLite with Report Designer

[Helder Liboi]

Hello and good day to you,

Scenario:

I want to design a report in Report Designer that connects with an SQLite database. Then save the report, embed in a .NET application and allow users to access the report on their own local machines with their own databases.

The first step is to connect the Report Designer and SQLite.

I did follow the instructions posted here:Sqlite as database in Report Designer.

In my main machine, I cannot even compile the code because of several not implementations.

(Ex. 'SQLiteDataExtension' does not implement interface member 'IDataExtension.CommandType')

(Using the latest Essential Studio 15.4.0.17. Did check the references and didn't update references as well. Installed Report Designer so to have the separate folder while I also had it installed with Essential Studio.)

After implementing the members I could finally compile.

After I copied the contents to C:\Program Files (x86)\Syncfusion\Report Designer\ReportDesigner as explained and did the alterations to DataExtension.config.

Now Report Designer crashes. In the debugger, the message is related to:

System.IO.FileLoadException: 'Could not load file or assembly 'Syncfusion.Shared.Wpf, Version=15.2450.0.44

In my secondary machine using the previous version of Essential Studio, I did compile without any initial compiling erros.

But when it was time to establish the connection I always got - Test connection not succeed.

Although I tried connection strings that are accepted for PowerBI, Excel and so on when using the ODBC available here (www.ch-werner.de)both 32/64 bits. Besides that, 

I tried using all types of Connection Strings with no success.

Then I tried to connect using the standard ODBC but the only options are Excel Files and MS Acess Database.

How can I proceed from step one?

Could you help me?

Thank you in advance,

Kind Regards,

Helder

[Anandakumar S]

Hi Helder, 

Thanks for your interest in Syncfusion components. 

Question	Response
In my main machine, I cannot even compile the code because of several not implementations.  (Ex. 'SQLiteDataExtension' does not implement interface member 'IDataExtension.CommandType')	We have added new properties to include improvements to our extension datasource support so we request you to implement the missing properties in the interface to resolve in our latest release version.
Now Report Designer crashes. In the debugger, the message is related to:  System.IO.FileLoadException: 'Could not load file or assembly 'Syncfusion.Shared.Wpf, Version=15.2450.0.44	The error shows that the referenced assemblies are mismatch with the existing reference assemblies. We request you to remove the Syncfusion assemblies in the report designer application and add the dependent assemblies with updated Essential Studio 15.4.0.17 version, then clean and rebuild the application. Please find the report designer dependent assemblies below.  https://help.syncfusion.com/wpf/reportdesigner/getting-started
But when it was time to establish the connection I always got - Test connection not succeed.  I tried using all types of Connection Strings with no success.	The connection failed due to the windows credential selected by default in the credentials tab of datasource properties, and the integrated security is appended to connection string. Select the option do not use credential and provide the complete connection string in input box then test the connection of datasource. If you still face any problem then share us the connection string sample to validate at our end.

 

 

Regards, 

Anandakumar S