Conditional Image in Page Header

I have an image defined as:
="http://server.name.com/images" & IIf((Left(First(Fields!logo_url.Value,
"DeploymentDeliveryHeader"),1) = "/"),First(Fields!logo_url.Value,
"DeploymentDeliveryHeader"),"/BlueBar_withGraphic.gif")
I want to move this image to the report header. But am getting a message
stating that Fields cannot be used in report headers or footers. I think I
can hide it in the report and reference it in the header. But I don't know
how to reference an image.
Anyone know how to get an image in a header?Stephanie,
Can you store the path to the image in a hidden textbox in the body of the
report, then your image in the header will refer to the textbox for it's
image source value.
Make sense?
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:88A98827-774E-44F6-87B2-1B39A9544C7F@.microsoft.com...
>I have an image defined as:
> ="http://server.name.com/images" & IIf((Left(First(Fields!logo_url.Value,
> "DeploymentDeliveryHeader"),1) = "/"),First(Fields!logo_url.Value,
> "DeploymentDeliveryHeader"),"/BlueBar_withGraphic.gif")
> I want to move this image to the report header. But am getting a message
> stating that Fields cannot be used in report headers or footers. I think
> I
> can hide it in the report and reference it in the header. But I don't
> know
> how to reference an image.
> Anyone know how to get an image in a header?|||Yes, makes sense and I just did that. The report is not erroring out now
(yea!) but the image is blank. This has got to be something people do on a
regular basis, isn't it? I don't want an embedded image because the image
changes based on the database the report is run against.
Any other suggestions on how to put an external image in a page header?
"Andy Potter" wrote:
> Stephanie,
> Can you store the path to the image in a hidden textbox in the body of the
> report, then your image in the header will refer to the textbox for it's
> image source value.
> Make sense?
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:88A98827-774E-44F6-87B2-1B39A9544C7F@.microsoft.com...
> >I have an image defined as:
> > ="http://server.name.com/images" & IIf((Left(First(Fields!logo_url.Value,
> > "DeploymentDeliveryHeader"),1) = "/"),First(Fields!logo_url.Value,
> > "DeploymentDeliveryHeader"),"/BlueBar_withGraphic.gif")
> >
> > I want to move this image to the report header. But am getting a message
> > stating that Fields cannot be used in report headers or footers. I think
> > I
> > can hide it in the report and reference it in the header. But I don't
> > know
> > how to reference an image.
> >
> > Anyone know how to get an image in a header?
>
>|||Nevermind my last reply. I tried it again and it worked just fine. THANK YOU!
Stephanie ; )
"Andy Potter" wrote:
> Stephanie,
> Can you store the path to the image in a hidden textbox in the body of the
> report, then your image in the header will refer to the textbox for it's
> image source value.
> Make sense?
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:88A98827-774E-44F6-87B2-1B39A9544C7F@.microsoft.com...
> >I have an image defined as:
> > ="http://server.name.com/images" & IIf((Left(First(Fields!logo_url.Value,
> > "DeploymentDeliveryHeader"),1) = "/"),First(Fields!logo_url.Value,
> > "DeploymentDeliveryHeader"),"/BlueBar_withGraphic.gif")
> >
> > I want to move this image to the report header. But am getting a message
> > stating that Fields cannot be used in report headers or footers. I think
> > I
> > can hide it in the report and reference it in the header. But I don't
> > know
> > how to reference an image.
> >
> > Anyone know how to get an image in a header?
>
>