soykies
01/04/08, 10:33:09
Hola,
Necesito crear un subtotal en mi report (tal como indica la figura) que me sume hasta donde esta la linea roja, la columna efectivos, horas norm, horas supl, y h.sup/h.norm:
http://www.mundosap.com/foro/attachment.php?attachmentid=439&stc=1&d=1207045486
Este es mi codigo:
FORM display_alv TABLES i_employee.
PERFORM build_header.
PERFORM build_layout.
PERFORM call_alv TABLES i_employee.
ENDFORM.
-----------------------------------------------------------
FORM build_header.
DATA: v_alv_color TYPE slis_specialcol_alv.
CLEAR gt_fieldcat.
REFRESH gt_fieldcat.
fieldcat_ln-fieldname = 'PERIODO'.
fieldcat_ln-seltext_l = 'Periodo'(001).
APPEND fieldcat_ln TO gt_fieldcat.
fieldcat_ln-fieldname = 'EFECTIVOS'.
fieldcat_ln-seltext_l = 'Efectivos'(002).
fieldcat_ln-do_sum = 'X'.
fieldcat_ln-sp_group = '1'.
APPEND fieldcat_ln TO gt_fieldcat.
fieldcat_ln-fieldname = 'HN'.
fieldcat_ln-seltext_l = 'Horas Norm. Inscritos'(003).
fieldcat_ln-do_sum = 'X'.
APPEND fieldcat_ln TO gt_fieldcat.
fieldcat_ln-fieldname = 'HS'.
fieldcat_ln-seltext_l = 'Horas Supl. Inscritos'(004).
fieldcat_ln-do_sum = 'X'.
APPEND fieldcat_ln TO gt_fieldcat.
fieldcat_ln-fieldname = 'HN_HS'.
fieldcat_ln-seltext_l = 'H.Sup/H.Nor %'(005).
fieldcat_ln-do_sum = 'C'.
APPEND fieldcat_ln TO gt_fieldcat.
ENDFORM. "build_header
---------------------------------------------------------------
FORM build_layout.
gs_layout-colwidth_optimize = 'X'. "Optimizar ancho del listado
gs_layout-zebra = 'X'. "Mostrar líneas tipo cebra.
gs_layout-detail_popup = 'X'. "Mostrar opción de información detalle
gs_layout-totals_text = 'X'.
gs_layout-subtotals_text = 'X'.
ENDFORM. "build_layout
----------------------------------------------------------------
FORM call_alv TABLES alv_employee.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
i_callback_program = 'g_repid'
is_layout = gs_layout
it_fieldcat = gt_fieldcat[]
TABLES
t_outtab = alv_employee
EXCEPTIONS
program_error = 1
OTHERS = 2
ENDFORM. "CALL_ALV
Espero que me puedan echar una mano.
Muchas gracias
Necesito crear un subtotal en mi report (tal como indica la figura) que me sume hasta donde esta la linea roja, la columna efectivos, horas norm, horas supl, y h.sup/h.norm:
http://www.mundosap.com/foro/attachment.php?attachmentid=439&stc=1&d=1207045486
Este es mi codigo:
FORM display_alv TABLES i_employee.
PERFORM build_header.
PERFORM build_layout.
PERFORM call_alv TABLES i_employee.
ENDFORM.
-----------------------------------------------------------
FORM build_header.
DATA: v_alv_color TYPE slis_specialcol_alv.
CLEAR gt_fieldcat.
REFRESH gt_fieldcat.
fieldcat_ln-fieldname = 'PERIODO'.
fieldcat_ln-seltext_l = 'Periodo'(001).
APPEND fieldcat_ln TO gt_fieldcat.
fieldcat_ln-fieldname = 'EFECTIVOS'.
fieldcat_ln-seltext_l = 'Efectivos'(002).
fieldcat_ln-do_sum = 'X'.
fieldcat_ln-sp_group = '1'.
APPEND fieldcat_ln TO gt_fieldcat.
fieldcat_ln-fieldname = 'HN'.
fieldcat_ln-seltext_l = 'Horas Norm. Inscritos'(003).
fieldcat_ln-do_sum = 'X'.
APPEND fieldcat_ln TO gt_fieldcat.
fieldcat_ln-fieldname = 'HS'.
fieldcat_ln-seltext_l = 'Horas Supl. Inscritos'(004).
fieldcat_ln-do_sum = 'X'.
APPEND fieldcat_ln TO gt_fieldcat.
fieldcat_ln-fieldname = 'HN_HS'.
fieldcat_ln-seltext_l = 'H.Sup/H.Nor %'(005).
fieldcat_ln-do_sum = 'C'.
APPEND fieldcat_ln TO gt_fieldcat.
ENDFORM. "build_header
---------------------------------------------------------------
FORM build_layout.
gs_layout-colwidth_optimize = 'X'. "Optimizar ancho del listado
gs_layout-zebra = 'X'. "Mostrar líneas tipo cebra.
gs_layout-detail_popup = 'X'. "Mostrar opción de información detalle
gs_layout-totals_text = 'X'.
gs_layout-subtotals_text = 'X'.
ENDFORM. "build_layout
----------------------------------------------------------------
FORM call_alv TABLES alv_employee.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
i_callback_program = 'g_repid'
is_layout = gs_layout
it_fieldcat = gt_fieldcat[]
TABLES
t_outtab = alv_employee
EXCEPTIONS
program_error = 1
OTHERS = 2
ENDFORM. "CALL_ALV
Espero que me puedan echar una mano.
Muchas gracias