Application Development 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
Showing results for 
Search instead for 
Did you mean: 

Column not showing in SP02

nayanlad
Participant
0 Kudos

Dear all,

I have one report which is execute very slow in Server.

So we had planned to run this report in background schedule. Report run in background successfully but not showing all the columns of the report in SP02 transaction code.

Can anyone please tell me how to see all columns of the report. there are 25 columns in report it's showing only 19 columns.

Please help me.

Regards,

nayan lad

1 ACCEPTED SOLUTION

arul_murugan
Active Participant
0 Kudos

Hi,

I think if you are increasing the line size of the report, you will be able to see all the columns

REPORT ztest LINE-SIZE 232.

Thanks

Arul

7 REPLIES 7

arul_murugan
Active Participant
0 Kudos

Hi,

I think if you are increasing the line size of the report, you will be able to see all the columns

REPORT ztest LINE-SIZE 232.

Thanks

Arul

Former Member
0 Kudos

Hi,

After displaying the report in SP02 click on RAW in the toolbar.

Regards,

Srini.

nayanlad
Participant
0 Kudos

My problem is not solved yet. please how tell me how to change line size...

0 Kudos

Hi,

In your program , the first line will be starting as REPORT. you can change that line to increase the line size. if the line size is not declared in the fiirst line , add the syntax as LINE-SIZE 232 with your REPORT syntax.

Thanks

Arul

raymond_giuseppi
Active Contributor
0 Kudos

- Increase size in the REPORT statement, e.g. LINE-SIZE 255

- In the job step definition -> print parameters use a format like X_65_255 wide enough (or use a call to GET/SET PARAMETERS in the report) (there is also a X_65_1024/4 format in [Note 213382 - SAPWIN/SWIN: Lists with more than 255 columns|https://service.sap.com/sap/support/notes/213382] which print 512 columns on 2 pages or 1,024 columns on 4 pages)

Regards,

Raymond

Former Member
0 Kudos

yes you need to increase the line size and then use appropriate parameters while saving th background job

nayanlad
Participant
0 Kudos

Thanking all of you for helping.