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.

How can ReportDesigner use an .xlsx as data source ?

Thread ID:

Created:

Updated:

Platform:

Replies:

124139 May 19,2016 12:15 PM May 23,2016 09:30 AM WPF 3
loading
Tags: ReportDesigner
fff
Asked On May 19, 2016 12:15 PM

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

Vinoth Srinivasan [Syncfusion]
Replied On May 20, 2016 07:51 AM

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 


fff
Replied On May 20, 2016 10:08 AM

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

Fabrice

Vinoth Srinivasan [Syncfusion]
Replied On May 23, 2016 09:30 AM

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


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.

;