Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

ALV report export error

Go to solution
Former Member

‎2010 Jun 28 11:17 AM

0 Likes
546

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.

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2010 Jun 28 12:32 PM

0 Likes
499

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

3 REPLIES 3
Read only

Go to solution
Former Member

‎2010 Jun 28 12:32 PM

0 Likes
500

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

Read only

Go to solution
Former Member
In response to Former Member

‎2010 Jun 29 8:39 AM

0 Likes
499

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.

Read only

Go to solution
OttoGold
Active Contributor

‎2010 Jun 29 10:36 AM

0 Likes
499

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