topic Re: ALV grid using Object oriented programming in Application Development and Automation Discussions

ALV grid using Object oriented programming

Former Member — Mon, 11 Dec 2006 09:07:29 GMT

Hi,

I need to display a report with 14 fields of which some fields need sub totals and some fields need average values and some other fields require both subtotals and totals. But if I need only the subtotals. I'm not able to find a way for doing so. Please help.

Thanks and regards

Radhika

Re: ALV grid using Object oriented programming

Former Member — Mon, 11 Dec 2006 09:10:31 GMT

You will have to specify DO_SUM = X for the fields which you want to totalled or sub-totalled and set DO_SUM = C for getting the average of the field. This needs to be done in the field catalog.

Also, specify the SORT criteria for the doing the sub-totals in the IT_SORT table, of the SET_TABLE method or the user can do that himself in the report.

Regards,

Ravi

Note - Please mark all the helpful answers

Re: ALV grid using Object oriented programming

Former Member — Mon, 11 Dec 2006 09:46:29 GMT

Hi Ravi,

I need 'subtotals only' for some fields, but subtotals and totals for other fields. My problem is which option do I need to check to get only subtotals for some fields and subtotals and totals for the other fields.

Thanks and regards

Radhika

Re: ALV grid using Object oriented programming

Former Member — Mon, 11 Dec 2006 09:52:41 GMT

whichever fields you need sub totals populate those filed name s in the sort table

and for which you want totals put do_sum = 'X' for that field in the fieldcatalog.

Re: ALV grid using Object oriented programming

Former Member — Mon, 11 Dec 2006 09:55:55 GMT

Hi Radhika,

1 . those u need only subtotals , Specify those fields in the sort table and give SUBTOT = 'X'

2, Those u need both subtotals and totals specify them in the sort table and also in the fieldcatalog DO_SUM = 'X' for those fields.