Viewing 2 posts - 1 through 2 (of 2 total)
You do not only have to care for "0" but also for "NULL" (nothing). If you do so, the statement is a bit more complicated, but it should work:
= IIf(Sum(Fields!Field2.Value)=0...
May 24, 2006 at 4:55 am
#639715
Hi Daniel,
instead if both the SQL table and the lookup table are not very latrge (<100.000 rows) you could use a "Merge Join" component to join sorted data from an...
May 22, 2006 at 4:15 am
#639185