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 |
|
lily_wibisana
Starting Member
29 Posts |
 Posted - 2008-09-30 : 09:29:16
|
| Hi There,I didn’t want to print 0 when Field1 doesn’t have value.So at the field expression I wrote IIF(fields!field1.value = “” , “”, fields!field1.value)It worked fine when in the record field1 is null.When field1 has the value in it, it printed the field1 value. But for the next record, even though field1 doesn’t have value, it kept printing the 0 value.How do I reset field1 value, to null after it has certain value at the previous record.Thank you for your help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 10:26:11
|
| what do you mean by previous record? what values you want to display as 0? |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-09-30 : 10:34:06
|
| Is this an Excel worksheet?Be One with the OptimizerTG |
|
|
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
Posted - 2008-10-06 : 09:33:40
|
| You seem to working on Visual Foxpro. This may not be the right forum. Well never mind try :-IIF(isempt(fields!field1.Value) or isnull(fields!field1.Value), "", fields!field1.value) |
|
|
|
|
|
|
How to Reset Field value