Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Binary Field Issue Post Reply Post New Topic
Author Message
cheryla
Groupie
Groupie


Joined: 23 Oct 2013
Online Status: Offline
Posts: 51
Quote cheryla Replybullet Topic: Binary Field Issue
    Posted: 11 Mar 2014 at 8:36am
We just converted our database this past weekend. In our current crystal reports we used a chars field that was raw but is now binary. The field is giving us only the first 2 letters of the field. So it looks like it is converting but stopping after the 2 letter. I've checked to see if the is a left,right justify or anything like that and there isn't. There is no formats on this field in any of the reports. Any ideas on how to get the rest of the data? We have at least 3 very critical reports that need this fix ASAP.
 
Thanks in advance for any help you can provide. I will keep searching in the meantime as we need to get this fixed.
 
Thanks!!!
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 12 Mar 2014 at 5:25am
Did you do a Verify Database (Database-Verify Database) after the change was done to the database.  

I am not sure what the difference between a chars field that is raw vs. binary.
IP IP Logged
cheryla
Groupie
Groupie


Joined: 23 Oct 2013
Online Status: Offline
Posts: 51
Quote cheryla Replybullet Posted: 12 Mar 2014 at 5:40am
Actually we have figured out that we have a field specifically designed for us that was changed with the upgrade. Our provider has given us a script to fix this issue as it didn't really relate to Crystal necessarily. The script has us re-mapping the field to something that will actually read the new field in Crystal.
 
Thank you for your help and response. It really is appreciated. I love this site everyone is always willing to help!! :)
 
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.016 seconds.