We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Data Source question

Thread ID:

Created:

Updated:

Platform:

Replies:

126156 Sep 27,2016 03:50 PM May 15,2017 06:15 AM Report Platform 8
loading
Tags: Report Viewer
Michael Gerfen
Asked On September 27, 2016 03:50 PM

Hi,

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

Thanks!

--Michael

Yuvaraj Devarajan [Syncfusion]
Replied On September 28, 2016 07:29 AM

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. 


Michael Gerfen
Replied On September 29, 2016 09:18 AM

Thanks Yuvaraj.  The sample code is very helpful.

Michael Gerfen
Replied On September 29, 2016 09:38 AM

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

Thanks.

Yuvaraj Devarajan [Syncfusion]
Replied On September 30, 2016 03:18 AM

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. 


Michael Gerfen
Replied On September 30, 2016 02:34 PM

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.

Yuvaraj Devarajan [Syncfusion]
Replied On October 3, 2016 08:26 AM

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 


Nicolas Alcaraz
Replied On May 12, 2017 12:16 PM

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

Yuvaraj Devarajan [Syncfusion]
Replied On May 15, 2017 06:15 AM

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. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;