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 |
|
krish001
Yak Posting Veteran
61 Posts |
 Posted - 2009-10-08 : 13:24:03
|
| hi,iam having a tabular report where iam displaying lowest values and underthat subtotal , subtotal should be lowest among them...Example..lowest values12305subtotal is minimum among those i.e '1' and not because '0' is the NULL value iam getting from database using isnull iam making NULL as 0plz solve this always iam getting 0 at subtotal instead of '1' |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-09 : 02:53:33
|
| Dont change null to 0MadhivananFailing to plan is Planning to fail |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-09 : 13:57:00
|
| =Min(IIF(Fields!yourfield.value=0,System.DBNull.Value,Fields!yourfield.value)) |
|
|
|
|
|
|
plz give suggestion