Hi does anyone know why the memo data type field I'm reporting on from an Access database can be added to my report ok but is invisible when I go to include it in a formula or use it in a selection - ie I can see it on the report but I can't see it in the list of fields to make a formula or selection?
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!
Info7 and Access 2002 memo type field
- Thread starter Kevinski
- Start date
This is a "feature" of Crystal Reports. Memo fields cannot be used in formulas or in the record selection criteria except in CR9. A workaround is to use SQL Expressions, but these aren't available if you're using MS Access as the DB.
You do have a few options within MS Access: Change the field type, truncate the field, or break the field into multiple fields.
You do have a few options within MS Access: Change the field type, truncate the field, or break the field into multiple fields.
It is more that a "feature," it is a limitation. Seagate Crystal Reports version 8.0 and below, with which I am familiar, are not able to manipulate any field longer than 254 characters, nor are they able to produce a formula result longer that 254 characters.
synapsevampire
Programmer
The only option is to parse the field into 254 char fields using SQL Expressions.
-k kai@informeddatadecisions.com
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question