Application Development 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: 

ALV report export error

Go to solution
Former Member

‎06-28-2010 11:17 AM

0 Kudos

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

Go to solution
former_member536879
Active Contributor

‎06-28-2010 12:32 PM

0 Kudos

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

Go to solution
former_member536879
Active Contributor

‎06-28-2010 12:32 PM

0 Kudos

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

Go to solution
Former Member
In response to former_member536879

‎06-29-2010 8:39 AM

0 Kudos

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.

Go to solution
OttoGold
Active Contributor

‎06-29-2010 10:36 AM

0 Kudos

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