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 |
|
satsap
Starting Member
9 Posts |
 Posted - 2008-11-13 : 11:12:16
|
| When the worker selects the parameter and the workers workload has the stage then i need to show the rectangle, Otherwise the rectangle should be hidden.I tried the following expression IIF(Parameter!Edu_ind.value = "N", True, False) - This hides the rectangle only when the parameter is not selected. But i need to even hide it if the workers workload doesn't have the stage.Can you send me a sample expression for the above condition.Thanks in Advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-13 : 11:26:41
|
| which field designates workers workload stage? |
 |
|
|
satsap
Starting Member
9 Posts |
Posted - 2008-11-13 : 11:50:12
|
| Fields!stage_type tells us the stages for that worker |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-13 : 11:52:28
|
| then i think it will something likeIIF(Parameter!Edu_ind.value = "N" Or Len(Fields!stage_type.value)=0, True, False) |
|
|
|
satsap
Starting Member
9 Posts |
Posted - 2008-11-13 : 12:01:19
|
| i have tried the expression you have provided, but it gives error saying dataset scope not specified. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-13 : 12:30:45
|
| so are you telling that if atleast one row in dataset has stage_type value then you need to show rectangle and else hide it? |
|
|
|
satsap
Starting Member
9 Posts |
Posted - 2008-11-13 : 13:36:55
|
| yes i have to show it if stage_type has atleast one row |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-13 : 23:09:57
|
| =IIF(Parameter!Edu_ind.value = "N" Or SUM(IIF(Len(Fields!stage_type.value)>0,1,0),"Yourdatasetname")=0, True, False) |
|
|
|
|
|
|
Rectangle Visiblity