Solved: Schedule report results to be stored on a server i...

Former Member · ‎01-05-2011

Hi All,

there is a requirement to schedule the report results to be saved in Excel or .CSV format and the file to be stored at a server location.

Could anyone please advise how we can achieve this if its possible at all?

Many thanks!

former_member182516 · ‎01-06-2011

Hi Tanu,

You can use the Transaction : RSCRM_BAPI to extract the data to excell of .csv file.

If you are looking for scheduling the report and saving the report in .xls or .csv format in application server check the below links

To Check the Files/Reports in Application Server and Trigger Mail Alerts.

Regards

kp

Former Member · ‎01-06-2011

Hi.

APD is the best way to do it.

Regards.

Former Member · ‎01-05-2011

This is possible using BEx Information Broadcasting.

After Opening the Query in Query Designer, Click on Query -> Publish -> BEx Broadcaster.

There is plenty of help on SCN Downloads / Articles on Information Broadcasting that will walk you step by step.

Here are a few links:

Just search in SCN for Information Broadcasting and you will get plenty of help.

Good Luck.

MP.

Schedule report results to be stored on a server in Excel or .CSV format