Image

Hi All,
I need to have an image in my table. I dragged an image and dropped it on a
textbox. I set the datasource as Database MIMEType = jpeg and the value as
the databse column (this column is the path to the jpg image).
When I preview the report the image field contains a red X.
I really, really need help getting this to work.
RoyIf I understand correctly, you have a filepath in your database field (i.e.
'c:\images\someimage.jpg' ). The simplest way to do this is to store your
image a binary field inside your database (in a varbinary type field). Then
the report will display the contents of that field automatically.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"RAF" <RAF@.discussions.microsoft.com> wrote in message
news:2BCEB9D0-F773-4A07-94C2-FE9207A3F979@.microsoft.com...
> Hi All,
> I need to have an image in my table. I dragged an image and dropped it on
> a
> textbox. I set the datasource as Database MIMEType = jpeg and the value as
> the databse column (this column is the path to the jpg image).
> When I preview the report the image field contains a red X.
> I really, really need help getting this to work.
> Roy|||I always understood that storing images was not a good idea. Is it not
possible to use a path to render the image?
Thanks,
Roy
"Alain Quesnel" wrote:
> If I understand correctly, you have a filepath in your database field (i.e.
> 'c:\images\someimage.jpg' ). The simplest way to do this is to store your
> image a binary field inside your database (in a varbinary type field). Then
> the report will display the contents of that field automatically.
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "RAF" <RAF@.discussions.microsoft.com> wrote in message
> news:2BCEB9D0-F773-4A07-94C2-FE9207A3F979@.microsoft.com...
> > Hi All,
> >
> > I need to have an image in my table. I dragged an image and dropped it on
> > a
> > textbox. I set the datasource as Database MIMEType = jpeg and the value as
> > the databse column (this column is the path to the jpg image).
> >
> > When I preview the report the image field contains a red X.
> >
> > I really, really need help getting this to work.
> >
> > Roy
>|||You can do that through an expression that returns the image file's path on
your webserver (i.e. ="http://www.yourdomain.com/images/" &
Fields!FILE_PATH.Value ). This will be the "Value" property of your report's
image component. The "Source" property will be external. You can leave the
MIMEType blank.
Why do you think storing images is not a good idea?
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"RAF" <RAF@.discussions.microsoft.com> wrote in message
news:DDBD584A-4F67-451A-8600-D84BAA08C133@.microsoft.com...
>I always understood that storing images was not a good idea. Is it not
> possible to use a path to render the image?
> Thanks,
> Roy
> "Alain Quesnel" wrote:
>> If I understand correctly, you have a filepath in your database field
>> (i.e.
>> 'c:\images\someimage.jpg' ). The simplest way to do this is to store your
>> image a binary field inside your database (in a varbinary type field).
>> Then
>> the report will display the contents of that field automatically.
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "RAF" <RAF@.discussions.microsoft.com> wrote in message
>> news:2BCEB9D0-F773-4A07-94C2-FE9207A3F979@.microsoft.com...
>> > Hi All,
>> >
>> > I need to have an image in my table. I dragged an image and dropped it
>> > on
>> > a
>> > textbox. I set the datasource as Database MIMEType = jpeg and the value
>> > as
>> > the databse column (this column is the path to the jpg image).
>> >
>> > When I preview the report the image field contains a red X.
>> >
>> > I really, really need help getting this to work.
>> >
>> > Roy
>>|||Make that ="http://www.yourdomain.com/images/" & Fields!FILE_NAME.Value ,
assuming you have the image's file name in a field called FILE_NAME.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:eQwg09fYIHA.4828@.TK2MSFTNGP05.phx.gbl...
> You can do that through an expression that returns the image file's path
> on your webserver (i.e. ="http://www.yourdomain.com/images/" &
> Fields!FILE_PATH.Value ). This will be the "Value" property of your
> report's image component. The "Source" property will be external. You can
> leave the MIMEType blank.
> Why do you think storing images is not a good idea?
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "RAF" <RAF@.discussions.microsoft.com> wrote in message
> news:DDBD584A-4F67-451A-8600-D84BAA08C133@.microsoft.com...
>>I always understood that storing images was not a good idea. Is it not
>> possible to use a path to render the image?
>> Thanks,
>> Roy
>> "Alain Quesnel" wrote:
>> If I understand correctly, you have a filepath in your database field
>> (i.e.
>> 'c:\images\someimage.jpg' ). The simplest way to do this is to store
>> your
>> image a binary field inside your database (in a varbinary type field).
>> Then
>> the report will display the contents of that field automatically.
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "RAF" <RAF@.discussions.microsoft.com> wrote in message
>> news:2BCEB9D0-F773-4A07-94C2-FE9207A3F979@.microsoft.com...
>> > Hi All,
>> >
>> > I need to have an image in my table. I dragged an image and dropped it
>> > on
>> > a
>> > textbox. I set the datasource as Database MIMEType = jpeg and the
>> > value as
>> > the databse column (this column is the path to the jpg image).
>> >
>> > When I preview the report the image field contains a red X.
>> >
>> > I really, really need help getting this to work.
>> >
>> > Roy
>>
>