SQL Server DB Image Shows Blank On Crystal Report

[DarkAngel]

Not sure if this is a SQL issue or CR issue. We are capturing signatures electronically via signature pad. They are stored in a text column. When I try to add the signature field to the report, it shows numbers (pages of numbers). I’ve tried converting from text datatype to varbinary(max)

cast(textptr(esigns.sign) as varbinary(max))

In Field Explorer the converted column appears to be an image, but when it is pulled into the report is blank. Any direction as to how to get the signature image to render in the report would be appreciated.

Thanks,
DA

Crystal Reports 2008 SP1
BusinessObjects Enterprise XI 3.1
MS SQL Server 2008

 

[hilfy]

Crystal will only read images that are stored in an image format - such as .jpg. Your text field is not an image and converting it to binary doesn't necessarily convert it to an image format.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[DarkAngel]

Thank you!