Crystal Reports Having problem exporting crosstab to excel

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Having problem exporting crosstab to excel

Author	Message
otto Groupie Joined: 17 Mar 2014 Online Status: Offline Posts: 53	Topic: Having problem exporting crosstab to excel Posted: 28 Apr 2014 at 4:26am
	I have a crosstab that has a time field inside, it shows well formatted on crystal, but when I export it to excel, it shows 12:00 am in all the fields. Does someone know how to solve this? I am using CR 14.1.1.1036 and excel 2013 Edited by otto - 28 Apr 2014 at 5:48am
	IP Logged


Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 28 Apr 2014 at 11:39pm
	Hi Try to convert your time to string using Display string option like : Totext(time(currentfieldvalue)) and exprot to excel and see how it is exporting. Also check the excel cell properties for time format. -Sastry
	Thanks, Sastry
	IP Logged

otto Groupie Joined: 17 Mar 2014 Online Status: Offline Posts: 53	Posted: 29 Apr 2014 at 3:51am
	That's works, but my report is sorted by that field and now instead of start at 5:00 am it is doing it at 1:00 pm. Do you know any solution for that? Thank you
	IP Logged

Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 29 Apr 2014 at 4:18am
	Hi Can you create a formula with only time stamp like : Time {YourdatabaseTmeField} Now go in cross tab expert--click on the field you ant to sort.. go in Group Options-- Common Tab.. click on use formula to group sort order and select formula editor and choose the above formula {@Time] Now check your cross tab sort order -Sastry
	Thanks, Sastry
	IP Logged

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