Report sum expression RRS feed

  • Question

  • Hi All,
      I am using vs report 2010. On my report i have columns want to sum fields with IIF expestion, 
      like Sum(IIF(Fields!ContractPrice.Value > 0 , Fields!ContractPrice.Value, 0)).
      But it is too slow, it takes about 1 minute to complete dozens of records. 
      Then I remove the IIF function,using Sum(Fields!ContractPrice.Value), It takes only 3 seconds.
      Has anyone met similar problem before? is it a by design issue or is there any workaround?
     Any help is realy appriciated
    Thanks in advance.
    Tuesday, August 2, 2011 8:01 AM

All replies