Print Page | Close Window

Export to Excell "Default Format"

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=790
Printed Date: 28 Mar 2024 at 5:32am


Topic: Export to Excell "Default Format"
Posted By: cesarp
Subject: Export to Excell "Default Format"
Date 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



Replies:
Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Posted By: kjbsdl
Date 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


Posted By: kjbsdl
Date Posted: 05 Jul 2007 at 3:21am
If it's a date field the formual just needs to totext() it.

-------------
Regards
Simon



Print Page | Close Window