dynamic field value

Hello,
In the page header I have a textbox whose value I want to change based on
the parameter. If param=1 then I want the value of the textbox to be Invoice
otherwise I want it to be 'B/S'.
How can I change the value of the textbox?
Thankstry setting the value property of the textbox to something like
=IIF(Parameters!Param_1.Value=1,"Invoice ","B\S")
inova. SOLUTIONS
Peter Jacobs MCSE MCDBA MCT
Güterstrasse 5/7
CH-3072 Ostermundigen
"collie" <collie@.discussions.microsoft.com> wrote in message
news:110178DB-C794-414C-B8FF-6E4448714494@.microsoft.com...
> Hello,
> In the page header I have a textbox whose value I want to change based on
> the parameter. If param=1 then I want the value of the textbox to be
> Invoice
> otherwise I want it to be 'B/S'.
> How can I change the value of the textbox?
> Thanks|||You can use report parameters for doing this. Add a report parameter to your
report. Then refer the report parameter in your jump to url option as
=Parameters!WebServerPath.Value + "?Id=" + Trim( Fields!ID.Value)
Where "WebServerPath" is ur report parameter and "Id" is your row value
which u want to pass it to the new page.
Hope this helps.
"collie" wrote:
> Hello,
> In the page header I have a textbox whose value I want to change based on
> the parameter. If param=1 then I want the value of the textbox to be Invoice
> otherwise I want it to be 'B/S'.
> How can I change the value of the textbox?
> Thanks|||Thanks guys
"Rajan" wrote:
> You can use report parameters for doing this. Add a report parameter to your
> report. Then refer the report parameter in your jump to url option as
> =Parameters!WebServerPath.Value + "?Id=" + Trim( Fields!ID.Value)
> Where "WebServerPath" is ur report parameter and "Id" is your row value
> which u want to pass it to the new page.
> Hope this helps.
>
> "collie" wrote:
> > Hello,
> >
> > In the page header I have a textbox whose value I want to change based on
> > the parameter. If param=1 then I want the value of the textbox to be Invoice
> > otherwise I want it to be 'B/S'.
> > How can I change the value of the textbox?
> >
> > Thanks

dynamic field for backgroundcolor

How can i change the background color of a textbox in RS where the
background color is stored in a dataset?
I have been trying this on the background color properties:
=Fields.LineColor.Value
Values on that dataset include standard colors like:
-DimGray
-Gray
-White
so on
I also tried using Hex or integers but to no avail.
I need this because I have set of rows where color is attached. The
list is dynamic and cannot be hard-coded in the report.Shouldn't that be:
=Fields!LineColor.Value
vice
=Fields.LineColor.Value
John Grant
=""" & Fields!
"rGenius" wrote:
> How can i change the background color of a textbox in RS where the
> background color is stored in a dataset?
> I have been trying this on the background color properties:
> =Fields.LineColor.Value
> Values on that dataset include standard colors like:
> -DimGray
> -Gray
> -White
> so on
> I also tried using Hex or integers but to no avail.
> I need this because I have set of rows where color is attached. The
> list is dynamic and cannot be hard-coded in the report.
>|||typo error
yes it is =Fields!LineColor.Value