sql server reporting services: Inserting images stored in a field to a report. -- sql server reporting services

You're in the

sql server reporting services

group:

Inserting images stored in a field to a report.

Rudi Groenewald
12/10/2004 10:51:28 AM

sql server reporting services: Hi all,

In my report, which is based on a table with 2 fields ex: imgID and Picture1
..... Picture 1 is data format "image" and I simply insert the photo from my
forms application into the field.

The problem is extracting this information. When adding this field to my
report, I would say insert picture, and specify in the wizard which runs
that this field comes from the database, I specify the field, but when I run
the report, it only shows The red X, as if the image is not found :(

Can someone please help me...

Regards

R

Re: Inserting images stored in a field to a report.

Robert Bruckner [MSFT]
12/10/2004 7:56:50 PM

Did you specify the mandatory MimeType property for the database bound
image?

Also, are you sure the image is not stored as OLE-Image in the database? You
may want to try this expression to remove some leading OLE-header bytes:
=System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!Pi
cture1.Value),105))

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Inserting images stored in a field to a report.

Rudi Groenewald
12/13/2004 8:58:31 AM

Hi Robert,

Thanks for the reply, but I read up about insering images embedded into a
database and everywhere I look it's a big no no... So what I am trying now
is to try and get a link from a shared folder on the server. Now inserting
that link, has it's troubles. I guess reporting services doesn't know how
to follow the link to the image?

in other words, my image1 field in my database is only text such as
\\zasldsql001\images\20040301.jpg

Anyone know how to overcome that?

Thanks
Rudi

[quoted text, click to view]

Re: Inserting images stored in a field to a report.

Elmer Miller
1/7/2005 11:55:53 AM

I also am having problems with images from a database field. I my case I am
using PNG images. The images render correctly when previewing the report in
VS, but when deployed the images show as a redx. If I export to PDF the
images show correctly. I am sure the images are not OLE-Images. Any ideas?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn