topic Re: ALV report export error in Application Development and Automation Discussions

ALV report export error

Former Member — Mon, 28 Jun 2010 10:17:09 GMT

When I am exporting the data from an ALV report to excel, date 17:07:2009 is displaying as "0.736446759" and 21:07:2009 as "0.903113426" in excel file.

If anybody has faced such problem, please help.

Re: ALV report export error

Former Member — Mon, 28 Jun 2010 11:32:49 GMT

Hi,

Just want to know the data type of these 2 fields in the internal table.

If it is not char convert into char type field and then download.

With Regards,

Sumodh.P

Re: ALV report export error

Former Member — Tue, 29 Jun 2010 07:39:35 GMT

Char type is same for all the dates.But in report say out of 100 dates only 2 or 3 dates, it is showing wrong.Also if instead of excel if I export the data in some other format, Same dates are apperaing correct.

Re: ALV report export error

OttoGold — Tue, 29 Jun 2010 09:36:45 GMT

Read: Happy reporting with Excel III: There and back and especially two previous parts (about "printing" Excels/ output)

/people/otto.gold/blog/2010/06/23/happy-reporting-with-excel-iii-there-and-back

Otto