topic ALV Grid Column Issue in Application Development and Automation Discussions

ALV Grid Column Issue

Former Member — Sat, 17 Dec 2011 12:29:00 GMT

Hellow Experts,

i got the some code to genrate auto genrated column based on date my out put is as follow


StudentID        Day00  Day01  Day02 ......Day31
   178           20     30      40          50

My Code for genrate day is


LOOP AT gt_cols INTO gs_col.
 TRY.
        CONCATENATE 'DATE' gs_col-date INTO g_col.      "Define Column name
        gr_column ?= gr_columns->get_column( g_col ).   "Get column
        CONCATENATE 'Day' gs_col-date+6(2) INTO g_txt.  "Define new label (Day01, .., Day31)
 gr_column->set_long_text( g_txt ).              "Set label long text
      CATCH cx_salv_not_found.                          "#EC NO_HANDLER
    ENDTRY.


*      CATCH cx_salv_not_found.                          "#EC NO_HANDLER
*    ENDTRY.
  ENDLOOP.

My requirment is i dont need 'Day00' like follow


StudentID         Day01  Day02 ......Day31
   178              30      40          50

PLz help me and Ammend my above code to remove Day00.Thanks

Re: ALV Grid Column Issue

Former Member — Sat, 17 Dec 2011 18:43:01 GMT

LOOP AT gt_cols INTO gs_col.
 TRY.

	IF gs_col-date+6(2) NE '00'.      "Add this IF statement and see if it solves the problem

          CONCATENATE 'DATE' gs_col-date INTO g_col.      "Define Column name
          gr_column ?= gr_columns->get_column( g_col ).     "Get column
          CONCATENATE 'Day' gs_col-date+6(2) INTO g_txt.  "Define new label (Day01, .., Day31)
 	  gr_column->set_long_text( g_txt ).                           "Set label long text

	ENDIF.

      CATCH cx_salv_not_found.                          "#EC NO_HANDLER
    ENDTRY.
 
 
*      CATCH cx_salv_not_found.                          "#EC NO_HANDLER
*    ENDTRY.
  ENDLOOP.

-- Aniruddha

Re: ALV Grid Column Issue

Former Member — Sun, 18 Dec 2011 07:42:58 GMT

Thank a lot Friend its working Fine,

How can i making Do_SUM for Auto Genrated Column Like,User entered date between 01 to 20 so i am able to get 20 column but i need the SUM of column at footer Like Do_SUm , i m not using Field catalog ,Thanks for your help.

Re: ALV Grid Column Issue

Former Member — Sun, 18 Dec 2011 08:03:35 GMT

If I understand your requirement correctly:

Do you want to sum up all the dates in a certain column? If that is so, I guess it would produce an absurd result.

Or is it that, I am not understanding your query correctly?

Re: ALV Grid Column Issue

Former Member — Sun, 18 Dec 2011 08:12:37 GMT

sorry its my mistake i didnt explain completley.

Actually i m getting the O/P


daye1  day2   day3
20      10     20
10      12     14

And i need only the Sub Total Like Follow


      daye1  day2   day3
      20      10     20
      10      12     14
   
     30       22      34      *this is the sub total i need

I m not using Field catalog .Thanks for reponse.