Showing posts with label displaying. Show all posts
Showing posts with label displaying. Show all posts

Monday, March 26, 2012

external image not rendering when generated from aspx page

I'm having problems displaying images generated by aspx pages from a report. It works fine if I point the external value to a static image on the web. I can paste the url to the page into IE and it generates the image with no issues. What am I doing wrong? I used a textbox to verify that the correct url is being generated (= Parameters!MYPROJECT_URL.Value & Parameters!MYPROJECT_NO.Value).

Are there any issues with generating external images with reporting services?

I have installed SP1 for MS 2005...shouldn't I see some sort of visual confirmation in Management studio when I click the Help Menu->about? saying the version is MS SQL Server 2005? how do I verify that the upgrade was successful?

You can check if the upgrade is successful from the error logs, they contain the build number on the top.

|||Check if ASPX pase generate the image have anonymouse accesssql

External Image not displaying

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?
--
pmudDid 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.
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:ACFAA192-6175-4AC4-8CA5-26641626CAFB@.microsoft.com...
> 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?
> --
> pmud|||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
"Robert Bruckner [MSFT]" wrote:
> 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.
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:ACFAA192-6175-4AC4-8CA5-26641626CAFB@.microsoft.com...
> > 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?
> > --
> > pmud
>
>|||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.
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:83471FE2-3457-4C66-85A0-8F9CE798901C@.microsoft.com...
> 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
>
> "Robert Bruckner [MSFT]" wrote:
>> 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.
>>
>> "pmud" <pmud@.discussions.microsoft.com> wrote in message
>> news:ACFAA192-6175-4AC4-8CA5-26641626CAFB@.microsoft.com...
>> > 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?
>> > --
>> > pmud
>>