Skip to Content
0
Apr 01, 2009 at 06:40 PM

VARBINARY Fields Not Working in Crystal

181 Views

Hi,

I have a table in SQL Server 2005 that contains a VARBINARY (MAX) field. The record is populated and contains pictures.

In Crystal this field shows as a String (255) and obviously doesn't show my image.

If I change the field to Image then the picture is fine.

My dilema is MS is recommending VARBINARY as the proper datatype since it will no longer be supporting BLOBs and image types down the road.

Aside from leaving it as an Image type, is there a way to get XI to read this field? Has anyone tried in 2008?

Thanks,

Brian