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!
  • Students Click Here

*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.

Students Click Here



I've never run across a field data type = Picture. Apparently the field is a BLOB field and supposedly contains data that I need for my report. Is it possible to change the data type from picture to string? Any advice is appreciated. Thank you.


you could try creating a new formula similar to below:

IF isnull({Yourtable.YourField}) or TRIM({Yourtable.YourField})=""
then ""
else totext({Yourtable.YourField})


Thanks for the response. I tried your suggestion and recived the error "a blob field can not be used in a formula".


How are you getting the data for your report?  Are you just linking tables together?  Using a command or stored proc?

If you're linking tables together, you should be able to create a "SQL Expression" (look for this in the field explorer) that will convert the blob to a string as part of the query, before the data gets to Crystal.  SQL Expressions can be any SQL that you might use to define a field in a select statement in a query.  The syntax will be different for different databases.

What type of database are you connecting to and what version of Crystal are you using?



A computer only does what you actually told it to do - not what you thought you told it to do.


I'm linking two oracle tables using CR 2008. Thanks for the suggestion. I'll look at using a SQL expression to convert the field to a string.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

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