Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Defining Field Type Problem Post Reply Post New Topic
Author Message
george
Newbie
Newbie


Joined: 26 Sep 2008
Location: United States
Online Status: Offline
Posts: 3
Quote george Replybullet Topic: Defining Field Type Problem
    Posted: 26 Sep 2008 at 7:45am
Hello All, first post here, but I've tried searching for a solution with no results. Hopefully this is something easy.
 
I'm using CR 10. I have an Excel data sheet that I download every day. The column titles are always the same, but the data changes. One column in th sheet is a "Description" field. Sometimes the first record in this column is short, sometimes it is long. On a given day, the first cell could be 100 characters long, and the second could be 2000 characters long. 
 
I use CR to format this data and export a PDF.
 
Problem
On the days that the first record in the "Description" column is short, CR defines the field as a (String), thus limiting the whole column to 255 characters. This truncates the other records in the field that may be >255.
 
If the first record in the field is >255, CR sets the field type as (Memo) and everything is great.
 
So, how can I permanently define this field as a Memo type?
CR Novice
IP IP Logged
george
Newbie
Newbie


Joined: 26 Sep 2008
Location: United States
Online Status: Offline
Posts: 3
Quote george Replybullet Posted: 06 Oct 2008 at 10:25am
Anyone have any ideas at all? Really getting desperate here. I'll try anything!
CR Novice
IP IP Logged
george
Newbie
Newbie


Joined: 26 Sep 2008
Location: United States
Online Status: Offline
Posts: 3
Quote george Replybullet Posted: 02 Dec 2008 at 6:50am
Well, it isn't a fix, but I did get a workaround. I created an excel macro that when run, inserts a new row 2 with the pre-amble of the constitution inserted into the cells that need to be "Memo" types. Then I have Crystal ignore that record.
CR Novice
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.