Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Missing delimiter from crystal report csv export Post Reply Post New Topic
Author Message
yzhong1
Newbie
Newbie


Joined: 27 Jun 2010
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote yzhong1 Replybullet Topic: Missing delimiter from crystal report csv export
     Posted: 27 Jun 2010 at 7:24pm

Hi,

We recently upgraded the CMS server to 2003 (everything else is the same). However one of our CSV report export is having issue: DateTime field and the blank fields are missing the Delimiter.  

The format of the export is set to 
Separator: ,
Delimiter: "
Same number formats as in report: ticked
Same date formats as in report: ticked
 
we are using crystal report enterprise 10.
 
I have changed the Delimiter to be something else and the change was reflected (but DateTime field and blank fields are still missing the delimiter). since the actual .RPT file hasnt been changed I assume the problem is in the windows registry. unfortnately I can't find any useful documents up to now.
 
Any advice is welcomed.
 
Regards
EY
IP IP Logged
crystalwiz
Newbie
Newbie
Avatar

Joined: 20 Dec 2012
Location: United States
Online Status: Offline
Posts: 1
Quote crystalwiz Replybullet Posted: 20 Dec 2012 at 3:46pm
I know this post is old but the same thing happend to me. It took a while to find a solution, so I decided to post it.
 
Crystal Enterprise 10 uses a DLL (u2fsepv.dll) to export Character-seperated values. After applying one of the CE Service Packs this DLL got updated. The new DLL no longer uses delimiters for blank (NULL) values.  Luckily the update process backed up the old files.  I replaced the DLL with a copy of the original one.  And it worked.
 
File: u2fsepv.dll
Description: Separated-Values Export Format DLL for Crystal Reports
Old DLL: 12/10/2003 (v10.0.0.54)
New DLL: 11/28/2005 (v10.0.5.62)
 
1) Renamed C:\Program Files\Common Files\Crystal Decisions\2.5\bin\u2fsepv.dll to u2fsepv.old
 
2) Copied the old DLL
 
From: C:\Program Files\Crystal Decisions\Enterprise 10\Patches\Crystal Enterprise 10.0 Service Pack 6\Backup of CE10WIN_EN_SP6...\
 
To: C:\Program Files\Common Files\Crystal Decisions\2.5\bin\
 
Good luck...


Edited by crystalwiz - 20 Dec 2012 at 3:47pm
IP IP Logged
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