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 : 13:32:23
|
| Hi,I am not sure, the first posting got into the right forum. So, I posted this for the second time.On my report, I don't want 0 being printed when there is no value. If there isn't any value just print blank.so I wrote (=IIF(fields!f.value = "" then , "", fields!f.value)everything worked fine. but when in the record field!f has value in it, the next and the rest record, even though there is no value in it, it printed 0.How, could I reset the field value after being printed?Thank you for your help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 13:50:07
|
| are you trying to aggregate them? If not, you shouldnt be worried about next and previous. what do you mean by no value? is it null or blank? |
 |
|
|
|
|
|
How to reset field value