1. Home
  2. Forum
  3. Report Platform
  4. Data Source question
If you became a customer of the Syncfusion� Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion� Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion�.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion� for your reporting needs.

Data Source question

Hi,

With the Report Server, can the report data come from a RESTFul source?  If not is there support for MySql connections?

Thanks!

--Michael

8 Replies
YD Yuvaraj Devarajan Syncfusion Team September 28, 2016 11:29 AM UTC

Hi Michael, 

Thanks for contacting Syncfusion support. 

With the Report Server, can the report data come from a RESTFul source?  
No, the report data comes from online database through Reporting WebAPI Restful service. We are using the WebAPI restful service to process and retrieve report data.    
If not is there support for MySql connections? 
Currently, we do not have option to load the Report using MySql datasource in Syncfusion ReportServer. We will consider to include MySql datasource connection option in our upcoming ReportServer build.    
   
But in separate application, we can connect the MySql datasource using Syncfusion.Reporting.DataExtension (external datasource) class library file. So we request you to refer the Syncfusion.Reporting.DataExtension class library file in your application to achieve external datasource support and it can be downloaded from the below location.   
  
To refer the Syncfusion.Reporting.DataExtension class library file in your project, you need to configure the SyncfusionDataExtension in your Web.config file as shown in the below code example.   
  <configSections> 
    <sectionGroup name="SyncfusionDataExtension"> 
      <section name="DataExtension" type="Syncfusion.DataExtension.DataExtension, Syncfusion.EJ.ReportViewer" allowLocation="true" allowDefinition="Everywhere" /> 
    </sectionGroup> 
  </configSections> 
 
   <SyncfusionDataExtension> 
    <DataExtension> 
      <Extensions>         
        <add name="MySQL" assemblyName="Syncfusion.Reporting.DataExtension" classType="Syncfusion.Reporting.DataExtension.MySqlDataExtension"></add> 
      </Extensions> 
    </DataExtension> 
  </SyncfusionDataExtension> 

We have prepared the sample based on this and it can be downloaded from the below location,   

Regards, 
Yuvaraj D. 


MG Michael Gerfen September 29, 2016 01:18 PM UTC

Thanks Yuvaraj.  The sample code is very helpful.

MG Michael Gerfen September 29, 2016 01:38 PM UTC

One more question... in the Invoice Demo solution, there is a missing ODataExtension class.  Could you forward that class to me as well?

Thanks.

YD Yuvaraj Devarajan Syncfusion Team September 30, 2016 07:18 AM UTC

Hi Michael, 

We have included the ODataExtension and MySqlDataExtension class in Syncfusion.Reporting.DataExtension (external datasource) class library file and it can be downloaded from below location, 

We have also prepared the sample using OData connection and it can be downloaded from below location, 

Regards, 
Yuvaraj D. 


MG Michael Gerfen September 30, 2016 06:34 PM UTC

Thanks Yuvaraj.  I have another question.  How do I configure the report designer to see the data extension as a data source?  AFAICT there is not an app.config file shipped with the ReportDesigner.  Must one be created?  

thanks.

YD Yuvaraj Devarajan Syncfusion Team October 3, 2016 12:26 PM UTC

Hi Michael, 
 
We have recently provided the external datasource support for Syncfusion ReportDesigner control. So a support incident has been created under your account. Please log on to our support website to check for further updates.
 https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

Regards, 
Yuvaraj D 


NA Nicolas Alcaraz May 12, 2017 04:16 PM UTC

Hi,
where i can find some sample implementation for reportServer WebApi to download report from sql source
thanks

YD Yuvaraj Devarajan Syncfusion Team May 15, 2017 10:15 AM UTC

Hi Nicolas, 
 
Thanks for contacting Syncfusion support. 
 
We can able to load the Report from SSRS server and Syncfusion ReportServer in ReportViewer. Can you please confirm whether your requirement is to load the report from SSRS server or Syncfusion ReportServer, so that we can guide you based on requirement. Please refer to the below UG documentation link for more detail, 
 
Regards, 
Yuvaraj D. 


Loader.
Up arrow icon