VF05 report screent to be copied into formated excel sheet

[Former Member]

I would like to copy the VF05 Report screen into formatted excel sheet.

on the output screen of VF05 report, I tried settings-> Display variants: here i have selected the layout, but the data could not copied into this layout

Please help me how this can be done.

VERY URGENT

[Former Member]

Hi,

First format your report as you required go to change layout choose view tab and press save button on the bottom of the screen.

It will ask for the varient name and if you want to make it default then make it defult when you again come into this transaction than this report will display in excel with ur define format.

Regards,

Siddharth

[Former Member]

hello, friend.

as i understand, you want to export the data from VF05 to an excel file. if this is correct, do the following...

first exectue VF05. input the necessary data (payer, material, date ranges, billing type, etc.)

on the next screen, on the menu go to LIST > SAVE > FILE. chosse "Spreadsheet" and ENTER. specify where you want to save the file, the title and the file type (EXCEL file). click "Generate".

now, on your PC, click on the file that you saved. you will now get your report in Excel format.

hope this helped you.

regards.

jty