ALV printing

[Former Member]

Help!

I have an alv grid displayed on the screen. When I click 'print preview' the data of the last column is shown as a single row in the output. Can anyone tell me what causes this?

Thus like this:

Display:

Column1 column2 column3

11 12 13

21 22 23

31 32 33

...

Print:

Column1 column2 column3

13 23 33 ...

Regards,

Rene Vink

[Former Member]

Hi,

Really interesting. and Can you show your Fieldcatalog population. and are you sure last column is displayed as single row...?

any way if possible show your code?

Regards

vijay

[Former Member]

Hi,

Really interesting. and Can you show your Fieldcatalog population. and are you sure last column is displayed as single row...?

any way if possible show your code?

Regards

vijay

[Former Member]

vijay,

This is the code for populating the field catalog.

FORM init_fieldcat USING p_tabname TYPE slis_tabname.

DATA: ls_fieldcat TYPE slis_fieldcat_alv.

CLEAR gd_fieldcat.

*

• group1 type ty_group, "Grouping 1

CLEAR ls_fieldcat.

ls_fieldcat-col_pos = 1.

ls_fieldcat-fieldname = 'GROUP1'.

ls_fieldcat-tabname = 'IT_REPORT'.

ls_fieldcat-key = c_true.

ls_fieldcat-seltext_s = g_group1.

ls_fieldcat-seltext_m = g_group1.

ls_fieldcat-seltext_l = g_group1.

ls_fieldcat-outputlen = 48.

• ls_fieldcat-reptext_ddic = 'group 1'.

APPEND ls_fieldcat TO gd_fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-col_pos = 2.

ls_fieldcat-fieldname = 'GROUP2'.

ls_fieldcat-tabname = 'IT_REPORT'.

ls_fieldcat-key = c_true.

ls_fieldcat-seltext_s = g_group2.

ls_fieldcat-seltext_m = g_group2.

ls_fieldcat-seltext_l = g_group2.

ls_fieldcat-outputlen = 48.

• ls_fieldcat-reptext_ddic = 'group 2'.

APPEND ls_fieldcat TO gd_fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-col_pos = 3.

ls_fieldcat-fieldname = 'MANPOWER'.

ls_fieldcat-tabname = 'IT_REPORT'.

ls_fieldcat-key = c_false.

ls_fieldcat-seltext_s = text-050.

ls_fieldcat-seltext_m = text-020.

ls_fieldcat-seltext_l = text-020.

• ls_fieldcat-reptext_ddic = 'Manpower'.

ls_fieldcat-do_sum = c_false.

APPEND ls_fieldcat TO gd_fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-col_pos = 4.

ls_fieldcat-fieldname = 'ILLNESSR'.

ls_fieldcat-tabname = 'IT_REPORT'.

ls_fieldcat-key = c_false.

ls_fieldcat-seltext_s = text-051.

ls_fieldcat-seltext_m = text-021.

ls_fieldcat-seltext_l = text-021.

• ls_fieldcat-reptext_ddic = 'Illnessrate'.

APPEND ls_fieldcat TO gd_fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-col_pos = 5.

ls_fieldcat-fieldname = 'AVDURAT'.

ls_fieldcat-tabname = 'IT_REPORT'.

ls_fieldcat-key = c_false.

ls_fieldcat-seltext_s = text-052.

ls_fieldcat-seltext_m = text-022.

ls_fieldcat-seltext_l = text-054.

• ls_fieldcat-reptext_ddic = 'Average duration'.

APPEND ls_fieldcat TO gd_fieldcat.

CLEAR ls_fieldcat.

ls_fieldcat-col_pos = 6.

ls_fieldcat-fieldname = 'AVFREQ'.

ls_fieldcat-tabname = 'GT_REPORT'.

ls_fieldcat-key = c_false.

ls_fieldcat-seltext_s = text-053.

ls_fieldcat-seltext_m = text-023.

ls_fieldcat-seltext_l = text-055.

• ls_fieldcat-reptext_ddic = 'Average frequency'.

APPEND ls_fieldcat TO gd_fieldcat.

ENDFORM. " init_fieldcat

PS: what do you mean by "clearing the fields", which fields?

Regards,

Rene Vink

[Former Member]

Hi,

FORM init_fieldcat USING p_tabname TYPE slis_tabname.

DATA: ls_fieldcat TYPE slis_fieldcat_alv.

CLEAR gd_fieldcat.
*
* group1 type ty_group, "Grouping 1
CLEAR ls_fieldcat.
ls_fieldcat-col_pos = 1.
ls_fieldcat-fieldname = 'GROUP1'.
ls_fieldcat-tabname = 'IT_REPORT'.
ls_fieldcat-key = c_true.
ls_fieldcat-seltext_s = g_group1.
ls_fieldcat-seltext_m = g_group1.
ls_fieldcat-seltext_l = g_group1.
ls_fieldcat-outputlen = 48.
* ls_fieldcat-reptext_ddic = 'group 1'.
APPEND ls_fieldcat TO gd_fieldcat.

CLEAR ls_fieldcat.
ls_fieldcat-col_pos = 2.
ls_fieldcat-fieldname = 'GROUP2'.
ls_fieldcat-tabname = 'IT_REPORT'.
ls_fieldcat-key = c_true.
ls_fieldcat-seltext_s = g_group2.
ls_fieldcat-seltext_m = g_group2.
ls_fieldcat-seltext_l = g_group2.
ls_fieldcat-outputlen = 48.
* ls_fieldcat-reptext_ddic = 'group 2'.
APPEND ls_fieldcat TO gd_fieldcat.

CLEAR ls_fieldcat.
ls_fieldcat-col_pos = 3.
ls_fieldcat-fieldname = 'MANPOWER'.
ls_fieldcat-tabname = 'IT_REPORT'.
ls_fieldcat-key = c_false.
ls_fieldcat-seltext_s = text-050.
ls_fieldcat-seltext_m = text-020.
ls_fieldcat-seltext_l = text-020.
* ls_fieldcat-reptext_ddic = 'Manpower'.
ls_fieldcat-do_sum = c_false.
APPEND ls_fieldcat TO gd_fieldcat.

CLEAR ls_fieldcat.
ls_fieldcat-col_pos = 4.
ls_fieldcat-fieldname = 'ILLNESSR'.
ls_fieldcat-tabname = 'IT_REPORT'.
ls_fieldcat-key = c_false.
ls_fieldcat-seltext_s = text-051.
ls_fieldcat-seltext_m = text-021.
ls_fieldcat-seltext_l = text-021.
* ls_fieldcat-reptext_ddic = 'Illnessrate'.
APPEND ls_fieldcat TO gd_fieldcat.

CLEAR ls_fieldcat.
ls_fieldcat-col_pos = 5.
ls_fieldcat-fieldname = 'AVDURAT'.
ls_fieldcat-tabname = 'IT_REPORT'.
ls_fieldcat-key = c_false.
ls_fieldcat-seltext_s = text-052.
ls_fieldcat-seltext_m = text-022.
ls_fieldcat-seltext_l = text-054.
* ls_fieldcat-reptext_ddic = 'Average duration'.
APPEND ls_fieldcat TO gd_fieldcat.

CLEAR ls_fieldcat.
ls_fieldcat-col_pos = 6.
ls_fieldcat-fieldname = 'AVFREQ'.
<b>ls_fieldcat-tabname = 'GT_REPORT'.</b> "why it is 
                         "IS IT NOT IT_REPORT
ls_fieldcat-key = c_false.
ls_fieldcat-seltext_s = text-053.
ls_fieldcat-seltext_m = text-023.
ls_fieldcat-seltext_l = text-055.
* ls_fieldcat-reptext_ddic = 'Average frequency'.
APPEND ls_fieldcat TO gd_fieldcat.

what about your Data in IT_REPORT , did you check in debug mode.

change your code according to Bold one.and see...

Regards

vijay

[Former Member]

vijay,

You are right.

The GT_REPORT should be IT_REPORT.

Thank you for your help.

Rene Vink

[Former Member]

Hi,

Please close the thread,and please mark the thread as solved and reward for helpful answers.

Regards

vijay

[Former Member]

vijay,

I'm sorry, I am new to this.

So now I checked "solved problem" and replied.

Regards,

Rene Vink

[Former Member]

just clear the fields after appending one row in to final interanal table.