How to save/download the report in excel from Report painter.

[Former Member]

Dear Sapmates,

I have created Cost element and Cost centere reports using report painter. Both the reports consists of nine coloumns. I would like to have the report in the excel. I tried the folliwng options :

1. System -> List -> Save -> Local file

2. Settings -> Options -> Microsoft Excel

3. Print and then try to save using the spool request number using SP02.

But neither of the ways worked to download or save the file in the excel format.

Could anybody of you please help me out with this.

Many thanks in advance.

Best regards,

Pabbi.

[Former Member]

After executing the report, select from the top menu:

Report --> Export

In the export to presentation server screen, select spreadsheet as the export format and enter the file location and name in the output file section. Then hit enter or click on the green check mark.

another pop up box will show and this time click on continue.

It will now create the output. check the output location you have entered before for the file.

Hope this helps.

Shail

[Former Member]

Hello Shailender,

Thanks for your reply.

But as u mentioned, there is no option Report -> export, after executing the report the only options that are available under Report are Print and send.

Under any other menus there is no option to export the report. Could u please let me know how to export the report in the way you mentioned earlier.

Many thanks in advance.

Best regards,

Pabbi.

[Former Member]

Hello Shailender,

Thanks for your reply. I solved the issue.

Thank you.

Best regards,

Pabbi.