Report sum expression

• Question

• 

  

  0

  Sign in to vote

  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

  Reply

  |

  Quote