INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Report Development

Work Around to use Memo Fields in Formulas by MsPepperMintUSA
Posted: 30 Jul 01

This information is also found at Thread149-106985.

It is tedious and time-consuming, but a viable solution until Seagate supports the memo field.

To use this work around: you must have DML access (must be able to alter tables or create views) to your database.

You can read the full explanation of this solution at http://support.crystaldecisions.net ; In Knowledge base search for article ID C2007285 or try this link:
http://support.crystaldecisions.com/library/kbase/articles/c2007285.asp

The short explanation:
Background info:
When importing data into Crystal Reports (1) varchar and (2) field lengths greater than 254 are converted to memo fields.

The workaround:
Note: You can create a view or add the fields to the actual data base table structure.
1. In the database environment - (1) parse out the field into smaller parts(you can use substring), (2) use char to define the field (3) assign part to a "new" field in database.
2. Import the smaller "new" fields into Crystal Report.
3. In the crystal report environment -  (1) concatenate and the "new" smaller fields into one large string which resembles the original field (2) trim empty spaces if necessary (3) use Crystal Report formulas as you like.

Additional suggestions: You can hide the text of the "new" field, which are being used in the formulas and display the original memo field on the actual report.




Back to Business Objects: Crystal Reports 4 Other topics FAQ Index
Back to Business Objects: Crystal Reports 4 Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close