Print Page | Close Window

can you change the field type from string to memo?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2264
Printed Date: 28 Apr 2024 at 6:54pm


Topic: can you change the field type from string to memo?
Posted By: john_simpson
Subject: can you change the field type from string to memo?
Date 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


Replies:
Posted By: rahulwalawalkar
Date 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....
mailto:rahulwalawalkar@gmail.com - rahulwalawalkar@gmail.com
 
Thanks
Rahul

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

Posted By: iasmini.gomes
Date 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.


Print Page | Close Window