topic Re: Problem in ALV reports! in Application Development and Automation Discussions

Problem in ALV reports!

Former Member — Sun, 17 Apr 2011 09:22:55 GMT

Hi,

I want to generate a report in ALV using a combined fields from 2 tables... I have already created an internal table from these two DB table fields using the inner join. in the ALV report i want the reslt of each field to be displayed in the report.. for Example:

field1 in internal table contain (amount 13324.225 34432.214 ....ans so on) so in the ALV i want to calculate the result of all the entries regarding this particular field..

depending on a particular period of time which be choosen from a select-option..

please advice how to do that??

Re: Problem in ALV reports!

huseyindereli — Sun, 17 Apr 2011 11:37:02 GMT

Hi ,

I'm not sure about your need but if you like sum up your fields , you can use do_sum as below. Totals will appear automatically.

LOOP AT gt_fieldcat.
if gt_fieldcat-fieldname = 'YOUR_COLUMN'.
   gt_fieldcat-do_sum = 'X'.
endif.

  MODIFY gt_fieldcat.
ENDLOOP.

Regards.

Re: Problem in ALV reports!

Former Member — Mon, 18 Apr 2011 10:08:19 GMT

Hi,

If you are creating the field catalog manually, then use for that particular field you need the summation result. Otherwise if you are getting the field catalog using then give the loop and modify your field catalog for changes.

Thanks,

Re: Problem in ALV reports!

Former Member — Sun, 15 May 2011 05:31:25 GMT

Thank you all,

Problem Resolved!