topic Re: SALV count functionality in Application Development and Automation Discussions

SALV count functionality

Former Member — Tue, 28 Apr 2009 15:19:09 GMT

Hi All,

I'm using SALV for the report output. 'COUNT' functionality in menu path (Edit->Calculate->Count) is greyed out.

Please let me know how to activate this function.

Thanks & regards,

Santhosh

Re: SALV count functionality

former_member194669 — Tue, 28 Apr 2009 15:36:43 GMT

Try this way


    TRY.
        gr_agg = gr_table->get_aggregations( ).
        CALL METHOD gr_agg->add_aggregation
          EXPORTING
            columnname  = 'SLNUMBER'    " <<<  Pass Field Name
            aggregation = if_salv_c_aggregation=>total
          RECEIVING
            value       = gr_agg_t.
      CATCH cx_salv_data_error .
      CATCH cx_salv_not_found .
      CATCH cx_salv_existing .
    ENDTRY.
.....
.....
.....
TRY. 
    GR_TABLE->DISPLAY().
ENTRY.

a®

Re: SALV count functionality

Former Member — Tue, 28 Apr 2009 15:48:29 GMT

did u try copying other gui status in saplkkbl?

Re: SALV count functionality

naimesh_patel — Tue, 28 Apr 2009 16:15:01 GMT

You need to specify the COUNT coulumn and that count coulumn MUST be type I.

To get the COUNT function active, you need to:

1) Set the COUNT Agreegrate Function


  DATA: lr_functions TYPE REF TO cl_salv_functions_list.

  lr_functions = gr_table->get_functions( ).
  lr_functions->SET_AGGREGATION_COUNT( 'X' ).

2) Set the COUNT Column


  DATA: lr_columns TYPE REF TO cl_salv_columns_table,
  lr_columns = gr_table->get_columns( ).
  TRY.
      lr_columns->SET_COUNT_COLUMN( 'SEATSMAX' ).
    CATCH cx_salv_data_error.                           "#EC NO_HANDLER
  ENDTRY.

Now you COUNT function (Edit > Calculate > Count) should be active.

Regards,

Naimesh Patel

Re: SALV count functionality

Former Member — Wed, 29 Apr 2009 10:02:19 GMT

Hi,

Please let me know the data type of the column, whether it should be character or number??

Thanks & regards,

Santhosh