Custom data source for the Report Designer

[SAU]

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]

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.     

http://www.syncfusion.com/downloads/support/forum/131147/doc/DataExtensionProcedures-39958691 

Also, we have prepared a sample with SSAS DataExtension for both report designer and report viewer. It can be downloaded from the below location.  

http://www.syncfusion.com/downloads/support/directtrac/172903/ze/1729031404778950  

 

Regards, 

P.Mohanapriya

[Mohanapriya Perumakarasu]

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.     

http://www.syncfusion.com/downloads/support/forum/131147/doc/DataExtensionProcedures-39958691 

Also, we have prepared a sample with SSAS DataExtension for both report designer and report viewer. It can be downloaded from the below location.  

http://www.syncfusion.com/downloads/support/forum/131147/SALESD~11005327842.ZIP  

 

Regards, 

P.Mohanapriya