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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How can ReportDesigner use an .xlsx as data source ?

Thread ID:





124139 May 19,2016 04:15 PM UTC May 23,2016 01:30 PM UTC WPF 3
Tags: ReportDesigner
Asked On May 19, 2016 04:15 PM UTC

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 ?


Vinoth Srinivasan [Syncfusion]
Replied On 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. 

Replied On 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 ?


Vinoth Srinivasan [Syncfusion]
Replied On 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. 


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.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon 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.Close Icon