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