How can ReportDesigner use an .xlsx as data source ?

[fff]

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]

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 

          Report:      https://www.syncfusion.com/downloads/support/directtrac/general/ze/Report872589045588855671.zip
          Excel data: http://www.syncfusion.com/downloads/support/forum/124139/ze/SampleExcel1599446327-1805458677 

Please let us know if you have any questions. 

 

Regards, 

Vinoth.S 

[fff]

Thanks Vinoth for your great support.

In point #2 ... are you saying that ReportDesigner does not work in 64bit ?

Fabrice

[Vinoth Srinivasan]

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. 

  

https://support.microsoft.com/en-us/kb/2721825 

  

Regards,
Vinoth.S