BLOB

[CPK6104]

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.

 

[fisheromacse]

you could try creating a new formula similar to below:

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

 

[CPK6104]

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

 

[hilfy]

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?

-Dell



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

 

[CPK6104]

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.