Dataset returns no record, how to compare in expression

Hi Anurd,

You can use the below expression to resolve your issue:

=IIF(CountRows("YourDataset2") > 0,IIF(Fields!Value2.value > 0,"Divide","DoNotDivide"),"DoNotDivide")

In this expression, first we are checking whether dataset2 is having records or not, if dataset is having records then we are checking whether Value2 field having some value > 0 or not, if it is having greater than 0 then we can use expression for division.

Hope, this will solve your issue.

Thanks,

Vishal