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. Image for the cookie policy date
  1. Home
  2. Forum
  3. WPF
  4. How can ReportDesigner use an .xlsx as data source ?
Starting in 2019, the Reporting control is no longer included in Essential Studio. If you're experiencing issues with the Syncfusion Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion and appreciate your understanding.

How can ReportDesigner use an .xlsx as data source ?

Hi all & SF,

How can ReportDesigner use an .xlsx file as data source ?

if not possible, is there a trick to transfer the excel content to some intermediate format that ReportDesigner can use ?

Thanks,
Fabrice

3 Replies
VS Vinoth Srinivasan Syncfusion Team May 20, 2016 11:51 AM UTC

Hi Fabrice, 

Thanks for contacting Syncfusion support. 

Yes, you can use excel file as datasource in our ReportDesigner.  In order to display the excel values you have to create a dsn using inbuilt odbc driver for excel and kindly refer the below steps to achieve this.  

1.)   Create dsn using odbc driver to the excel Data Source, refer the below link for video and more details on this.
            Video:            http://www.syncfusion.com/downloads/support/forum/124139/ze/CreateDSN-719170225-943676366
            Online MSDN Link:   https://msdn.microsoft.com/en-us/library/2x0tte0f.aspx  
 
2.)   Run the ReportDesigner application in x86 (32bit platform) and design the report by adding ODBC data source with previously created dsn. For your reference we have attached a video which illustrates how to connect ODBC data source in ReportDesigner, RDL report, excel data and ReportDesigner sample and it can be downloaded from the following location.
          Video:         http://www.syncfusion.com/downloads/support/forum/124139/ze/ReportDesigner_TestODBC1990625340123993743        
          Sample:      http://www.syncfusion.com/downloads/support/forum/124139/ze/ODBC_ReportDesignerDemo1500034550887312028 

Please let us know if you have any questions. 
 
Regards, 
Vinoth.S 


FF fff May 20, 2016 02:08 PM UTC

Thanks Vinoth for your great support.
In point #2 ... are you saying that ReportDesigner does not work in 64bit ?

Fabrice

VS Vinoth Srinivasan Syncfusion Team May 23, 2016 01:30 PM UTC

Hi Fabrice, 
  
Our report designer works in both 64 bit and 32 bit platform. If the Microsoft ODBC driver installed for 32 bit then it will works only in 32 bit mode, so we had suggested you to run in 32 bit version. Kindly refer the below link for more details on this. 
  
  
Regards,
Vinoth.S

Loader.
Up arrow icon