Sqlite as database in Report Designer

[Sunil Motwani]

Hello,

I would like to wether I can use sqlite Database in Report Designer.

Thanks

[Vinoth Srinivasan]

  

Hi Sunil, 

Thanks for your interest in Syncfusion Components. 

We can use external datasource support to connect SQLite with our report designer and report viewer control. To achieve this, we must create new assembly by inheriting our IDataExtension interface to connect with any required data source types. Like the below code sample the DataExtension details must be mentioned in app.config for ReportDesigner and Report Viewer to use any type of data sources. 

<configSections> 

    <section name="ReportingExtensions" type="Syncfusion.Reporting.Extensions,  Syncfusion.ReportControls.WPF" allowLocation="true" allowDefinition="Everywhere" /> 

</configSections> 

<ReportingExtensions> 

    <DataExtension> 

      <Extension Name="SQLite" Assembly="Syncfusion.Reporting.DataExtensions.Sqlite" Type="Syncfusion.Reporting.DataExtensions.Sqlite.SQLiteDataExtension" /> 

    </DataExtension> 

</ReportingExtensions> 

 

Also, we have prepared a document with details for creating data extension using SQLite and using the SQLite in our report designer and sample with SQLite DataExtension for report designer. It can be downloaded from the below location. 

Document : http://www.syncfusion.com/downloads/support/directtrac/186893/ze/DataExtensionProceduresForSQLite-1405308965 

 

SQLite DataExtension with report designer : http://www.syncfusion.com/downloads/support/directtrac/186893/7z/SQLite1804941347 

  

Regards,  

Vinoth S. 

[Sunil Motwani]

Thanks Vinoth Srinivasan for so quick reply,

I didn't seen yet my life..... Thanks again,

I would like to ask more.

If I create reports in your report Designer, do i have to install some of your products on Client's Machine also ? (Just like we do for Crystal Reports ) and if yes then please specify Why ? 

Sorry my question is totally irrelevant, bcoz, I am developing at my own.

And can you give that modified dll file. Please.... its an request.

Thanks

[Ewen Wallace]

Is it possible to make the document and extension links available to other members, or is there a newer way to use SQLite with the Report Designer? In my case in WPF.

Cheers

Ewen

[Muthuramana Sankaranarayanan]

Hi Ewen, 

We have already provided the WPF sample of Report Designer and the document in our previous response. Please let us know about more details in specific about your requirement regarding your previous query. 

Also as per our plan of having the reporting components as separate from our Syncfusion Essential Studio, we have introduced Bold Reports from Syncfusion. Based on this migration, we will not have any further feature updates with Syncfusion Essential Studio reporting products from now onwards. So, you need to consider migrating the reporting components with Bold Reports libraries with changes in namespace and declarations for getting new feature updates. 

Note: 

You can use your existing Essential Studio license to get our Report Viewer SDK from Bold Reports. Please find the details below, 

  

1. You have to login with Bold Reports using Syncfusion account,

 

2. Once you have logged in Bold Reports, if you are having eligible license to access of Report Viewer SDK then you will be able to get the Report Viewer SDK from downloads.

 

3. Note: If you are having any problem to get the access of Report Viewer SDK with Bold Reports then you must contact sales team to provide more details about your license and direct you to get the Report Viewer SDK in Bold Reports.

 

 

4. We have released Bold Reports with licensing, So, additionally you must register the license key in startup of your application as explained in below documentation,

https://documentation.boldreports.com/licensing/license-key/ 

  

Regards, 

Muthu Ramana S 

[Tim Dong]

Hello,

I am trying to connect sqlite to the Report Designer using the following data source, but cannot get the connection through:

Data Source=C:\Users\qd18830\source\repos\UnitQualityAssuranceMeasures\UnitQualityAssuranceMeasures\Database\test.db

Please could you make available the example solution for connecting report designer to sqlite to me 

Thanks 

[Muthuramana Sankaranarayanan]

Hi Tim, 

As of now we do not have the inbuilt support with Bold Report Designer for SQL Lite datasource. However you can achieve this by adding the SQL Lite custom data extension with Report Designer. Please find the below steps to configure the report data extension for ASP.Net core Report Designer, 

Step1: Add the SQLite Extension project reference to our Bold Reports ReportDesigner sample as shown in below snap:    

       

   

Step2: Add the Configuration section in appConfig file as shown in below code example.    

    

app.config    

 <?xml version="1.0" encoding="utf-8"?>    

<configuration>    

  <configSections>    

    <section name="ReportingExtensions" type="BoldReports.Configuration.Extensions, BoldReports.Web" allowLocation="true" allowDefinition="Everywhere" />    </configSections>    

  <ReportingExtensions>    

    <DataExtension>    

      <Extension Name="SQLite" Assembly="BoldReports.DataExtensions.SQLite" Type="BoldReports.DataExtensions.SQLite.SQLiteDataExtension">  

        <Properties>    

          <Add Key="QueryDesignerEnabled" Value="false"/>    

          <Add Key="QueryFilterEnabled" Value="false"/>    

          <Add Key="QueryExpressionEnabled" Value="false"/>    

          <Add Key="QueryJoinerEnabled" Value="false"/>    

          <Add Key="QueryColumnEdit" Value="false"/>    

        </Properties>    

      </Extension>    

    </DataExtension>    

  </ReportingExtensions>    

</configuration>>    

   

Step3: Add ReportDataExtensions in our index.cshtml file via ViewBag as shown in below code example. 

    

Index.cshtml:    

<bold-report-designer id="reportdesigner1" create="controlInitialized" service-url="../Home" report-data-extensions="@ViewBag.ReportDataExtensions">    

    

</bold-report-designer>    

    

        public ActionResult Index()    

        {    

            ViewBag.ReportDataExtensions = new List<ReportDataExtensionsModule>();  

      var ReportDataExtension = new ReportDataExtensionsModule();  

      ReportDataExtension.Name = "SQLite";  

      ReportDataExtension.ClassName = "SQLiteDataSource";  

      ReportDataExtension.ImageClass = "e-reportdesigner-datasource-sqlite";  

      ReportDataExtension.DisplayName = "SQLite";  

      ViewBag.ReportDataExtensions.Add(ReportDataExtension);  

            return View();    

        }    

    

Output snap:    

       

 

We have also prepared a sample for this. Please find the sample from below download link, 

  

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/SQLiteReportDesigner-152031412 

    

Regards, 

Muthu Ramana S