Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2006-01-13 : 10:33:52
|
| How can i show the paraemeter value(parameter is chosen from drop down list on top left) that value i would like to show on the report in a text box control.parameter: eStatusThis report is a status report like( OPen , closed, pending, All etc.) so when the report is shown i would like to show on top what report it is by showing the parameter value saying Open or closed.Thank you very much for the information. |
|
|
jhermiz
3564 Posts |
Posted - 2006-01-13 : 14:06:24
|
Very simple, an rs report has objects associated with it. One object in particular is the Parameters object. Try this:=IIF(LEN(Parameters!PROJECTNAME.Value) > 0, "Project: " & Parameters!PROJECTNAME.Value, "All Projects")Meaning mine shows a project name if a project has been selected, else it shows the text: "All Projects"So its:Parameters!Field.Value To show the parameter, place this inside a text box like so:=Parameters!Field.ValueReplace the word field with your field name.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
|
|
|
How to show report parameter value on report