Extract Report Painter result to SAP-BI

Hi pros,

currently we use R/3 reports done with report painter to generate excel files which are afterwards imported to BI via Flatfile connection. This "§$§&!s but the data is needed there and no standard extractor would deliver the data.

I thought about a datasource with function module.... to call a report via ABAP and transfer the data to BI.

Any Idea of how this could work? + Every month another restriction is needed for those reports.

thx

chris