Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: can you change the field type from string to memo? Post Reply Post New Topic
Author Message
john_simpson
Newbie
Newbie


Joined: 07 Feb 2008
Online Status: Offline
Posts: 1
Quote john_simpson Replybullet Topic: can you change the field type from string to memo?
    Posted: 07 Feb 2008 at 2:44pm
i'm a brand new user of crystal.  i created a report that pulls data from 11 columns in an excel spreadsheet.  some of the fields imported into crystal as memo fields.  this is good.  others imported as a string field.  this is bad.  there are cells in those columns that have more than 255 characters, so they are getting cut off.

is there way to change a field type after it has been created?

john

IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 08 Feb 2008 at 4:28am
John,
 
Can you email me the spreadsheet ,also let me know which version of crystal u r using....
 
Thanks
Rahul
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 08 Feb 2008 at 7:42am
Hi
Once the fields are displayed in the report,select the field or fields where the text is truncated,
 
Right Click --- Format Field ---- Common Tab--- Check  Can Grow Checkbox
 
Cheers
Rahul
IP IP Logged
iasmini.gomes
Newbie
Newbie
Avatar

Joined: 05 Aug 2015
Location: Brazil
Online Status: Offline
Posts: 2
Quote iasmini.gomes Replybullet Posted: 14 Aug 2015 at 1:13am
I have just resolved the same problem and discovered that a text formula value in the report was being truncated at 255 characters, due to an unmapped data field, revealed by the verify database option.

Once I had dealt with the unmapped data field, the truncated field immediately expanded its output beyond 255 characters.

I was using ODBC text driver and Crystal Reports XI R2.
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.