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.

Custom data source for the Report Designer

Thread ID:

Created:

Updated:

Platform:

Replies:

131147 Jun 23,2017 09:33 AM Jun 26,2017 12:00 PM Report Platform 2
loading
Tags: Report Designer
SAU
Asked On June 23, 2017 09:33 AM

Hi All,
We have a web based application and our users do not have direct access to the database. We want to give them the capability to do ad hoc report designing.
We are wondering if we can make Syncfusion Report designer to connect to a custom NET data provider that can get meta-data information from our web server using web service calls. We are not using Syncfusion report server.


Thanks,
Saurabh

Mohanapriya Perumakarasu [Syncfusion]
Replied On June 26, 2017 08:34 AM

Hi Saurabh, 
 
Thanks for contacting Syncfusion support. 
 
We can add any extension data sources to report designer with some manual changes. For integrated report designer and report viewer control we need to create new assembly by inheriting our IDataExtension interface to connect with any required data source types. Like the below code sample the DataExtension details need to 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="OLEDB-MD" Assembly="Syncfusion.Reporting.DataExtensions.SSAS"Type="Syncfusion.Reporting.DataExtensions.SSAS.SSASDataExtension"/>  
    </DataExtension>  
  </ReportingExtensions>  
  
We have prepared documentation to create new extension and use it in the report designer. The documentation can be downloaded from the following location.     
Also, we have prepared a sample with SSAS DataExtension for both report designer and report viewer. It can be downloaded from the below location.  
 
Regards, 
P.Mohanapriya

Mohanapriya Perumakarasu [Syncfusion]
Replied On June 26, 2017 12:00 PM

Hi Saurabh, 
 
Please ignore our previous update. 
 
Thanks for your interest in Syncfusion components. 
 
You can use any data provider using extension data source in report designer. A new extension assembly need to be created by inheriting our IDataExtension interface with code logic to connect with required provider. The DataExtension details need to be configured in app.config or DataExtension.config file for ReportDesigner and Report Viewer to use the created extension assembly as given in below code sample. 
 
<configSections>  
      <section name="ReportingExtensions" type="Syncfusion.Reporting.Extensions,  Syncfusion.ReportControls.WPF" allowLocation="true" allowDefinition="Everywhere" />  
  </configSections>  
<ReportingExtensions>  
    <DataExtension>  
        <Extension Name="SSAS" Assembly="Syncfusion.Reporting.DataExtensions.SSAS"Type="Syncfusion.Reporting.DataExtensions.SSAS.SSASDataExtension"/>  
    </DataExtension>  
  </ReportingExtensions>  
  
We have prepared documentation to create new extension and use it in the report designer. The documentation can be downloaded from the following location.     
Also, we have prepared a sample with SSAS DataExtension for both report designer and report viewer. It can be downloaded from the below location.  
 
Regards, 
P.Mohanapriya 


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.

;