ReportServer Forum

HendrikHAZ

Member

Registered: 2016-03-20

Using Excel file as data source for BIRT reports

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

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Using Excel file as data source for BIRT reports

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