va05 to excel

[Former Member]

HI ,

in va05 report i sorted ORDER NO COULMN so it coming like say

4200033697 10

20 (sorted based on so No)

BUt when i'm exporting to excel it is coming like

4200033697 10

4200033697 20 (so No coming twice)

HOw to export to excel in the same format without any change in sorting/ repetation of order no

Pl suggest

[Former Member]

Hi,

Please go to VA05 -> settings-> layout-> Current. Here you can choose fields whatever you want. After that go to List-> save-> file->Spreadsheet->And here you can give path where you you want to store your data.

Foe Ex.

Directory - C:\Documents and Settings\admin\Desktop\

File Name - .XLS

Then click on generate button

Thanks,

Savita.

Edited by: savita Nevade on Nov 13, 2008 2:34 PM

[Former Member]

HI,

I've tried exporting to excel but format changes (sorting won't come like that itself as in sap)

[Former Member]

hi SW

missing U lot

FOL

Edited by: manoj Patil on Nov 13, 2008 10:18 AM

[Former Member]

Hi ,

As of my knowledge we need to go for a custom report for this , if we need specific format to excel.

Or else we can write a macro in excel so that the data will be in the format as we decided.

Regards,

Vvieks