Using Excel file as data source for BIRT reports

ReportServer (EN)
1

Hi there,
I am new to report server and would like to know if it is possible to use an excel file as a data source for a BIRT report.
I can’t find a place in the data sources tab where I can specify an excel file.
Thank you!
B RGDS
Hendrik Hannemann

2

Hi Hendrik,

ReportServer does not directly support Excel documents as datasources which means that there are basically two ways to do this.

  1. You could use a script datasource. This is however not trivial.
  2. You could save your Excel document as a CSV file and use a CSV datasource. This is probably the easiest to go ahead.

I hope this helps,

Cheers
Arno