External Image not displaying

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pmud - 28 Apr 2005 23:04 GMT

Hi,

I installed SP1 and have specified an image as External & am using
"https"//abc.com/Images"+Fields!LOGO.Value as the exprseeion for getting the
image but the iamge is not displaying. The image in the database field LOGO
is stored simply as xyz.gif . How acn i display such an image? Am i missing
something here?

Signature

pmud

Reply to this Message

Robert Bruckner [MSFT] - 29 Apr 2005 03:42 GMT

Did you read the following section for the SP1 readme about external images:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa51
0/SP1Readme_EN.htm#_external_images

If the UnattendedExecutionAccount is not configured, the report server will
try to access the image with no credentials (anonymous). Also, did you check
if the expression really generates a valid image path? If you run the report
in report designer preview (with SP1 installed), you should see a processing
warning message with details if the web server responds e.g. with a 401
error on the image request.

Signature

Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi,
>
[quoted text clipped - 6 lines]
> missing
> something here?

Reply to this Message

pmud - 29 Apr 2005 23:00 GMT

Hi Robert,

I validated that the image can be accessed through IE. Also, my report uses
a shared data source which uses credentials. So i dont think there will be a
need to configure an account for unattended execution. what do you think?
Also,when i use the expression ="https://abc.com/Images/"&FieldsLOGO.Value,
I cant see the image when the report is previewed. actually whn i create the
expression & try to insert &Fields!LOGO.VAlue , when i expand the Fields
section, it says report item not linked to dataset. So I tried to use the
expression ="https://triotekdealer.com/Images/"&(Fields!LOGO_IMAGEPATH.Value,
"DataSet1")

But i got the error : The value expression for the image ‘image1’ contains
an error: [BC30198] ')' expected.

How can I link the dataset to the image so that it can use the fields in the
dataset, if thats's what the problem is?

Signature

pmud

> Did you read the following section for the SP1 readme about external images:
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa51
0/SP1Readme_EN.htm#_external_images
[quoted text clipped - 16 lines]
> > missing
> > something here?

Reply to this Message

Robert Bruckner [MSFT] - 30 Apr 2005 05:46 GMT

You could move the image inside a data region (e.g. a list). Then you will
get one image per row in the dataset. In that case the expression has to
look like:
="https://triotekdealer.com/Images/" & Fields!LOGO_IMAGEPATH.Value

Otherwise, you have to use an aggregate function (because the dataset has
multiple rows):
="https://triotekdealer.com/Images/" & First(Fields!LOGO_IMAGEPATH.Value,
"DataSet1")

--

Signature

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

> Hi Robert,
>
[quoted text clipped - 46 lines]
>> > missing
>> > something here?

Reply to this Message