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 |
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
 Posted - 2009-09-29 : 09:18:40
|
| Hi GuysA field value for the field I have placed in the column section of the matrix contains a NULL value. The field that I am going to place in the data field also has NULL value associated with the record.So when I run the report I get an additional column with the NULL value in it. Is it possible to not to show this column? I have tried using an expression for visibility property but still not having any luck!Anyone have any ideas?Thanks |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-29 : 10:59:12
|
| Just a thought, can you exclude either in the SQL to remove the NULL column or NULL data element?John |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-29 : 13:52:46
|
| its possible to hide this field if values of field are all NULL. just use like=IIF(Fields!Yourfield.value Is Nothing,"True","False") |
|
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2009-09-30 : 05:11:39
|
| Thanks for that.The only thing is that it causes a gap in the middle of the matrix.Is it possible to move the remaining columns across to fill the gap? |
|
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2009-09-30 : 15:51:47
|
| Can you exclude the NULL values from dataset level? |
|
|
|
|
|
|
Not Displaying a NULL Column