topic Re: Report Email format in Application Development and Automation Discussions

Report Email format

Former Member — Mon, 19 Sep 2011 21:00:57 GMT

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?

Re: Report Email format

Former Member — Mon, 19 Sep 2011 21:27:36 GMT

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

Re: Report Email format

Former Member — Mon, 19 Sep 2011 22:04:08 GMT

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

Re: Report Email format

sjeevan — Mon, 19 Sep 2011 23:53:36 GMT

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.

Re: Report Email format

Former Member — Tue, 20 Sep 2011 15:29:56 GMT

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

Re: Report Email format

Former Member — Tue, 20 Sep 2011 18:29:52 GMT

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.