topic Re: ALV subtotal Issue... in Application Development and Automation Discussions

ALV subtotal Issue...

Former Member — Tue, 28 Aug 2007 15:10:54 GMT

Hi Friends,

I m doing OOPs based ALV using classes.

I want subtotal of my line item(at customer level) but i don't want grand total line that comes at the end of report.

When i use class <b>cl_salv_aggregations</b> to get subtotal, i am also getting grand total line.

Please tell me how can i get <b>only subtotal and NO grand total line</b> ..

Thanks

Former Member — Mon, 03 Sep 2007 07:45:30 GMT

Try to set the attribute NO_TOTLINE = 'X' in the ALV grid layout structure LVC_S_LAYO.

Regards,

Rao A

Former Member — Wed, 05 Sep 2007 10:54:10 GMT

Hi,

guess this will help.

For subtotal,

TYPE-POOLS: SLIS.

DATA: GS_SORT TYPE SLIS_SORTINFO_ALV.

CLEAR GS_SORT.

GS_SORT-FIELDNAME = 'FIELD1'.

GS_SORT-SPOS = 1. “ Sort first on column FIELD1.

GS_SORT-UP = 'X'.“ Ascending order.

GS_SORT-SUBTOT = 'X'.“ Display sub-total at change of

“ FIELD1.

APPEND GS_SORT TO GT_SORT.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

is_layout = ls_layout

it_fieldcat = lt_fieldcat

it_sort = gt_sort

TABLES

t_outtab = gt_vbak.

ENDFORM. " F_DISPLAY_DATA

Regards,

Rama Murthy.P