Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is it possibe to change field type

Status
Not open for further replies.

sdzlkds

Technical User
Oct 20, 2005
41
GB
I'm using Crystal XI. Is it possible to change the Field Type from string to memo on a field in an existing report?

Thanks
 
You would change it in the database then use "Verify Database" in your report to update the field type in Crystal.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Thanks. the issue I'm having is I'm reporting off an Excel data source, where the field may have more or less than 255 characters. If the field is more than 255 Crystal makes it memo, then if the data changes to less than 255 Crystal makes it string. The data changes back to more that 255 and Crystal tells you data has changed and pulls up mapping wizzard - and you have to remove the field and add it again. So, can't automate the report using Enterprise.

To cut a long story short I wondered if there was a way to make Crystal always keep a particular field as a particular type ie memo. Sounds like there isn't.
 
Hi,
Try a formula that checks the datatype and handles each type, something like:

If Length({Field}) > 255 then
ToText({Field})
else
{Field}



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top