08-25-2010 6:08 AM
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
08-25-2010 6:17 AM
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
08-25-2010 6:17 AM
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
08-25-2010 6:27 AM
Hi,
After displaying the report in SP02 click on RAW in the toolbar.
Regards,
Srini.
08-25-2010 6:58 AM
My problem is not solved yet. please how tell me how to change line size...
08-25-2010 7:24 AM
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
08-25-2010 8:30 AM
- 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
08-25-2010 10:10 AM
yes you need to increase the line size and then use appropriate parameters while saving th background job
08-26-2010 3:45 AM