1
DATEDIFF("d", First(Fields!CurrentEffDate.Value, "dstvwGMDEntryDetails"), Now())

have this as an expression it works perfectly but before it does this i need 

Fields!IsTempProduct.Value, "dstvwProductDetails")=1

this if a product is a temporary product then show "BLANK" else run 

  DATEDIFF("d", First(Fields!CurrentEffDate.Value, "dstvwGMDEntryDetails"), Now())

i have tried this

=IIF(Sum(Fields!IsTempProduct.Value, "dstvwProductDetails")=1,"",DATEDIFF("d", First(Fields!CurrentEffDate.Value, "dstvwGMDEntryDetails"), Now())

but its moaning about them being in a separate datascope and its summing temp product temp product is like a flag so for normal products temp product =0 temp =1

Cœur
  • 37,241
  • 25
  • 195
  • 267
Cladback
  • 157
  • 1
  • 1
  • 9
  • Where are you trying to put the expression, how are the different datasets? A little more information on the data and requirement would help us indeed. – Abhishek Sep 23 '15 at 12:51
  • 1
    You are missing a closing bracket at end of your `iif`. – Anup Agrawal Sep 23 '15 at 14:09
  • Your expression should be `=IIF(Sum(Fields!IsTempProduct.Value, "dstvwProductDetails")=1, "", DATEDIFF("d", First(Fields!CurrentEffDate.Value, "dstvwGMDEntryDetails"), Now()))` – Pedram Dec 12 '15 at 13:51

0 Answers0