Visual Basic Crystal Reports - Crystal 11 and SQL Image fields

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Crystal 11 and SQL Image fields

Sergio

2008-02-28, 8:33 pm

Hello,

Does anyone have a formula to convert text stored in a SQL 2000 field of
data type IMAGE (len 16) in a Crystal report?

My application stores users comments in this field but the problem is that
we need to convert it before it can be displayed as text. We use the
following formula in SQL sps to translate:

CONVERT(varchar(8000), CONVERT(binary(8000), my_table_field_name))

The problem I have is that I can't convert this into a SP or table view so
I'd appreciate if someone can share a formula in Crystal that I can use.

I only need a few characters stored in the field not the entire content.

Thanks for your help!

Sergio

ps. I tried to post this message on a diff pc but it crashed so sorry if I
posted twice.

Sponsored Links