Report Email format

[Former Member]

All,

I have a situation where when i pull up a report, it works fine and show the proper ALV display with my selected layout format but when select to also email the layout i select, it shuffle up the colums.

For example:

When i run the report, it display the correct colums like

A B C D E

but i have have it also email me the same report it shifts the columns and and the report i get in the email looks like

A D C B E

I have checked that its picking the correct layout while debugging it but not sure what else is going on.

Any help?

[Former Member]

I think it ignores you layout changes when you do things like send e-mail or download to Excel.

When you download to Excel it give a message that says this.

Rob

[Former Member]

Thanks Rob.

Is there any way i can make the report use the same format for email as it uses while a display it.

also when i try to export the display to excel it DOES show the correct format, just screwing up in the email.

Thanks

[sjeevan]

What program are referring to? is it your Z program or a standard program? Because some standard programs have different layout for printing (which includes email) example MB26.

[Former Member]

This is a Z program. Is there any code i could use to make sure the emailed format of the report matches the display format?

thanks

[Former Member]

Hi,

What is the order of the fields in the internal table that you have used for displaying the data in the ALV?

if it is ADBCE, then build another internal table with the fields in the required order and use for emailing.