Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

ALV printing

Go to solution
Former Member

‎2006 Jun 13 9:18 AM

0 Likes
879

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

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2006 Jun 13 9:26 AM

0 Likes
851

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

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

Reply
7 REPLIES 7
Read only

Go to solution
Former Member

‎2006 Jun 13 9:26 AM

0 Likes
852

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

Read only

Go to solution
Former Member
In response to Former Member

‎2006 Jun 13 9:38 AM

0 Likes
851

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

Read only

Go to solution
Former Member
In response to Former Member

‎2006 Jun 13 9:56 AM

0 Likes
851

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

Read only

Go to solution
Former Member
In response to Former Member

‎2006 Jun 13 10:46 AM

0 Likes
851

vijay,

You are right.

The GT_REPORT should be IT_REPORT.

Thank you for your help.

Rene Vink

Read only

Go to solution
Former Member
In response to Former Member

‎2006 Jun 13 10:56 AM

0 Likes
851

Hi,

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

Regards

vijay

Read only

Go to solution
Former Member
In response to Former Member

‎2006 Jun 13 11:13 AM

0 Likes
851

vijay,

I'm sorry, I am new to this.

So now I checked "solved problem" and replied.

Regards,

Rene Vink

Read only

Go to solution
Former Member

‎2006 Jun 13 9:26 AM

0 Likes
851

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