Technical Questions
 Crystal Reports Forum : Crystal Reports 9, X, XI, 2008, 2011 : Technical Questions
Message Icon Topic: export to excel Post Reply Post New Topic
Author Message
sfred
Newbie
Newbie


Joined: 22 Jun 2010
Location: United States
Online Status: Offline
Posts: 2
Quote sfred Replybullet Topic: export to excel
    Posted: 22 Jun 2010 at 8:16am
We have Crystal 10 for our Abra Sage product and when we were on Crystal 8.5 the export to excel handled the negative number sign and imported it into excel.  Now that we have upgrade to crystal 10 the negative number sign does not export into excel only the number.  How do we get the report to export to excel with the negative number sign along with the number
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Location: Indonesia
Online Status: Offline
Posts: 212
Quote Emir_W Replybullet Posted: 29 Jun 2010 at 2:37am
sorry if late to answer.
 
you can check the properties for the field.
- right click the field
- choose 'Format Field...'
- click 'Customize...'
 
in here make sure for:
- Negatives: 
- Reverse Sign for Display
 
and try to re-export it again.
 
 
hope it help.
 
Emir W
IP IP Logged
sfred
Newbie
Newbie


Joined: 22 Jun 2010
Location: United States
Online Status: Offline
Posts: 2
Quote sfred Replybullet Posted: 30 Jun 2010 at 4:48am
It was set up properly on the report and the report prints out fine with the negative number sign.  It is when we try to export it to excel it will not display the negative sign.  It was working in 8.5 but not crystal 10.
We can't seem to export the report as a csv either--it has blank information on the download file. No error messages just blank data
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Location: Indonesia
Online Status: Offline
Posts: 212
Quote Emir_W Replybullet Posted: 30 Jun 2010 at 8:16pm
i'm using CR XI and MS Office 2007 enterprise.
i'm able to export to excel normally and see my negative amount.
 
when you export it to excel there are some options there.
1. ms-excel 97-2000 (xls), and
2. ms-excel 97-2000 - data only (xls)
 
have you try both options?
 
if you select for option 2, there are additional options on next steps.
one of it is check-box for "export object formatting".
 
i've tried to check and un-check it, it work fine. i'm able to see the negative sign on my excel.
 
 
 
 
Emir W
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.063 seconds.

FREE ADVANCED
Crystal Reports Training!

Plus, free bonus PDF cheat sheet! Advanced Crystal Reports Training Give Me Advanced Training!