topic Re: about alv layout in Application Development and Automation Discussions

about alv layout

Former Member — Fri, 15 Jun 2007 02:03:31 GMT

i used CL_GUI_ALV_GRID>->set_table_for_first_display

to display alv

but why the subtotal and total button are gray in the toolbar.

i searched the help, but there is no parameter to adjust the layout.

who met such problem, please give me a favor

thank u in advance

Kevin

Re: about alv layout

former_member194669 — Fri, 15 Jun 2007 02:10:44 GMT

Hi,

In the field catalog field in which field you want to make sum to be populate with


i_fieldcat-do_sum = 'X'.

aRs

Re: about alv layout

Former Member — Fri, 15 Jun 2007 02:18:58 GMT

i mean total&subtotal button are gray.

Re: about alv layout

former_member194669 — Fri, 15 Jun 2007 02:24:36 GMT

Have you populate the field catalog DO_SUM" against field you want to total?

if you done, button will get enabled

aRs

Re: about alv layout

Former Member — Fri, 15 Jun 2007 02:29:52 GMT

Hello, aRs,

thanks for your quick reply.

would u please give some sample code

thank u,

Re: about alv layout

former_member194669 — Fri, 15 Jun 2007 02:36:46 GMT

Hi,


it is not calculated in the class but you pass some values to the grid in the field catalogue like this:

CALL METHOD mygrid->set_table_for_first_display
EXPORTING
it_toolbar_excluding = t_fcodes[]
CHANGING
it_outtab = mytable[]
it_fieldcatalog = field_catal[].


for your field catalogue you can fill the table so

CALL FUNCTION 'LVC_FIELDCATALOG_MERGE'
EXPORTING
i_structure_name = 'SFLIGHT'
CHANGING
ct_fieldcat = field_catal.

field_catal is of type lvc_t_fcat and this one has among others fields DO_SUM. 

For example:if you want to sum airline fare

field_catal-fieldname = 'FARE'
field_catal-do_sum = 'X'. 
modify field_catal.

aRs

Re: about alv layout

Former Member — Fri, 15 Jun 2007 02:42:41 GMT

Add Default Sorting to ALVgrid report   

In order to display an ALV report with specific columns already sorted by default you will need to build a 
sort catalogue. This is fairly straight forward and is done in the following way:

        Step 1. Add data declaration for sort catalogue
        Step 2. Add code to build sort catalogue table  
        Step 3. Update 'gd_tree->set_table_for_first_display' method call to include parameter 'it_sort'
 

*  ALV data declarations
  data: it_sortcat     type LVC_T_SORT,
        it_sortcatdb   type LVC_T_SORT.
perform build_sortcat.

*&------------------------------------------------------------------*
*&      Form  build_sortcat
*&------------------------------------------------------------------*
*       Build Sort catalog
*-------------------------------------------------------------------*
FORM build_sortcat .
  wa_sort-spos      = 1.
  wa_sort-fieldname = 'EBELN'.
  wa_sort-SUBTOT    = 'X'. "subtotals any totals column by this field
*  gd_sortcat-tabname
  APPEND wa_sort TO it_sortcat.

  wa_sort-spos      = 2.
  wa_sort-fieldname = 'EBELP'.
*  gd_sortcat-tabname
  APPEND wa_sort TO it_sortcat.
ENDFORM.                    " build_sortcat

 CALL METHOD gd_tree->set_table_for_first_display
    EXPORTING
      is_layout       = gd_layout
    CHANGING
      it_fieldcatalog = gd_fieldcat
      it_sort         = it_sortcat
      it_outtab       = it_report.

rewaard points if it is usefull ...

Girish

Re: about alv layout

Former Member — Fri, 15 Jun 2007 05:37:32 GMT

why the button is gray, i mean i cannot use the button of subtotal & total.

Re: about alv layout

Former Member — Fri, 15 Jun 2007 07:36:57 GMT

the button of subtotal & total & average can not be used, always is gray

Why???

Re: about alv layout

Former Member — Fri, 15 Jun 2007 15:50:38 GMT

the problem have been sloved.

the field u wanna total or sutotal shouldnot be defined into ‘Char' type.

Re: about alv layout

Former Member — Fri, 15 Jun 2007 15:51:13 GMT

the problem have been sloved.

the field u wanna total or sutotal shouldnot be defined into ‘Char' type.