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 |
|
sqlbug
Posting Yak Master
201 Posts |
 Posted - 2010-08-18 : 11:41:53
|
I need to set a textbox to have only numbers - while ALLOWING NULLS.
I want this simple thing - but apparently, SSRS has glitches so I am unable to do it.
First of all, I could not find any property that can be set to do this.
Then, I set the expression to force it to be numbers like:
=IIf(IsNumeric(Value) AndAlso Value >= 0, Value*1.0, Nothing)
But then I get "#Error" for all the cells where data is Null .
Any idea how to fix this?
Thanks.
|
|
|
|
|
|
How to set a textbox to have only numbers