Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Export to Excell "Default Format" Post Reply Post New Topic
Author Message
cesarp
Newbie
Newbie
Avatar

Joined: 05 Jun 2007
Location: United States
Online Status: Offline
Posts: 1
Quote cesarp Replybullet Topic: Export to Excell "Default Format"
    Posted: 05 Jun 2007 at 4:16pm
How can I modify the EXCEL format defaults that Crystal Reports uses?  My Excel outputs show "######" insteaf of true zeros.
 
I use CR 8.5.0.217 under Windows 2000.  Using CR, I specify a non-custom format ("-1,234  signed integer) on every numeric field of a multi-column report.  Each column has 24 rows and any NULL numbers are initialized to true zero integers.
  
When I load CR and export my report to Excel, the spreadsheet shows all zeroes as true "0" as it should.  HOWEVER, when I link the report call via VB (VB 6.0), the CR displays just fine (all "0"s OK) but the exported Excel file defaults all "0" to "######" fields.  
C-Zar
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3275
Quote hilfy Replybullet Posted: 05 Jun 2007 at 7:27pm
In Excel, if you widen the column that displays '####', you'll be able to see all of the correct data.  There is no way to change this from Crystal.
 
-Dell
DecisionFirst Technologies
7-Time SAP BusinessObjects Service Partner of the Year.
www.decisionfirst.com
IP IP Logged
kjbsdl
Newbie
Newbie


Joined: 04 Jul 2007
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote kjbsdl Replybullet Posted: 04 Jul 2007 at 7:34am
say the field is 'x' (and it's a number)
in crystal create a function that says
if x = 0 then ' ' else totext(x)
replace the field by the function
Regards
Simon
IP IP Logged
kjbsdl
Newbie
Newbie


Joined: 04 Jul 2007
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote kjbsdl Replybullet Posted: 05 Jul 2007 at 3:21am
If it's a date field the formual just needs to totext() it.
Regards
Simon
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.031 seconds.

FREE ADVANCED
Crystal Reports Training!

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