List->Export->Spreadsheet option disabled in ALV Report

[Former Member]

Hi,

In one of the ALV Report the option List->Export->Spreadsheet option is disabled. How to enable that option?

I am calling the REUSE_ALV_GRID_DISPLAY Function module with the following parameters

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

i_callback_program = w_repid

it_fieldcat = i_fieldtab[]

is_layout = ls_layout

it_events = i_events[]

i_save = 'A'

is_variant = i_variant

TABLES

t_outtab = it_display

EXCEPTIONS

program_error = 1

OTHERS = 2.

This is the problem with only this report. So I believe it is not due to authorization.

Regards,

Anusha

[Former Member]

Hi Everybody,

I could resolve this issue. The problem was the table which was being displayed in the ALV_Output was referring to one element which was a structure. I cahnged this to data element and the issue was resolved.

Regards,

Anusha

[Former Member]

Hi Anusha,

This link should help you. You just need to change the deep structure.

[;

You already figured it out

Edited by: sap_wiz on Jul 6, 2011 4:42 PM