all groups > sql server reporting services > january 2005 >
You're in the

sql server reporting services

group:

dynamic field value


dynamic field value collie
1/30/2005 12:21:07 PM
sql server reporting services:
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?

Re: dynamic field value Peter C. Jacobs
1/30/2005 10:26:26 PM
try 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

[quoted text, click to view]

RE: dynamic field value Rajan
1/30/2005 10:53:05 PM
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.


[quoted text, click to view]
RE: dynamic field value collie
1/31/2005 9:07:03 AM
Thanks guys

[quoted text, click to view]
AddThis Social Bookmark Button