Displaying .jpg's in SSRS 2

[vbajock]

I have a number of jpeg files that are technician signatures,that I wish to display at the bottom of my report. They were originally stored in an Access database table as "Ole bound image" type, the table had two fields, the text showing the technician's name, and then the blob field where the image was stored. Using the Upsizing Wizard, I uploaded this Access table to SQL, which converted the field type to "image". I have attempted to display this signature in an image control, which I have set as a "data bound image" type "jpeg". A get an error "An error occurred during rendering - parameter not valid." I attempted to use this MS fix:

http://msdn.microsoft.com/en-us/library/ms156342(v=sql.100).aspx

same error.

I have the actual .jpg files. If someone knows of how to deal with this error, or how to load the jpgs into the database some fool-proof way, I would appreciate the advice, thanks!

 

[vbajock]

I ended up going thru Microsoft Support to solve this problem. It seems that if a jpg is originally saved to a Microsoft Access table OLE field and then that table is upsized to SQL Server, SRSS cannot render the image due to header information being added to the jpg by Access in the original save. The only solution is to upload the .jpgs directly from the file system to the SQL db via T-sql.

It also looks like SRSS 2008 cannot render any images saved to SQL 2000 image data type fields, they must be 2005 and up, varbinary(max).

 

[xlbo]

Thanks for taking the time to report back!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question