Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Time format + Export to Excel + Problem Post Reply Post New Topic
Author Message
hari2167
Newbie
Newbie
Avatar

Joined: 30 Jul 2009
Location: India
Online Status: Offline
Posts: 1
Quote hari2167 Replybullet Topic: Time format + Export to Excel + Problem
    Posted: 30 Jul 2009 at 2:15am
Hi Friends,

I am facing a problem with excel formatting with HH:MM:SS Format.

We are displaying this format as string in report.But When i export to excel i am not able to sum of that data.Everything displaying correctly in report and excel.

Please help me.


Thanks in Advance

Hari Krishna Routhu
Mahathi Software,Vizag
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 30 Jul 2009 at 1:17pm

Crystal exports data to Excel using the data type of the data in Crystal.  Since you're formatting the data as a string in Crystal, it is exported as a string in Excel.  So, you can't sum it because it's a string.

How is your data stored?  If it's in date or time format, you can put it on the report, right-click on the field and select "Format Field" there will be a tab for formatting the time or the datetime and you can do custom formatting. 
 
If you have to convert it from another format, I would convert it to a datetime and then format the formula to not show the date and show the time in the format you need.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.033 seconds.