alv report

[Former Member]

This is the output of ALV. I dont need the last line which is underline. What can i do. The report is subtotaled by the currency. Pls help me to do.

EUR 100.00 133.33

EUR 0.00 0.00

EUR 0.00 0.00

EUR 0.00 0.00

EUR 0.00 0.00

EUR 2,000.00 2,666.67

EUR 1,000.00 1,333.33

EUR 8,200.00 10,933.33

<b>EUR 11,300.00 15,066.66</b>

JPY 1,248,000.00 1,057,627.12

JPY 1,090,509.44 924,160.54

<b>JPY 2,338,509.44 1,981,787.66</b>

<u><i><b>2,349,809.44 1,996,854.32</b></i> - The total displyed in last line.

Message was edited by:

Murugan Arumugam

[Former Member]

if you don't want the total line then leave the do_sum attribute in your field catalog as blank instead of 'X' for the relevant column...

regards

Priyank

[Former Member]

hi Priyank Jain

If i do like that, the subtoal also wont come . I need total for second column. but i dont need for the 1st column. Pls help me to do.

I try with layout-no_totalline = 'x'. but it results the suppression of the both the column. i dont want only one column.

Thanks.

[Former Member]

Go to field catalog. comment out 'Do_sum' parameters in the field catalog.

Ex:

• fieldcatalog-do_sum = 'X'.

[Former Member]

Hello Murugan,

In the fieldcatalog of the field make the total field as space.

<b>fieldcat-do_sum = space.</b>

REgards,

VAsanth

[Former Member]

Hi Murugan,

If you don't want the total, then you can remove the total from the fieldcat. But keeping the subtotal , as you want the subtotal to be displayed.

Regards,

Jayant

[Former Member]

hi Jayant Sahu

can u explain with example.

[Former Member]

hi,

d_fieldcat_wa-fieldname ='CURRENCY'.

d_fieldcat_wa-do_sum = ' '.

append d_fieldcat_wa to d_fieldcat.

clear d_fieldcat_wa.

Reward with points if helpful.