External Images (URL Based) don't display on deployed reports

Hello,
I have a RS 2005 report which uses a report parameter as the source for an
image external image. When in report designer, everything works fine. When
deployed, the image shows as red x.
I am not using unattended credentials since the image is accessible without
credentials. I even tried images from microsoft.com and cnn.com
Any help would be appreciated.
-PedroHi Pedro,
Probabily the image directory is not proper. Just right click on the Red x
or view source to see where the image points to and check the directory for
your image. Better to include it in your project so that the link is not lost.
Amarnath
"Pedro" wrote:
> Hello,
> I have a RS 2005 report which uses a report parameter as the source for an
> image external image. When in report designer, everything works fine. When
> deployed, the image shows as red x.
> I am not using unattended credentials since the image is accessible without
> credentials. I even tried images from microsoft.com and cnn.com
> Any help would be appreciated.
> -Pedro
>
>

External Images - 404 Not Found and the red X image

Hello,
I have a report that is attempting to go out and grab images for certain
items off of a website. The URL is basically a guess and when it is
incorrect (404 File Not Found) RS returns an image of a red X. Is there an
expression I can use to hide the visibilty of the red X if one should appear?
I havn't been able to figure out how to do this.
Thanks!
Paulchecking the binary stream return value and if there is nothing then hide
the column displaying the image
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:616E1484-1B3D-4393-8974-F7C616A6051A@.microsoft.com...
> Hello,
> I have a report that is attempting to go out and grab images for certain
> items off of a website. The URL is basically a guess and when it is
> incorrect (404 File Not Found) RS returns an image of a red X. Is there
> an
> expression I can use to hide the visibilty of the red X if one should
> appear?
> I havn't been able to figure out how to do this.
> Thanks!
> Paul|||Ok, thanks for the post. How exactly do I go about checking the binary
stream return value in RS?
"Vaibhav" wrote:
> checking the binary stream return value and if there is nothing then hide
> the column displaying the image
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:616E1484-1B3D-4393-8974-F7C616A6051A@.microsoft.com...
> > Hello,
> >
> > I have a report that is attempting to go out and grab images for certain
> > items off of a website. The URL is basically a guess and when it is
> > incorrect (404 File Not Found) RS returns an image of a red X. Is there
> > an
> > expression I can use to hide the visibilty of the red X if one should
> > appear?
> > I havn't been able to figure out how to do this.
> >
> > Thanks!
> > Paul
>
>

External Image URL doesn't work !

Hi
I have downloaded SP1, and am trying to display an image by URL.
I have followed the steps described in the SP1Readme. However i am still unable to view my image in the "Preview" mode in report designer and also through report server. When i right click to view the source of my webpage, the image src is empty like this <img class="R1" src="http://pics.10026.com/?src=">.
Any idea, what can be wrong? This is what i did:
1) set in designer Source=External
2) set Value=http://localhost/Webmodule/test.img
3) image immediately showed up
4) Go to "Preview" mode in designer, image shows a red cross
5) ran rsconfig -e -m mycomputer -s mycomputer -u user1 -p password
6) deploy .rdl onto report server
7) image still shows a red cross
8) when view source, it shows <img class="R1" src="http://pics.10026.com/?src=">
I have set my datasource credentials to "credentials stored securely on report server" and provided the username and password in the report manager.
chiara.IMG is an unsupported image format. Supported are bmp, jpeg, gif, png, and
x-png.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chiara" <Chiara@.discussions.microsoft.com> wrote in message
news:40B9C60C-320F-47B9-857F-D7DFFD4EE4A6@.microsoft.com...
> Hi
> I have downloaded SP1, and am trying to display an image by URL.
> I have followed the steps described in the SP1Readme. However i am still
unable to view my image in the "Preview" mode in report designer and also
through report server. When i right click to view the source of my webpage,
the image src is empty like this <img class="R1" src="http://pics.10026.com/?src=">.
> Any idea, what can be wrong? This is what i did:
> 1) set in designer Source=External
> 2) set Value=http://localhost/Webmodule/test.img
> 3) image immediately showed up
> 4) Go to "Preview" mode in designer, image shows a red cross
> 5) ran rsconfig -e -m mycomputer -s mycomputer -u user1 -p password
> 6) deploy .rdl onto report server
> 7) image still shows a red cross
> 8) when view source, it shows <img class="R1" src="http://pics.10026.com/?src=">
> I have set my datasource credentials to "credentials stored securely on
report server" and provided the username and password in the report manager.
>
> chiara
>
>sql

External Image Problems

I've placed a logo I'd like on my reports at the path
http://<servername>/reports/images/logo.gif
I've also performed the instructions as per the article "Configuring an
Account for Unattended Report Process" in the RS BOL. I've also re-started
IIS, several times yet I still cannot get the logo to show when I view the
report via the Report Manager.
Any suggestions on what to try next appreciated?It now appears to have corrected itself, may have been a caching issue as I
deleted the report and then re-deployed it.
"Mark Parter" wrote:
> I've placed a logo I'd like on my reports at the path
> http://<servername>/reports/images/logo.gif
> I've also performed the instructions as per the article "Configuring an
> Account for Unattended Report Process" in the RS BOL. I've also re-started
> IIS, several times yet I still cannot get the logo to show when I view the
> report via the Report Manager.
> Any suggestions on what to try next appreciated?|||The machine name where the reports manager is installed doesn't have an
underscore in it's name does it?
"Mark Parter" wrote:
> I've placed a logo I'd like on my reports at the path
> http://<servername>/reports/images/logo.gif
> I've also performed the instructions as per the article "Configuring an
> Account for Unattended Report Process" in the RS BOL. I've also re-started
> IIS, several times yet I still cannot get the logo to show when I view the
> report via the Report Manager.
> Any suggestions on what to try next appreciated?|||Nope.
"Dan Fell" wrote:
> The machine name where the reports manager is installed doesn't have an
> underscore in it's name does it?
> "Mark Parter" wrote:
> > I've placed a logo I'd like on my reports at the path
> > http://<servername>/reports/images/logo.gif
> >
> > I've also performed the instructions as per the article "Configuring an
> > Account for Unattended Report Process" in the RS BOL. I've also re-started
> > IIS, several times yet I still cannot get the logo to show when I view the
> > report via the Report Manager.
> >
> > Any suggestions on what to try next appreciated?|||did you find the problem?
"Mark Parter" wrote:
> Nope.
> "Dan Fell" wrote:
> >
> > The machine name where the reports manager is installed doesn't have an
> > underscore in it's name does it?
> >
> > "Mark Parter" wrote:
> >
> > > I've placed a logo I'd like on my reports at the path
> > > http://<servername>/reports/images/logo.gif
> > >
> > > I've also performed the instructions as per the article "Configuring an
> > > Account for Unattended Report Process" in the RS BOL. I've also re-started
> > > IIS, several times yet I still cannot get the logo to show when I view the
> > > report via the Report Manager.
> > >
> > > Any suggestions on what to try next appreciated?

External Image Problem, Please Help me out!

Hi,
I put a logo image as external source and it works fine on reports server.
The image is in the same folder as report file. However, when I use reporting
service web service to get report as HTML format, I keep getting logon window
and red cross for the image even after I logon. I already follow the
instruction to set up unattended account and reboot server several times. But
it's still no working. The web server is a dormain controller and it's win2k
server with sp4.
Can anyone help me out? I really really appreciate it.
AnthonyCan someone help me this? I asked several questions before, and never got
answered.
"Anthony Wang" wrote:
> Hi,
> I put a logo image as external source and it works fine on reports server.
> The image is in the same folder as report file. However, when I use reporting
> service web service to get report as HTML format, I keep getting logon window
> and red cross for the image even after I logon. I already follow the
> instruction to set up unattended account and reboot server several times. But
> it's still no working. The web server is a dormain controller and it's win2k
> server with sp4.
> Can anyone help me out? I really really appreciate it.
> Anthony|||Images are not rendered by default with SOAP addressability. See
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/ce78cc30cf781cc/5bbfe2e79a693f2c?lnk=st&q=renderstream+group%3A*.reportingsvcs+author%3Alachev&rnum=2&hl=en#5bbfe2e79a693f2c
Long story short, I highly recommend to switch to RS 2005 and use the report
viewer controls. They will handle the images for you.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Anthony Wang" <AnthonyWang@.discussions.microsoft.com> wrote in message
news:BB6C8F0C-56A4-44F1-9003-BAEC30EF3A11@.microsoft.com...
> Hi,
> I put a logo image as external source and it works fine on reports server.
> The image is in the same folder as report file. However, when I use
> reporting
> service web service to get report as HTML format, I keep getting logon
> window
> and red cross for the image even after I logon. I already follow the
> instruction to set up unattended account and reboot server several times.
> But
> it's still no working. The web server is a dormain controller and it's
> win2k
> server with sp4.
> Can anyone help me out? I really really appreciate it.
> Anthony|||thank you Teo, the link you give to me helps me a lot. Now I got it worked.
Really appreciate your help.
"Teo Lachev [MVP]" wrote:
> Images are not rendered by default with SOAP addressability. See
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/ce78cc30cf781cc/5bbfe2e79a693f2c?lnk=st&q=renderstream+group%3A*.reportingsvcs+author%3Alachev&rnum=2&hl=en#5bbfe2e79a693f2c
> Long story short, I highly recommend to switch to RS 2005 and use the report
> viewer controls. They will handle the images for you.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Anthony Wang" <AnthonyWang@.discussions.microsoft.com> wrote in message
> news:BB6C8F0C-56A4-44F1-9003-BAEC30EF3A11@.microsoft.com...
> > Hi,
> >
> > I put a logo image as external source and it works fine on reports server.
> > The image is in the same folder as report file. However, when I use
> > reporting
> > service web service to get report as HTML format, I keep getting logon
> > window
> > and red cross for the image even after I logon. I already follow the
> > instruction to set up unattended account and reboot server several times.
> > But
> > it's still no working. The web server is a dormain controller and it's
> > win2k
> > server with sp4.
> >
> > Can anyone help me out? I really really appreciate it.
> >
> > Anthony
>
>

External image problem when sorting in table

Reporting Services I am using external image png as my header for reports When i am clicking on sort row of the report the header image is dissapeared.Though it is working well in Visual Studio 2005 the problem is occuring after deploying it in reportserver.

What the reason and how can i remove this error.It was working well when i had embeded the image..But i need to have external image only..

Did you install SP1 on the report server (http://www.microsoft.com/sql/sp1.mspx)?

-- Robert

External Image Problem

I've placed a logo I'd like on my reports at the path
http://<servername>/reports/images/logo.gif
I've also performed the instructions as per the article "Configuring an
Account for Unattended Report Process" in the RS BOL. I've also re-started
IIS, several times yet I still cannot get the logo to show when I view the
report via the Report Manager.
If I login to the machine using the account used in the article above, I can
access the URL no problem via IE.
Any suggestions on what to try next appreciated?If the image is on the same server as the report, try using folder path
instead of URL, e.g. "/images/logo.gif".
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> I've placed a logo I'd like on my reports at the path
> http://<servername>/reports/images/logo.gif
> I've also performed the instructions as per the article "Configuring an
> Account for Unattended Report Process" in the RS BOL. I've also re-started
> IIS, several times yet I still cannot get the logo to show when I view the
> report via the Report Manager.
> If I login to the machine using the account used in the article above, I
> can
> access the URL no problem via IE.
> Any suggestions on what to try next appreciated?
>|||Thanks for replying.
Unfortunately, that didn't work either. Any other ideas?
"Fang Wang (MSFT)" wrote:
> If the image is on the same server as the report, try using folder path
> instead of URL, e.g. "/images/logo.gif".
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > I've placed a logo I'd like on my reports at the path
> > http://<servername>/reports/images/logo.gif
> >
> > I've also performed the instructions as per the article "Configuring an
> > Account for Unattended Report Process" in the RS BOL. I've also re-started
> > IIS, several times yet I still cannot get the logo to show when I view the
> > report via the Report Manager.
> >
> > If I login to the machine using the account used in the article above, I
> > can
> > access the URL no problem via IE.
> >
> > Any suggestions on what to try next appreciated?
> >
>
>|||Fang meant that you would upload the image as resource directly on the
report server (e.g. through uploading it in report manager) and then
reference the image via a relative path inside the report server. Did you do
this?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> Thanks for replying.
> Unfortunately, that didn't work either. Any other ideas?
> "Fang Wang (MSFT)" wrote:
> > If the image is on the same server as the report, try using folder path
> > instead of URL, e.g. "/images/logo.gif".
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > I've placed a logo I'd like on my reports at the path
> > > http://<servername>/reports/images/logo.gif
> > >
> > > I've also performed the instructions as per the article "Configuring
an
> > > Account for Unattended Report Process" in the RS BOL. I've also
re-started
> > > IIS, several times yet I still cannot get the logo to show when I view
the
> > > report via the Report Manager.
> > >
> > > If I login to the machine using the account used in the article above,
I
> > > can
> > > access the URL no problem via IE.
> > >
> > > Any suggestions on what to try next appreciated?
> > >
> >
> >
> >|||I'm a little confused as to what the relative path is for an image uploaded
via Report Manager. The image itself is in the database so it doesn't follow
the directory hierarchy define in the Report Manager - right? So, if I
upload test.gif to the /MyFolder directory in Report Manager, how would I
access it and what image type (Embedded, Project, Database or Web) would I
select in the Report Designer?
"Robert Bruckner [MSFT]" wrote:
> Fang meant that you would upload the image as resource directly on the
> report server (e.g. through uploading it in report manager) and then
> reference the image via a relative path inside the report server. Did you do
> this?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > Thanks for replying.
> >
> > Unfortunately, that didn't work either. Any other ideas?
> >
> > "Fang Wang (MSFT)" wrote:
> >
> > > If the image is on the same server as the report, try using folder path
> > > instead of URL, e.g. "/images/logo.gif".
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > I've placed a logo I'd like on my reports at the path
> > > > http://<servername>/reports/images/logo.gif
> > > >
> > > > I've also performed the instructions as per the article "Configuring
> an
> > > > Account for Unattended Report Process" in the RS BOL. I've also
> re-started
> > > > IIS, several times yet I still cannot get the logo to show when I view
> the
> > > > report via the Report Manager.
> > > >
> > > > If I login to the machine using the account used in the article above,
> I
> > > > can
> > > > access the URL no problem via IE.
> > > >
> > > > Any suggestions on what to try next appreciated?
> > > >
> > >
> > >
> > >
>
>|||/MyFolder/test.gif would be the correct image path.
If you upload the image through report manager on a report server, then you
won't see it when you just preview a report in report designer. Only after
the report is deployed on the server!
Instead of independently uploading the image resources through report
manager, you may consider looking into so-called "Project Images" which are
contained in the report project and get automatically deployed to a report
server when deploying the entire report project from report designer. See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
You would add the images as project images in the report project and then
reference them as e.g. test.gif in the report without the need to specify a
path. This is because the project images will get deployed in the same
folder as the reports.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kraig Hiersche" <KraigHiersche@.discussions.microsoft.com> wrote in message
news:C8B3451B-639C-4974-B088-1E061481583F@.microsoft.com...
> I'm a little confused as to what the relative path is for an image
uploaded
> via Report Manager. The image itself is in the database so it doesn't
follow
> the directory hierarchy define in the Report Manager - right? So, if I
> upload test.gif to the /MyFolder directory in Report Manager, how would I
> access it and what image type (Embedded, Project, Database or Web) would I
> select in the Report Designer?
> "Robert Bruckner [MSFT]" wrote:
> > Fang meant that you would upload the image as resource directly on the
> > report server (e.g. through uploading it in report manager) and then
> > reference the image via a relative path inside the report server. Did
you do
> > this?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > > Thanks for replying.
> > >
> > > Unfortunately, that didn't work either. Any other ideas?
> > >
> > > "Fang Wang (MSFT)" wrote:
> > >
> > > > If the image is on the same server as the report, try using folder
path
> > > > instead of URL, e.g. "/images/logo.gif".
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in
message
> > > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > > I've placed a logo I'd like on my reports at the path
> > > > > http://<servername>/reports/images/logo.gif
> > > > >
> > > > > I've also performed the instructions as per the article
"Configuring
> > an
> > > > > Account for Unattended Report Process" in the RS BOL. I've also
> > re-started
> > > > > IIS, several times yet I still cannot get the logo to show when I
view
> > the
> > > > > report via the Report Manager.
> > > > >
> > > > > If I login to the machine using the account used in the article
above,
> > I
> > > > > can
> > > > > access the URL no problem via IE.
> > > > >
> > > > > Any suggestions on what to try next appreciated?
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Thanks. I see that you could also reference this image via a browser by
http://<server>/Reportserver?%2fMyFolder%2ftest.gif. But, is there a way to
get the IMG tag generated in the HTML to use this form rather than always
returning a stream ID?
I have existing images in a web environment that I just want to reference in
the image tags. I can't write to our web servers (for security reasons) and
I can't have report parameters visible via "View Source" in the browser (I am
using secure web services to avoid this). The default image tags generated
break our security and privacy policies (report parameters are visible that
have our internal IDs) and if I set streamroot, I still have to deal with
generating an image with the stream ID (which I can't anywhere). Any help
would be much appreciated.
"Robert Bruckner [MSFT]" wrote:
> /MyFolder/test.gif would be the correct image path.
> If you upload the image through report manager on a report server, then you
> won't see it when you just preview a report in report designer. Only after
> the report is deployed on the server!
> Instead of independently uploading the image resources through report
> manager, you may consider looking into so-called "Project Images" which are
> contained in the report project and get automatically deployed to a report
> server when deploying the entire report project from report designer. See:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
> You would add the images as project images in the report project and then
> reference them as e.g. test.gif in the report without the need to specify a
> path. This is because the project images will get deployed in the same
> folder as the reports.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kraig Hiersche" <KraigHiersche@.discussions.microsoft.com> wrote in message
> news:C8B3451B-639C-4974-B088-1E061481583F@.microsoft.com...
> > I'm a little confused as to what the relative path is for an image
> uploaded
> > via Report Manager. The image itself is in the database so it doesn't
> follow
> > the directory hierarchy define in the Report Manager - right? So, if I
> > upload test.gif to the /MyFolder directory in Report Manager, how would I
> > access it and what image type (Embedded, Project, Database or Web) would I
> > select in the Report Designer?
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Fang meant that you would upload the image as resource directly on the
> > > report server (e.g. through uploading it in report manager) and then
> > > reference the image via a relative path inside the report server. Did
> you do
> > > this?
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > > news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > > > Thanks for replying.
> > > >
> > > > Unfortunately, that didn't work either. Any other ideas?
> > > >
> > > > "Fang Wang (MSFT)" wrote:
> > > >
> > > > > If the image is on the same server as the report, try using folder
> path
> > > > > instead of URL, e.g. "/images/logo.gif".
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in
> message
> > > > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > > > I've placed a logo I'd like on my reports at the path
> > > > > > http://<servername>/reports/images/logo.gif
> > > > > >
> > > > > > I've also performed the instructions as per the article
> "Configuring
> > > an
> > > > > > Account for Unattended Report Process" in the RS BOL. I've also
> > > re-started
> > > > > > IIS, several times yet I still cannot get the logo to show when I
> view
> > > the
> > > > > > report via the Report Manager.
> > > > > >
> > > > > > If I login to the machine using the account used in the article
> above,
> > > I
> > > > > > can
> > > > > > access the URL no problem via IE.
> > > > > >
> > > > > > Any suggestions on what to try next appreciated?
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>

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
>>

External image not displayed in report manager

Hello,
I have a problem and I don't know how to solve it. I hope you guy's
know.
I have a report with a external image which refers to a image on a
SharePoint intranet site. When I preview the report in visual studio
the image is visible. But when I deploy the report to the report server
the image is not displayed and a red cross is showing. I have already
set the execution account on the report server but still not working.
When I enter the URL of the image in the browser on the report server
the image is visible. I don't understand what I do wrong? Hope someone
knows!
I use reporting service 2005
Regards,
Robbert Visscher
HollandI had this problem once. I had to enable anonymous access to the
virtual directory for the images folder.
Not sure if that is what your problem is, but maybe...
-Josh
robbert wrote:
> Hello,
> I have a problem and I don't know how to solve it. I hope you guy's
> know.
> I have a report with a external image which refers to a image on a
> SharePoint intranet site. When I preview the report in visual studio
> the image is visible. But when I deploy the report to the report server
> the image is not displayed and a red cross is showing. I have already
> set the execution account on the report server but still not working.
> When I enter the URL of the image in the browser on the report server
> the image is visible. I don't understand what I do wrong? Hope someone
> knows!
> I use reporting service 2005
> Regards,
> Robbert Visscher
> Holland|||I'm not sure, read that this was fixed in RS 2000 sp1, seems like 2005
should handle it.
Found this:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/540b31cf8bab7cfe/33b1edc0dabb5354?lnk=st&q=Reporting+Services+2005+References+to+external+URLs&rnum=4&hl=en#33b1edc0dabb5354
btw, my wife is Dutch: deLeeuw, going to meet the family there for my first
time next spring.
Steve MunLeeuw
"robbert" <robbert_visscher@.hotmail.com> wrote in message
news:1155673109.459815.285790@.p79g2000cwp.googlegroups.com...
> Hello,
> I have a problem and I don't know how to solve it. I hope you guy's
> know.
> I have a report with a external image which refers to a image on a
> SharePoint intranet site. When I preview the report in visual studio
> the image is visible. But when I deploy the report to the report server
> the image is not displayed and a red cross is showing. I have already
> set the execution account on the report server but still not working.
> When I enter the URL of the image in the browser on the report server
> the image is visible. I don't understand what I do wrong? Hope someone
> knows!
> I use reporting service 2005
> Regards,
> Robbert Visscher
> Holland
>|||The image is on a Share Point site so the images are collected in a
Share Point database. But in my preview it works fine so I don't
understand why it not works in de report manager?|||Import(upload) the image file on to the report manger|||Thanks for your answer but it is not a good solution. It has to work
like this way. But why is it not working? It works fine in visual
studio. I have already read a lot of questions on the Internet about
this problem but no one can solve the problem. Maby it is a bug? I
think that the unattended execution account is not working with
reporting service 2005. I have already installed SP1 and the latest
hotfix. So does anyone know what it could be or confirm it is a Bug?
Regards,
Robbert
Holland|||Again, it sounds like a permission issue to me. When you try it using
the Preview tab, it is using your credentials. When it runs via Report
Manager, it does not use your credentials.
Does the ID that SSRS is running under have access to SharePoint?
-Josh
robbert wrote:
> Thanks for your answer but it is not a good solution. It has to work
> like this way. But why is it not working? It works fine in visual
> studio. I have already read a lot of questions on the Internet about
> this problem but no one can solve the problem. Maby it is a bug? I
> think that the unattended execution account is not working with
> reporting service 2005. I have already installed SP1 and the latest
> hotfix. So does anyone know what it could be or confirm it is a Bug?
> Regards,
> Robbert
> Holland|||Hello Josh,
Thanks for your answer! I have set the credentials in the report
manager which are the same as mine credentials. I have set the
unattended execution account and the Windows service identity as the
same I use in visual studio. Also when I acces the URL in the browser
the image is visible. I have access to the share point site because I
see the image in the browser. I hope you know a solution! Thanks!
Robbert
Holland
Josh schreef:
> Again, it sounds like a permission issue to me. When you try it using
> the Preview tab, it is using your credentials. When it runs via Report
> Manager, it does not use your credentials.
> Does the ID that SSRS is running under have access to SharePoint?
> -Josh
>
> robbert wrote:
> > Thanks for your answer but it is not a good solution. It has to work
> > like this way. But why is it not working? It works fine in visual
> > studio. I have already read a lot of questions on the Internet about
> > this problem but no one can solve the problem. Maby it is a bug? I
> > think that the unattended execution account is not working with
> > reporting service 2005. I have already installed SP1 and the latest
> > hotfix. So does anyone know what it could be or confirm it is a Bug?
> >
> > Regards,
> >
> > Robbert
> > Holland|||Robbert,
And you enabled anonymous access on that sharepoint site?
-Josh
robbert wrote:
> Hello Josh,
> Thanks for your answer! I have set the credentials in the report
> manager which are the same as mine credentials. I have set the
> unattended execution account and the Windows service identity as the
> same I use in visual studio. Also when I acces the URL in the browser
> the image is visible. I have access to the share point site because I
> see the image in the browser. I hope you know a solution! Thanks!
> Robbert
> Holland
> Josh schreef:
> > Again, it sounds like a permission issue to me. When you try it using
> > the Preview tab, it is using your credentials. When it runs via Report
> > Manager, it does not use your credentials.
> >
> > Does the ID that SSRS is running under have access to SharePoint?
> >
> > -Josh
> >
> >
> > robbert wrote:
> > > Thanks for your answer but it is not a good solution. It has to work
> > > like this way. But why is it not working? It works fine in visual
> > > studio. I have already read a lot of questions on the Internet about
> > > this problem but no one can solve the problem. Maby it is a bug? I
> > > think that the unattended execution account is not working with
> > > reporting service 2005. I have already installed SP1 and the latest
> > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > >
> > > Regards,
> > >
> > > Robbert
> > > Holland|||Helle Josh,
Anonymous acces we can not enabled that because of security. But i have
set a unattended execution account so I dont need that right?
Robbert
Josh schreef:
> Robbert,
> And you enabled anonymous access on that sharepoint site?
> -Josh
>
> robbert wrote:
> > Hello Josh,
> >
> > Thanks for your answer! I have set the credentials in the report
> > manager which are the same as mine credentials. I have set the
> > unattended execution account and the Windows service identity as the
> > same I use in visual studio. Also when I acces the URL in the browser
> > the image is visible. I have access to the share point site because I
> > see the image in the browser. I hope you know a solution! Thanks!
> >
> > Robbert
> > Holland
> >
> > Josh schreef:
> >
> > > Again, it sounds like a permission issue to me. When you try it using
> > > the Preview tab, it is using your credentials. When it runs via Report
> > > Manager, it does not use your credentials.
> > >
> > > Does the ID that SSRS is running under have access to SharePoint?
> > >
> > > -Josh
> > >
> > >
> > > robbert wrote:
> > > > Thanks for your answer but it is not a good solution. It has to work
> > > > like this way. But why is it not working? It works fine in visual
> > > > studio. I have already read a lot of questions on the Internet about
> > > > this problem but no one can solve the problem. Maby it is a bug? I
> > > > think that the unattended execution account is not working with
> > > > reporting service 2005. I have already installed SP1 and the latest
> > > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > > >
> > > > Regards,
> > > >
> > > > Robbert
> > > > Holland|||When I added an "external" image to a report (using a URL as the image
source), I received a warning stating that images would not display
correctly unless an unattended execution account or anonymous access
was configured. Because this was an "OR", I am assuming that you only
need 1 or the other.
My thought was to enable anonymous access, try your report, and disable
anonymous again, just to see if that solves the problem.
Sorry I can't be of more help.
-Josh
robbert wrote:
> Helle Josh,
> Anonymous acces we can not enabled that because of security. But i have
> set a unattended execution account so I dont need that right?
> Robbert
> Josh schreef:
> > Robbert,
> >
> > And you enabled anonymous access on that sharepoint site?
> >
> > -Josh
> >
> >
> >
> > robbert wrote:
> > > Hello Josh,
> > >
> > > Thanks for your answer! I have set the credentials in the report
> > > manager which are the same as mine credentials. I have set the
> > > unattended execution account and the Windows service identity as the
> > > same I use in visual studio. Also when I acces the URL in the browser
> > > the image is visible. I have access to the share point site because I
> > > see the image in the browser. I hope you know a solution! Thanks!
> > >
> > > Robbert
> > > Holland
> > >
> > > Josh schreef:
> > >
> > > > Again, it sounds like a permission issue to me. When you try it using
> > > > the Preview tab, it is using your credentials. When it runs via Report
> > > > Manager, it does not use your credentials.
> > > >
> > > > Does the ID that SSRS is running under have access to SharePoint?
> > > >
> > > > -Josh
> > > >
> > > >
> > > > robbert wrote:
> > > > > Thanks for your answer but it is not a good solution. It has to work
> > > > > like this way. But why is it not working? It works fine in visual
> > > > > studio. I have already read a lot of questions on the Internet about
> > > > > this problem but no one can solve the problem. Maby it is a bug? I
> > > > > think that the unattended execution account is not working with
> > > > > reporting service 2005. I have already installed SP1 and the latest
> > > > > hotfix. So does anyone know what it could be or confirm it is a Bug?
> > > > >
> > > > > Regards,
> > > > >
> > > > > Robbert
> > > > > Holland|||I had the same problem. The image i was originally trying to access was a
bitmap file. I re-saved it as a jpeg and then it worked fine.
robbert wrote:
>Hello,
>I have a problem and I don't know how to solve it. I hope you guy's
>know.
>I have a report with a external image which refers to a image on a
>SharePoint intranet site. When I preview the report in visual studio
>the image is visible. But when I deploy the report to the report server
>the image is not displayed and a red cross is showing. I have already
>set the execution account on the report server but still not working.
>When I enter the URL of the image in the browser on the report server
>the image is visible. I don't understand what I do wrong? Hope someone
>knows!
>I use reporting service 2005
>Regards,
>Robbert Visscher
>Holland|||It are jpeg files and they work in visual studio. The problem still is
that i get red crosses in the report manager. I don't understand it.
IanGregson schreef:
> I had the same problem. The image i was originally trying to access was a
> bitmap file. I re-saved it as a jpeg and then it worked fine.
> robbert wrote:
> >Hello,
> >
> >I have a problem and I don't know how to solve it. I hope you guy's
> >know.
> >
> >I have a report with a external image which refers to a image on a
> >SharePoint intranet site. When I preview the report in visual studio
> >the image is visible. But when I deploy the report to the report server
> >the image is not displayed and a red cross is showing. I have already
> >set the execution account on the report server but still not working.
> >When I enter the URL of the image in the browser on the report server
> >the image is visible. I don't understand what I do wrong? Hope someone
> >knows!
> >
> >I use reporting service 2005
> >
> >Regards,
> >
> >Robbert Visscher
> >Holland

External Image disappears with Interactive Sorting

Hi,

I have an image in the page header that is included in the project and is defined as "external". I also have interactive sorting enabled for the report. When a column is sorted, the image in the page header disappears. I deleted the image from the report and re-created it as "embedded" which does retain the image between postbacks.

Thank you,

Bob

Thank you Bob. This issue will be fixed in SP2 of RS 2005. If you have a pressing need, a hotfix has been released that product support services has.|||

Thank you Brad, I can live with this work around until SP2. In pre-SP1, I liked the "Select All" feature in multivalued parameters. In SP2, will this be available again? Will there be an option to turn this on and off, I hope?

|||

There is a post-SP1 hotfix which will restore the "Select All" option exactly the way it was in RTM. You will need to contact Microsoft product support (http://www.microsoft.com/services/microsoftservices/srv_support.mspx) to receive the SP1-based hotfix.

-- Robert

|||

Robert,

I installed the sequence of post-SP1 Hotfixes (including the one for SSRS) accessible through the link you provided, but this did not restore the 'Select All' capability. I called the support line and they could not provide any assistance without a reference # for the fix. Can you provide a bit more information on what needs to be installed/configured to restore the 'Select All' capability?

For reference: http://support.microsoft.com/kb/918222 is where I found the Hot Fix package.

Thanks in advance,

Bob Mack - HP

|||

Sql Hotfix #803 - but you may need to wait a few more days because a new package is currently being built.

-- Robert

|||Any update on the availability of this Hotfix?

Expression on hidden property

I have param named Direction i would like to put

on the hidden property of image this expression

iif(Parameters!Direction.Value = "ascending" ,False ,True)

But i've got error message

.....my expression is not avalid value.

why?

Hi, didn't you miss the "=" as in :

=iif(Parameters!Direction.Value = "ascending" ,False ,True)

|||

Maybe?

Can you please write me the correct form you think it should be?

|||

It′s like a said before...

=iif(Parameters!Direction.Value = "ascending" ,False ,True)

if everything's ok that should hide your image when the Parameters!Direction.Value is "ascending" and show it otherwise.

|||Thanks, work grate :)