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 |
|
steve4134
Starting Member
24 Posts |
 Posted - 2010-12-19 : 16:23:22
|
I am not sure if this is the correct forum to post in but I have a request from a user who wants any 0 value to just be blank.... That's it. I work on a sql 2005 platform along with Microsoft 2005 reporting services. Thanks again.SteveI have attached a screen shot. Again any zero value you see just be invisible. |
|
|
rexyrexin
Starting Member
19 Posts |
Posted - 2010-12-20 : 09:01:03
|
| Write this in expression in every column. =iif(Fields!NetPay.Value<>0,True," ") |
 |
|
|
steve4134
Starting Member
24 Posts |
Posted - 2010-12-20 : 10:08:26
|
| Thank You rexyrexin. I will try this today. Steve |
|
|
|
|
|
|
Any zero is to be shown as invisible.