all groups > sql server reporting services > april 2005 >
You're in the

sql server reporting services

group:

External Image not displaying


External Image not displaying pmud
4/28/2005 3:04:09 PM
sql server reporting services:
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?
--
Re: External Image not displaying Robert Bruckner [MSFT]
4/28/2005 7:42:19 PM
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-10d79ddaa510/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.


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


[quoted text, click to view]

Re: External Image not displaying pmud
4/29/2005 3:00:07 PM
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?

--
pmud


[quoted text, click to view]
Re: External Image not displaying Robert Bruckner [MSFT]
4/29/2005 9:46:23 PM
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")


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



[quoted text, click to view]

AddThis Social Bookmark Button