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 |
|
candyme
Starting Member
4 Posts |
 Posted - 2006-09-19 : 22:57:15
|
| Hello, I have 2 parameters in my .rdl. 1. I would like that after the user enter values in Param1, an event or something would be triggered that would populate Param2.2. When user clicks 'View Reports', he will be prompted that Param2 cannot be left blank if he entered value in Parm1. How would i do this?Thank you.Gerri |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-09-20 : 08:24:19
|
| 1. Ensure you have a variable in the proc/sql that populates Param2, set that variable equal to the value of Param1. Make sure Param1 is listed before Param2 in the report parameters list.2. Set param2 to not allow nulls and set the default value to null and it will be required. |
 |
|
|
|
|
|
Parameter Dependencies