Download ALV into excel file

[Former Member]

Hi experts,

I used subtotals in ALV.first three columns I claculated based on the addition of individual column.In fourth column i calculated the value based on three calculated values ...It is not problem.

when i download this into excel file the original value is only coming .the calculated value i.e) calculated based on three values didnt get displayed in excel file..Help me please...

Thank u,

Manjula Devi.D

[Former Member]

Hi,

When you download to excel, all your ALVs sort criteria, Filter criteria, and subtotal criteria is not taken into consideration.

Did you not get a pop-up with this message when you tried to download to excel?

Regards,

Subramanian

[Former Member]

I hope if you are able to see it in print preview, you should be able to download in XL too.

Try downloading in text or as html.

thnx,

ags.

[Former Member]

Hi, If you are using the export button in the toolbar don't use the excel

button, use the Local File.... button on the toolbar. When you click on this

you will be able to export to excel.

You will see all your subtotals

[Former Member]

Besides, implement these function modules:

call function 'ALV_OPTIONS_FOR_SUBTOTALS'

call function 'ALV_GROUPLEVELS_GET'

call function 'ALV_SUBTOTALS_GET'

[Former Member]

Hi.

I find that

List > Export > Spreadsheet

gives no subtotals, but

List > Export > Local File and then Spreadsheet

does give subtotals.

I find that

Views > Microsoft Excel

followed by

Save As

does give subtotals.

John

[Former Member]

hi,

check this link