Dynamically Changing the Picture at the Record Level.

Hi,
Appreciate your help on the following.
I need to display images according to the status of the record. For example,
I am displaying product list where the margin is less than 15% then display
image1, when margin is between 16% and 25% display image2 etc. I am currently
using a table to store the path of the images.
Thank you again,
KG@.SF
Highly appreciate your helpI also have to develop similar concept but Matrix report where I have to
again display image indicators when a category of product margin falls betwen
a certain range. Appreciate your help,
KG
"KG@.SFC" wrote:
> Hi,
> Appreciate your help on the following.
> I need to display images according to the status of the record. For example,
> I am displaying product list where the margin is less than 15% then display
> image1, when margin is between 16% and 25% display image2 etc. I am currently
> using a table to store the path of the images.
> Thank you again,
> KG@.SF
> Highly appreciate your help

Dynamically Changing Images

Hi All:
I have a report that will be shared by a number of sales agents across a
number of different communities. The agents select a set of parameters and
run their report. Currently Community is one of the parameters they can
select.
I'd like to know if there is any way to dynamically change a graphic based
upon what Community is selected. We'd like to have only one report where the
logo can change rather than 12 different reports.
Thanks
BrennanWe have a property report that shows an image dynamically, our properties
have an ID number assigned to them.
ID number is one of the parameters of the report. On our webserver, we have
an image file (named the id number).
For example the user can choose building number 00818, and on the web server
is a corresponding image 00818.jpg.
We set the image type to external, and the value is an expression -
http://<yourserver>/BuildingImages/ & Parameters!ID.value & ".jpg"
This returns an image on the report based on the building the user has
chosen.
Chris
"Brennan" <Brennan@.discussions.microsoft.com> wrote in message
news:A3E076C0-EF3A-4903-B565-0DFA39A5A13A@.microsoft.com...
> Hi All:
> I have a report that will be shared by a number of sales agents across a
> number of different communities. The agents select a set of parameters
> and
> run their report. Currently Community is one of the parameters they can
> select.
> I'd like to know if there is any way to dynamically change a graphic based
> upon what Community is selected. We'd like to have only one report where
> the
> logo can change rather than 12 different reports.
> Thanks
> Brennan|||"Chris" wrote:
> We have a property report that shows an image dynamically, our properties
> have an ID number assigned to them.
> ID number is one of the parameters of the report. On our webserver, we have
> an image file (named the id number).
> For example the user can choose building number 00818, and on the web server
> is a corresponding image 00818.jpg.
> We set the image type to external, and the value is an expression -
> http://<yourserver>/BuildingImages/ & Parameters!ID.value & ".jpg"
> This returns an image on the report based on the building the user has
> chosen.
> Chris
> "Brennan" <Brennan@.discussions.microsoft.com> wrote in message
> news:A3E076C0-EF3A-4903-B565-0DFA39A5A13A@.microsoft.com...
> > Hi All:
> >
> > I have a report that will be shared by a number of sales agents across a
> > number of different communities. The agents select a set of parameters
> > and
> > run their report. Currently Community is one of the parameters they can
> > select.
> >
> > I'd like to know if there is any way to dynamically change a graphic based
> > upon what Community is selected. We'd like to have only one report where
> > the
> > logo can change rather than 12 different reports.
> >
> > Thanks
> > Brennan
>
>
Thanks Chris|||You can also use a "switch" expression in your value field for the
image:
switch(parameters!community.value = 'x', image1,
parameters!community.value = 'y', image2, ...)
Brennan wrote:
> "Chris" wrote:
> > We have a property report that shows an image dynamically, our properties
> > have an ID number assigned to them.
> > ID number is one of the parameters of the report. On our webserver, we have
> > an image file (named the id number).
> > For example the user can choose building number 00818, and on the web server
> > is a corresponding image 00818.jpg.
> > We set the image type to external, and the value is an expression -
> > http://<yourserver>/BuildingImages/ & Parameters!ID.value & ".jpg"
> >
> > This returns an image on the report based on the building the user has
> > chosen.
> >
> > Chris
> >
> > "Brennan" <Brennan@.discussions.microsoft.com> wrote in message
> > news:A3E076C0-EF3A-4903-B565-0DFA39A5A13A@.microsoft.com...
> > > Hi All:
> > >
> > > I have a report that will be shared by a number of sales agents across a
> > > number of different communities. The agents select a set of parameters
> > > and
> > > run their report. Currently Community is one of the parameters they can
> > > select.
> > >
> > > I'd like to know if there is any way to dynamically change a graphic based
> > > upon what Community is selected. We'd like to have only one report where
> > > the
> > > logo can change rather than 12 different reports.
> > >
> > > Thanks
> > > Brennan
> >
> >
> >
>
> Thanks Chris