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-09-08 : 12:27:50
|
| Few weeks ago, I posted on this problem.I need to set a textbox to display numeric data only - while ALLOWING NULLS. Right now, it displays the numeric data, but when the report is exported to excel - the user gets the numeric data as texts and they cannot perform some operations/actions on the huge amount of data, that they really need to.I could not find any property that could be set to do this.So, 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 .Is there any solution to this problem?Thanks. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-09-09 : 04:30:49
|
| How about setting NULL values to 0? This will get around both problems.. |
 |
|
|
sqlbug
Posting Yak Master
201 Posts |
Posted - 2010-09-09 : 12:12:40
|
| Hi Rick, Thanks for your response.The data comes from the database as nulls. Null has a different meaning than 0 in the report. We can't display 0 where there is no data.Any other ideas? |
|
|
|
|
|
|
Any solution at all?