Change height of image control

Is it possible to use an iif statement to set the height of an image
control. I have tried something like this, but it did not work:
iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double quotes
around the 1.5in and .5in, but that didn't work either.
Thanks,On Jun 1, 9:33 am, "Tim Kelley" <tkel...@.company.com> wrote:
> Is it possible to use an iif statement to set the height of an image
> control. I have tried something like this, but it did not work:
> iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double quotes
> around the 1.5in and .5in, but that didn't work either.
> Thanks,
As far as I know, it is not possible. Why are you needing to adjust
the image size? Are you trying to swap images?
Enrique Martinez
Sr. Software Consultant|||I have a subreport that will have a varying amout of lines. I have a bitmap
I am using for a border and would like to grow or shrink the bitmap based on
how many lines are in the subreport. I will probably need to resize the
subreport control too if that is possible.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1180742850.339314.203650@.q69g2000hsb.googlegroups.com...
> On Jun 1, 9:33 am, "Tim Kelley" <tkel...@.company.com> wrote:
>> Is it possible to use an iif statement to set the height of an image
>> control. I have tried something like this, but it did not work:
>> iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double quotes
>> around the 1.5in and .5in, but that didn't work either.
>> Thanks,
>
> As far as I know, it is not possible. Why are you needing to adjust
> the image size? Are you trying to swap images?
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 4, 7:37 am, "Tim Kelley" <tkel...@.company.com> wrote:
> I have a subreport that will have a varying amout of lines. I have a bitmap
> I am using for a border and would like to grow or shrink the bitmap based on
> how many lines are in the subreport. I will probably need to resize the
> subreport control too if that is possible.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1180742850.339314.203650@.q69g2000hsb.googlegroups.com...
> > On Jun 1, 9:33 am, "Tim Kelley" <tkel...@.company.com> wrote:
> >> Is it possible to use an iif statement to set the height of an image
> >> control. I have tried something like this, but it did not work:
> >> iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double quotes
> >> around the 1.5in and .5in, but that didn't work either.
> >> Thanks,
> > As far as I know, it is not possible. Why are you needing to adjust
> > the image size? Are you trying to swap images?
> > Enrique Martinez
> > Sr. Software Consultant
You might be able to achieve the same result via a border style in a
header of the subreport, etc. As far as I know, resizing the subreport
may not be feasible. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Would it be possible to move the subreport or other controls on the report?
Tim
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1180998091.389326.168520@.o5g2000hsb.googlegroups.com...
> On Jun 4, 7:37 am, "Tim Kelley" <tkel...@.company.com> wrote:
>> I have a subreport that will have a varying amout of lines. I have a
>> bitmap
>> I am using for a border and would like to grow or shrink the bitmap based
>> on
>> how many lines are in the subreport. I will probably need to resize the
>> subreport control too if that is possible.
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:1180742850.339314.203650@.q69g2000hsb.googlegroups.com...
>> > On Jun 1, 9:33 am, "Tim Kelley" <tkel...@.company.com> wrote:
>> >> Is it possible to use an iif statement to set the height of an image
>> >> control. I have tried something like this, but it did not work:
>> >> iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double
>> >> quotes
>> >> around the 1.5in and .5in, but that didn't work either.
>> >> Thanks,
>> > As far as I know, it is not possible. Why are you needing to adjust
>> > the image size? Are you trying to swap images?
>> > Enrique Martinez
>> > Sr. Software Consultant
>
> You might be able to achieve the same result via a border style in a
> header of the subreport, etc. As far as I know, resizing the subreport
> may not be feasible. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Change gridline color at specific value

Has anyone written a conditional statement to change a gridline value at a
specific value?
=iif(?=90, "Red","Silver")
Any advise is apreciated.
Thanks,
Scott A. BakerSorry, setting the color of individual gridlines is not supported.
Are you trying to set a specific horizontal gridline (in a column chart or
line chart) or a vertical gridline (in a bar chart)?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
news:u7$csZ%230FHA.1564@.tk2msftngp13.phx.gbl...
> Has anyone written a conditional statement to change a gridline value at
> a specific value?
> =iif(?=90, "Red","Silver")
> Any advise is apreciated.
> Thanks,
> Scott A. Baker
>|||I am attempting to set a horizontal gridline for a stacked column chart. I
noticed that where you set the color for grid there is also an expression
button. I assumed you would be able to change the color depending on the
value.
This becomes helpful in setting a static goal line. In my example
=iif(?=90, "Red","Silver") , the 90 represents the goal.
Thank you for your response.
Scott
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23j$WdcF1FHA.3660@.TK2MSFTNGP15.phx.gbl...
> Sorry, setting the color of individual gridlines is not supported.
> Are you trying to set a specific horizontal gridline (in a column chart or
> line chart) or a vertical gridline (in a bar chart)?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
> news:u7$csZ%230FHA.1564@.tk2msftngp13.phx.gbl...
>> Has anyone written a conditional statement to change a gridline value at
>> a specific value?
>> =iif(?=90, "Red","Silver")
>> Any advise is apreciated.
>> Thanks,
>> Scott A. Baker
>>
>|||In that case, you could just add another data series and plot that series as
line. Set the data value expression to =90 and set the BorderColor property
accordingly.
Note: you don't use the gridlines to show your static goal line, but rather
you add a "fake" data series with a constant value to show the goal line.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
news:%23oI9ysO1FHA.3660@.TK2MSFTNGP15.phx.gbl...
>I am attempting to set a horizontal gridline for a stacked column chart. I
>noticed that where you set the color for grid there is also an expression
>button. I assumed you would be able to change the color depending on the
>value.
> This becomes helpful in setting a static goal line. In my example
> =iif(?=90, "Red","Silver") , the 90 represents the goal.
> Thank you for your response.
> Scott
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%23j$WdcF1FHA.3660@.TK2MSFTNGP15.phx.gbl...
>> Sorry, setting the color of individual gridlines is not supported.
>> Are you trying to set a specific horizontal gridline (in a column chart
>> or line chart) or a vertical gridline (in a bar chart)?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
>> news:u7$csZ%230FHA.1564@.tk2msftngp13.phx.gbl...
>> Has anyone written a conditional statement to change a gridline value at
>> a specific value?
>> =iif(?=90, "Red","Silver")
>> Any advise is apreciated.
>> Thanks,
>> Scott A. Baker
>>
>>
>|||Robert,
Again thank you for your prompt response. I have added a static line to the
charts that cover multiple time periods. However, I also show a period
summary that only has one x axis value. In this case, a static line does
not work because there is not more than one data point to connect to.
Any other suggestions?
Thanks,
Scott
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:usZ5QPS1FHA.1256@.TK2MSFTNGP09.phx.gbl...
> In that case, you could just add another data series and plot that series
> as line. Set the data value expression to =90 and set the BorderColor
> property accordingly.
> Note: you don't use the gridlines to show your static goal line, but
> rather you add a "fake" data series with a constant value to show the goal
> line.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
> news:%23oI9ysO1FHA.3660@.TK2MSFTNGP15.phx.gbl...
>>I am attempting to set a horizontal gridline for a stacked column chart.
>>I noticed that where you set the color for grid there is also an
>>expression button. I assumed you would be able to change the color
>>depending on the value.
>> This becomes helpful in setting a static goal line. In my example
>> =iif(?=90, "Red","Silver") , the 90 represents the goal.
>> Thank you for your response.
>> Scott
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:%23j$WdcF1FHA.3660@.TK2MSFTNGP15.phx.gbl...
>> Sorry, setting the color of individual gridlines is not supported.
>> Are you trying to set a specific horizontal gridline (in a column chart
>> or line chart) or a vertical gridline (in a bar chart)?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
>> news:u7$csZ%230FHA.1564@.tk2msftngp13.phx.gbl...
>> Has anyone written a conditional statement to change a gridline value
>> at a specific value?
>> =iif(?=90, "Red","Silver")
>> Any advise is apreciated.
>> Thanks,
>> Scott A. Baker
>>
>>
>>
>|||If the chart has only one data point at all, then my suggestion won't work.
But here is another idea for the summary scenario with only one datapoint:
turn off margins on the x-axis and use a column chart to draw a "zone"
instead of a target line. Since the margins are turned off, it would like if
the chart had then only two zones and your actual datapoint summary value
either is in the "good" or the "bad" zone.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
news:up5Jr7W1FHA.2428@.tk2msftngp13.phx.gbl...
> Robert,
> Again thank you for your prompt response. I have added a static line to
> the charts that cover multiple time periods. However, I also show a
> period summary that only has one x axis value. In this case, a static
> line does not work because there is not more than one data point to
> connect to.
> Any other suggestions?
> Thanks,
> Scott
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:usZ5QPS1FHA.1256@.TK2MSFTNGP09.phx.gbl...
>> In that case, you could just add another data series and plot that series
>> as line. Set the data value expression to =90 and set the BorderColor
>> property accordingly.
>> Note: you don't use the gridlines to show your static goal line, but
>> rather you add a "fake" data series with a constant value to show the
>> goal line.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
>> news:%23oI9ysO1FHA.3660@.TK2MSFTNGP15.phx.gbl...
>>I am attempting to set a horizontal gridline for a stacked column chart.
>>I noticed that where you set the color for grid there is also an
>>expression button. I assumed you would be able to change the color
>>depending on the value.
>> This becomes helpful in setting a static goal line. In my example
>> =iif(?=90, "Red","Silver") , the 90 represents the goal.
>> Thank you for your response.
>> Scott
>>
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:%23j$WdcF1FHA.3660@.TK2MSFTNGP15.phx.gbl...
>> Sorry, setting the color of individual gridlines is not supported.
>> Are you trying to set a specific horizontal gridline (in a column chart
>> or line chart) or a vertical gridline (in a bar chart)?
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
>> news:u7$csZ%230FHA.1564@.tk2msftngp13.phx.gbl...
>> Has anyone written a conditional statement to change a gridline value
>> at a specific value?
>> =iif(?=90, "Red","Silver")
>> Any advise is apreciated.
>> Thanks,
>> Scott A. Baker
>>
>>
>>
>>
>|||Set Gridlines = null,Cellspacing = 1,BorderColor = 'Red' , and then you will
find the color of gridlines has been changed!
"Robert Bruckner [MSFT]" wrote:
> If the chart has only one data point at all, then my suggestion won't work.
> But here is another idea for the summary scenario with only one datapoint:
> turn off margins on the x-axis and use a column chart to draw a "zone"
> instead of a target line. Since the margins are turned off, it would like if
> the chart had then only two zones and your actual datapoint summary value
> either is in the "good" or the "bad" zone.
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
> news:up5Jr7W1FHA.2428@.tk2msftngp13.phx.gbl...
> > Robert,
> >
> > Again thank you for your prompt response. I have added a static line to
> > the charts that cover multiple time periods. However, I also show a
> > period summary that only has one x axis value. In this case, a static
> > line does not work because there is not more than one data point to
> > connect to.
> >
> > Any other suggestions?
> >
> > Thanks,
> >
> > Scott
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > news:usZ5QPS1FHA.1256@.TK2MSFTNGP09.phx.gbl...
> >> In that case, you could just add another data series and plot that series
> >> as line. Set the data value expression to =90 and set the BorderColor
> >> property accordingly.
> >>
> >> Note: you don't use the gridlines to show your static goal line, but
> >> rather you add a "fake" data series with a constant value to show the
> >> goal line.
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
> >> news:%23oI9ysO1FHA.3660@.TK2MSFTNGP15.phx.gbl...
> >>I am attempting to set a horizontal gridline for a stacked column chart.
> >>I noticed that where you set the color for grid there is also an
> >>expression button. I assumed you would be able to change the color
> >>depending on the value.
> >>
> >> This becomes helpful in setting a static goal line. In my example
> >> =iif(?=90, "Red","Silver") , the 90 represents the goal.
> >>
> >> Thank you for your response.
> >>
> >> Scott
> >>
> >>
> >> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> >> news:%23j$WdcF1FHA.3660@.TK2MSFTNGP15.phx.gbl...
> >> Sorry, setting the color of individual gridlines is not supported.
> >> Are you trying to set a specific horizontal gridline (in a column chart
> >> or line chart) or a vertical gridline (in a bar chart)?
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Scott Baker" <sNbOaSkPeArM@.orasure.com> wrote in message
> >> news:u7$csZ%230FHA.1564@.tk2msftngp13.phx.gbl...
> >> Has anyone written a conditional statement to change a gridline value
> >> at a specific value?
> >>
> >> =iif(?=90, "Red","Silver")
> >>
> >> Any advise is apreciated.
> >>
> >> Thanks,
> >>
> >> Scott A. Baker
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>