Report -to excel

[Former Member]

Hi,

After taking dump of report to excel file fields are getting jumbled/misaligned.

What could be reason for this

[Former Member]

Hi ,

If you are taking about a zreport then it is because of the write statements in the report and the way the alv program is coded.

So we can change the program as per your requirement ie the way we need the data in excel.

If you are using standard tcode then we need to allign the excel manually as our friend said.

Regards,

Vvieks

[Former Member]

Hi,

some time it happenes due to the form strucure and program.

any way you can re align it in excel. use funstion like Text to column etc.

Thanks,

Raja

[Former Member]

Hi,

thx for replyin.

No user dosen't want to do any thing in excel.

While dump is taken on to excel some fields are geting jumbled.

like:

proo

100

200

300

400

500

[Former Member]

Hi,

OK, Try this, When dumping u are saving as local fille and saving as excerl format right?

Now when doing dump save as spreadsheet, it will open spreadsheet there and then save that sheet by clicking on save as tab in spreadsheet. Try this and come back if problem still persist.

Thanks,

Raja

[Former Member]

HI All,

Thx for replyin,

It's a z-report -from the menu bar i'm selecting -list -save-spread sheet-the i'l given the path & file name.

when i open the excel file field will be misaligned - but in the report it's coming fine.

wether layout in program need to be changed or any other way to handle this.

pl suggest.

[Former Member]

Hi ,

As I said earlier we need to modify the program accordingly .

But in the report output we see that report is displaying in one way and when we download it we found it in another way,

This is due to the programming. Pls ask the Abaper to change the coding... ie at the time of populating thre field catelog in ALV. If it is normal report then ask then to change the posititons in the write statements.

The place to change the code if it is ALV report is ..

DATA: l_fieldcat TYPE slis_fieldcat_alv.

DATA : n(3) TYPE n.

CLEAR l_fieldcat.

REFRESH lt_fieldcat.

n = n + 1.

MOVE n TO l_fieldcat-col_pos.

l_fieldcat-fieldname = 'MATNR'.

l_fieldcat-ref_tabname = 'MAST'.

l_fieldcat-ref_fieldname = 'MATNR'.

l_fieldcat-key = 'X'.

APPEND l_fieldcat TO lt_fieldcat.

CLEAR l_fieldcat.

n = n + 1.

MOVE n TO l_fieldcat-col_pos.

• l_fieldcat-tabname = 'ITAB1'.

l_fieldcat-fieldname = 'STUFE'.

l_fieldcat-ref_tabname = 'STBP'.

l_fieldcat-seltext_s = 'Level'.

APPEND l_fieldcat TO lt_fieldcat.

This is just a sample code where we need to change the program.

So pls ask the Abaper to change accordingly.

If you still have any queries on this pls let me know..

Happy to help you

Regards,

Vvieks

[Former Member]

Hi,

Seems like the layout has to be check. Take the help of ABAPer.

Thanks,.

Raja