when running the report in background some columns are being inserted in new row from alv out put

[prashant_kumar30]

Hi Experts,

i have created one ALV report (reuse_alv_grid_display)in which there are total 70 columns approx.Out of which 2 colums are fixed and rest are dynamic it can be 65 to 68 based on last posted period.Now my question is when i am running the report in background and saw the spool.

1. some of the columns are being inserted in new row instead of in same row.

2. for the first 2 columns which are fixed (header are coming but value is not displaying)

This was issue with foreground also ,then i applied custom download option which is working now.

But how to fix this for background. ?

Appriciate your help.

Thanks

Prashant kumar

[Sandra_Rossi]

When you submit a background job, you have the option to enter "print parameters", in which there is a "page format" which indicates the number of available columns. You may create your own page format, up to 1023 columns.

[prashant_kumar30]

Hi Sandra,

yes you are correct.That i have selected for maximum columns but still it comes.

Thanks

Prashant

[raymond_giuseppi]

Use the wider (1023 columns/characters) format available in print options, also adjust the layout to optimize columns width, if that's not enough then you cannot generate such spool, and should consider another type of output (e.g. output a mHTML or xml file on server or a solution similar to your 'custom download option')

Regards,
Raymond

[prashant_kumar30]

Hi Raymond,

Thanks for reply.But i am able to find out the issue.

actually when i was preparing fieldcatalouge then for the two fixed columns i was passing different table name but for remaining 65 column i was preparing run time table which was different.now i made both table name same <gt_table>.Now its working fine.

i am closing this issue.

Thanks

Prashant