topic Re: ALV printing in Application Development and Automation Discussions

ALV printing

Former Member — Tue, 13 Jun 2006 08:18:45 GMT

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

Re: ALV printing

Former Member — Tue, 13 Jun 2006 08:26:12 GMT

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

Re: ALV printing

Former Member — Tue, 13 Jun 2006 08:26:20 GMT

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

Re: ALV printing

Former Member — Tue, 13 Jun 2006 08:38:49 GMT

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

Re: ALV printing

Former Member — Tue, 13 Jun 2006 08:56:38 GMT

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

Re: ALV printing

Former Member — Tue, 13 Jun 2006 09:46:27 GMT

vijay,

You are right.

The GT_REPORT should be IT_REPORT.

Thank you for your help.

Rene Vink

Re: ALV printing

Former Member — Tue, 13 Jun 2006 09:56:09 GMT

Hi,

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

Regards

vijay

Re: ALV printing

Former Member — Tue, 13 Jun 2006 10:13:00 GMT

vijay,

I'm sorry, I am new to this.

So now I checked "solved problem" and replied.

Regards,

Rene Vink